Run SQL queries, list databases, schemas, tables, and inspect column definitions on Snowflake — AI-native cloud data warehouse access.
Use with AI AssistantsMCP
Connect Claude, Cursor, or any MCP-compatible client — then call tools directly
① Add This MCP Server
Paste into your AI client config — then all its tools are available instantly.
{
"mcpServers": {
"snowflake": {
"url": "https://mcp.aerostack.dev/s/aerostack/mcp-snowflake",
"headers": {
"Authorization": "Bearer YOUR_AEROSTACK_TOKEN"
}
}
}
}Replace YOUR_AEROSTACK_TOKEN with your API token from the dashboard.
② Call a Tool
Ask your AI assistant to call a specific tool, or send raw JSON-RPC:
Natural Language Prompt
“Use the _ping tool to verify snowflake connectivity by running select current_version(). used internally by aerostack to validate credentials”
Using a Workspace?
Add this MCP to your Workspace — your team shares one token, secrets are stored securely, and every AI agent in the workspace can call it without per-user setup.
Run SQL queries, list databases, schemas, tables, and inspect column definitions on Snowflake — AI-native cloud data warehouse access.
Give your AI agents full access to Snowflake. Execute SQL with CTEs, window functions, semi-structured data, and time travel. Browse databases, schemas, and tables, inspect column definitions, and manage virtual warehouses.
Live endpoint: https://mcp.aerostack.dev/s/aerostack/mcp-snowflake
| Tool | Description |
|---|---|
_ping | Verify Snowflake connectivity and version |
list_databases | List all databases with owner and retention days |
list_schemas | List schemas in a database |
list_tables | List tables in a schema with row count, size, and cluster keys |
describe_table | Get column definitions — name, type, nullable, default, comment |
query | Execute SQL and return results (auto-adds LIMIT if missing) |
list_warehouses | List virtual warehouses with size, state, auto-suspend |
| Variable | Required | Description | How to Get |
|---|---|---|---|
SNOWFLAKE_ACCOUNT | Yes | Snowflake account identifier (e.g. "xy12345.us-east-1") | app.snowflake.com → Admin → Accounts → your account locator |
SNOWFLAKE_USERNAME | Yes | Login username | Your Snowflake username (or create a service user) |
SNOWFLAKE_PASSWORD | Yes | Login password | Your Snowflake password |
SNOWFLAKE_WAREHOUSE | No | Virtual warehouse name (default: COMPUTE_WH) | SHOW WAREHOUSES in Snowflake |
SNOWFLAKE_DATABASE | No | Default database for queries | SHOW DATABASES in Snowflake |
Best practice: Create a dedicated service user with a role scoped to read-only access on specific databases.
SNOWFLAKE_ACCOUNT, SNOWFLAKE_USERNAME, SNOWFLAKE_PASSWORD, and optionally SNOWFLAKE_WAREHOUSE and SNOWFLAKE_DATABASE under Project → Secrets"List all databases in my Snowflake account"
"Show me the tables in the ANALYTICS schema of the PROD database"
"Describe the columns of the EVENTS table"
"Run: SELECT DATE_TRUNC('day', created_at) as day, COUNT(*) FROM events GROUP BY 1 ORDER BY 1 DESC LIMIT 30"
"What warehouses are running right now?"
curl -X POST https://mcp.aerostack.dev/s/aerostack/mcp-snowflake \
-H 'Content-Type: application/json' \
-H 'X-Mcp-Secret-SNOWFLAKE-ACCOUNT: xy12345.us-east-1' \
-H 'X-Mcp-Secret-SNOWFLAKE-USERNAME: myuser' \
-H 'X-Mcp-Secret-SNOWFLAKE-PASSWORD: mypassword' \
-d '{"jsonrpc":"2.0","id":1,"method":"tools/call","params":{"name":"list_databases","arguments":{}}}'
MIT
Live Endpoint
https://mcp.aerostack.dev/s/aerostack/mcp-snowflake
Sub-50ms globally · Zero cold start
@aerostack
Pre-built functions for the most common MCP tool patterns. Clone, extend, and deploy.
by @aerostack
Discover and invoke any MCP, Function, or Skill published to the Aerostack marketplace — the universal AI capability hub.
by @aerostack
Search indexes, manage records, browse data, and configure ranking in Algolia — AI-native instant search access.
by @aerostack
Query documents, run AQL, traverse graphs, and manage collections in your ArangoDB database — AI-native multi-model database access.
by @aerostack
Post, schedule, and analyze social media across 13 platforms — Facebook, Instagram, X, LinkedIn, TikTok, Bluesky, Threads, Reddit, Pinterest, YouTube, Telegram, Snapchat, Google Business.
by @aerostack
Manage projects, to-dos, messages, schedules, and campfire chats in Basecamp — AI-native project management.
by @aerostack
Run SQL queries, list datasets and tables, inspect schemas, and export results from Google BigQuery — AI-native data warehouse access.
Yes. The query tool sends SQL to Snowflake's REST API using the credentials stored in Aerostack. Results return as a JSON array of row objects. Claude can run SELECT, CTEs, and window functions — DDL depends on the role granted to the service account.
Claude calls list_databases, then list_schemas for the target database, then list_tables for the schema, then describe_table for column names and types. This four-step schema walk runs automatically when you say 'explore the ANALYTICS database'.
list_warehouses returns all warehouses visible to the service account. You can specify a warehouse in the query tool call. Using an XSMALL warehouse for exploratory queries and switching to MEDIUM for large aggregations keeps Snowflake credit consumption predictable.
Yes, as long as the table has a non-zero DATA_RETENTION_TIME_IN_DAYS. Claude can include AT (TIMESTAMP => ...) or BEFORE (STATEMENT => ...) clauses in the query string — the MCP passes SQL verbatim, so any valid Snowflake syntax works.