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 BasicWhat it can do
Your own API key6 actionsAnalytics and data

$ YOUR NEXT RUN

Claude CodeCodexCursorAny 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.AIDownload brief

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.

ActionWhat it does
# SNOWFLAKE_BASIC_DESCRIBE_TABLERetrieves detailed information for each column (including name, data type, kind, nullability, default value, and key status) in a specified snowflake table.
# SNOWFLAKE_BASIC_EXPLORE_COLUMNSRetrieves a sample of distinct values for specified columns from a snowflake table.
# SNOWFLAKE_BASIC_RUN_QUERYExecutes the given sql query in snowflake within the specified database and schema (which must exist and be accessible), automatically setting context first.
# SNOWFLAKE_BASIC_SHOW_DATABASESRetrieves a list of all databases available in the snowflake account.
# SNOWFLAKE_BASIC_SHOW_SCHEMASRetrieves a list of all schemas within a specified snowflake database.
# SNOWFLAKE_BASIC_SHOW_TABLESRetrieves 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 once; they stay with FlyMy.AI, never in a prompt or a chat.

    • Username - Username for basic auth Get API key →
    • Password - Password for basic auth Get API key →
    • 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 →
  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 →

Go to the source

Snowflake Basic in the docs →Snowflake Basic connection settings →Snowflake Basic website →Every MCP in the catalog →Usage 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.