# Snowflake Basic MCP - Tools, Setup and Examples | FlyMy.AI > Snowflake Basic MCP for Claude, Cursor and Codex. Analytics, with 6 actions. Your API key. See setup, examples and pricing. Page: https://flymy.ai/mcp/snowflake-basic/ MCP / Analytics and data # Snowflake Basic MCP: analytics Snowflake is a cloud-based data warehouse offering elastic scaling, secure data sharing, and SQL analytics across multiple cloud environments. Connect it to Claude, Codex, Cursor or any MCP client through one FlyMy.AI MCP. [Connect Snowflake Basic](https://flymy.ai/mcp/snowflake-basic/#connect) [What it can do](https://flymy.ai/mcp/snowflake-basic/#actions) Your own API key, 6 actions, Analytics and data $ YOUR NEXT RUN Claude Code, Codex, Cursor, Any agent ## Use Snowflake Basic MCP in your assistant Paste this prompt into Claude Code, Codex, Cursor or any agent. It reads the guide and helps you connect. ``` Read https://flymy.ai/skill.md and https://flymy.ai/mcp/snowflake-basic.md. Help me connect Snowflake Basic MCP to this assistant. Then help me run this task: Use Snowflake Basic to describe table. Ask me for the required inputs first and show the result. ``` [Open FlyMy.AI](https://app.flymy.ai/new-agent) [Download brief](https://flymy.ai/mcp/snowflake-basic.md) ## What Snowflake Basic MCP can do 6 actions in the FlyMy.AI catalog, the most used first. Your agent finds them through search_tools and calls the one the task needs. | Action | What it does | |---|---| | [#](https://flymy.ai/mcp/snowflake-basic/#method-SNOWFLAKE_BASIC_DESCRIBE_TABLE) `SNOWFLAKE_BASIC_DESCRIBE_TABLE` | Retrieves detailed information for each column (including name, data type, kind, nullability, default value, and key status) in a specified snowflake table. | | [#](https://flymy.ai/mcp/snowflake-basic/#method-SNOWFLAKE_BASIC_EXPLORE_COLUMNS) `SNOWFLAKE_BASIC_EXPLORE_COLUMNS` | Retrieves a sample of distinct values for specified columns from a snowflake table. | | [#](https://flymy.ai/mcp/snowflake-basic/#method-SNOWFLAKE_BASIC_RUN_QUERY) `SNOWFLAKE_BASIC_RUN_QUERY` | Executes the given sql query in snowflake within the specified database and schema (which must exist and be accessible), automatically setting context first. | | [#](https://flymy.ai/mcp/snowflake-basic/#method-SNOWFLAKE_BASIC_SHOW_DATABASES) `SNOWFLAKE_BASIC_SHOW_DATABASES` | Retrieves a list of all databases available in the snowflake account. | | [#](https://flymy.ai/mcp/snowflake-basic/#method-SNOWFLAKE_BASIC_SHOW_SCHEMAS) `SNOWFLAKE_BASIC_SHOW_SCHEMAS` | Retrieves a list of all schemas within a specified snowflake database. | | [#](https://flymy.ai/mcp/snowflake-basic/#method-SNOWFLAKE_BASIC_SHOW_TABLES) `SNOWFLAKE_BASIC_SHOW_TABLES` | Retrieves a list of tables, including their row counts and sizes in bytes, from a specified schema within a snowflake database. | ## Ask your agent Requests to paste as they are. Each one runs on the actions named under it. **“Use Snowflake Basic to describe table. Ask me for the required inputs first and show the result.”** uses `SNOWFLAKE_BASIC_DESCRIBE_TABLE` **“Use Snowflake Basic to explore columns. Ask me for the required inputs first and show the result.”** uses `SNOWFLAKE_BASIC_EXPLORE_COLUMNS` **“Use Snowflake Basic to run query. Ask me for the required inputs first and show the result.”** uses `SNOWFLAKE_BASIC_RUN_QUERY` ## Connect Snowflake Basic in a minute One MCP for every integration. Add it once, then every MCP in the catalog is a request away. 1. 01 ### Add FlyMy.AI Add the FlyMy.AI MCP to your assistant with one of the commands below and sign in. No key to copy. 2. 02 ### Add your Snowflake Basic credentials Paste them into the Snowflake Basic [connection settings](https://app.flymy.ai/mcp-configs#snowflake_basic) once; they stay with FlyMy.AI, never in a prompt or a chat. - **Username** - Username for basic auth [Get API key →](https://docs.snowflake.com/en/user-guide/programmatic-access-tokens) - **Password** - Password for basic auth [Get API key →](https://docs.snowflake.com/en/user-guide/programmatic-access-tokens) - **Account ID** - Your Snowflake account ID for authentication. Use the format 'myorganization-myaccount'. To find your account ID, click on your account in the bottom left... [Get API key →](https://docs.snowflake.com/en/user-guide/programmatic-access-tokens) 3. 03 ### Ask Paste a request from this page. Every run shows what it cost. Claude Code ``` claude mcp add --transport http flymyai https://mcp-agents.flymy.ai/mcp ``` Then run /mcp in Claude Code and sign in. Codex ``` codex mcp add flymy --url https://mcp-agents.flymy.ai/mcp ``` Then run codex mcp login flymy to sign in. claude.ai and Claude Desktop ``` https://mcp-agents.flymy.ai/mcp ``` Settings, Connectors, Add custom connector: paste this URL. ## Pay per run FlyMy.AI bills the run: the model and the tool's seconds. Calls go to your own Snowflake Basic account, under its plan and limits. No seats and no minimum. [See usage pricing →](https://flymy.ai/pricing/) ## More Analytics and data MCPs Product analytics, BI dashboards and databases. ### 21Risk 21RISK is a web application that simplifies working with checklists, audits, and actions, facilitating compliance and risk management processes 9 actions / your API key Link: https://flymy.ai/mcp/21risk/ ### AI or Not AI or Not - detect AI-generated/deepfake image, video, audio or text 5 actions / no setup Link: https://flymy.ai/mcp/aiornot/ ### Amplitude Amplitude analytics: event segmentation, funnels, retention, cohorts 51 actions / your API key Link: https://flymy.ai/mcp/amplitude/ ### Baremetrics Baremetrics subscription analytics: sources, MRR/ARR metrics, customers, subscriptions, plans 8 actions / your API key Link: https://flymy.ai/mcp/baremetrics/ ### Baserow Baserow is an open-source database tool that lets teams build no-code data applications, collaborate on records, and integrate with other services for data... 2 actions / your API key Link: https://flymy.ai/mcp/baserow/ ### beaconcha.in Beaconchain is a platform providing real-time data and analytics for the Ethereum 2.0 Beacon Chain, offering insights into validators, blocks, and network... 2 actions / your API key Link: https://flymy.ai/mcp/beaconchain/ ## Go to the source [Snowflake Basic in the docs →](https://docs.flymy.ai/mcp/apps/snowflake_basic), [Snowflake Basic connection settings →](https://app.flymy.ai/mcp-configs#snowflake_basic), [Snowflake Basic website →](https://www.snowflake.com/en/), [Every MCP in the catalog →](https://flymy.ai/mcp/#catalog), [Usage pricing →](https://flymy.ai/pricing/) From the FlyMy.AI platform catalog of 2026-11-03: name, description, actions and setup as the platform lists them. Examples are requests to paste, not recorded runs. --- For agents: the FlyMyAI operating guide (sign up, connect, run models, tools and agents) is https://flymy.ai/skill.md, and https://flymy.ai/llms.txt lists the other pages and the documentation.