Which integrations are available for this server?

Provides tools for querying and exploring a Snowflake data warehouse, including listing databases, schemas, tables, and warehouses, describing table schemas, sampling data, and executing SQL queries (read-only by default).

How do I use snowflake-analytics-mcp-server?

1. Click on "Install Server". 2. Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state. 3. In the chat, type @ followed by the MCP server name and your instructions, e.g., "@snowflake-analytics-mcp-server list the tables in the ANALYTICS_DB.PUBLIC schema" That's it! The server will respond to your query, and you can continue using it as needed. Here is a step-by-step guide with screenshots.

de en es ja ko ru zh

snowflake-analytics-mcp-server

by Analytics-model-LTD

Overview Schema Related Servers Score Discussions

TypeScript

Remote

snowflake-analytics-mcp-server

A Model Context Protocol server for Snowflake, built for the Analytics Model platform. It connects to Snowflake via the official snowflake-sdk driver (pure Node — no client binary needed, unlike the Oracle server) and exposes table-discovery and query tools over stdio. Runnable directly with npx.

The list_tables tool returns the platform's exact table-discovery envelope, so it drops straight into the same fetchMcpTables flow as the Clio, Dropbox and Shopify servers.

Install

npm install -g snowflake-analytics-mcp-server
# or run directly (no install):
npx -y snowflake-analytics-mcp-server

Related MCP server: IcebergMCP

Configuration

All credentials come from environment variables.

Variable	Required	Default	Description
`SNOWFLAKE_ACCOUNT`	✅	—	Account identifier, e.g. `xy12345.eu-central-1` or `orgname-account_name`
`SNOWFLAKE_USERNAME`	✅	—	Login name
`SNOWFLAKE_PASSWORD`	✅ (password auth)	—	Password (required unless using key-pair/OAuth)
`SNOWFLAKE_WAREHOUSE`	—	—	Virtual warehouse to use
`SNOWFLAKE_DATABASE`	recommended	—	Default database (used by `list_tables` when no arg is given)
`SNOWFLAKE_SCHEMA`	recommended	—	Default schema
`SNOWFLAKE_ROLE`	—	—	Role to assume
`SNOWFLAKE_AUTHENTICATOR`	—	`SNOWFLAKE`	`SNOWFLAKE` (password), `SNOWFLAKE_JWT` (key-pair), `OAUTH`
`SNOWFLAKE_PRIVATE_KEY`	key-pair	—	PEM private key contents
`SNOWFLAKE_PRIVATE_KEY_PATH`	key-pair	—	Path to a PEM private key file (alternative to above)
`SNOWFLAKE_PRIVATE_KEY_PASSPHRASE`	—	—	Passphrase, if the key is encrypted
`SNOWFLAKE_TOKEN`	OAuth	—	OAuth access token (with `SNOWFLAKE_AUTHENTICATOR=OAUTH`)
`SNOWFLAKE_READ_ONLY`	—	`true`	Blocks writes/DDL in `execute_query`. Set `false` to allow them
`SNOWFLAKE_ROW_LIMIT`	—	`1000`	Hard cap on returned rows
`QUERY_TIMEOUT_MS`	—	`60000`	Client-side query timeout

Account identifier tip

Use hyphens, not underscores, in the account identifier if a client has trouble connecting (e.g. orgname-account-name).

Claude Desktop config

Add to claude_desktop_config.json:

{
  "mcpServers": {
    "snowflake": {
      "command": "npx",
      "args": ["-y", "snowflake-analytics-mcp-server"],
      "env": {
        "SNOWFLAKE_ACCOUNT": "xy12345.eu-central-1",
        "SNOWFLAKE_USERNAME": "ANALYTICS_USER",
        "SNOWFLAKE_PASSWORD": "••••••••",
        "SNOWFLAKE_WAREHOUSE": "COMPUTE_WH",
        "SNOWFLAKE_DATABASE": "ANALYTICS_DB",
        "SNOWFLAKE_SCHEMA": "PUBLIC",
        "SNOWFLAKE_ROLE": "ANALYST"
      }
    }
  }
}

Key-pair auth example

"env": {
  "SNOWFLAKE_ACCOUNT": "xy12345.eu-central-1",
  "SNOWFLAKE_USERNAME": "ANALYTICS_USER",
  "SNOWFLAKE_AUTHENTICATOR": "SNOWFLAKE_JWT",
  "SNOWFLAKE_PRIVATE_KEY_PATH": "/path/to/rsa_key.p8",
  "SNOWFLAKE_PRIVATE_KEY_PASSPHRASE": "••••••••",
  "SNOWFLAKE_DATABASE": "ANALYTICS_DB",
  "SNOWFLAKE_SCHEMA": "PUBLIC"
}

Tools

Tool	Args	Description
`list_tables`	`database?`, `schema?`, `include_views?`	Platform contract. Returns `{ table_name }[]` in the double-wrapped envelope for `fetchMcpTables`
`test_connection`	—	Returns version, account, user, role, warehouse, database, schema
`list_databases`	—	Databases visible to the current role
`list_schemas`	`database?`	Schemas in a database
`list_warehouses`	—	Warehouses with size/state
`describe_table`	`table`, `database?`, `schema?`	Columns, types, nullability, defaults
`get_table_sample`	`table`, `database?`, `schema?`, `limit?`	Preview rows from a table
`execute_query`	`query`	Run SQL. Read-only unless `SNOWFLAKE_READ_ONLY=false`

Platform integration note

list_tables matches the confirmed envelope used by the Shopify/Clio servers:

{
  "is_success": true,
  "status_code": 200,
  "data": "[{\"table_name\":\"ORDERS\"},{\"table_name\":\"CUSTOMERS\"}]", // double-stringified
  "message": "Found 2 table(s).",
  "requestedPayload": { "database": "ANALYTICS_DB", "schema": "PUBLIC", "include_views": true }
}

Because Snowflake exposes arbitrary user tables (unlike Clio's fixed resource categories, which each had a list_<resource> tool), there is no per-table tool. When a user selects a table in the platform, the backend should fetch its rows via get_table_sample (preview) or execute_query (SELECT * FROM <table>), rather than calling a tool named after the table. Confirm this mapping with the backend before wiring the row-fetch step.

License

MIT

Install Server

license - not found

quality

maintenance

How are these scores calculated?

Maintenance

–Maintainers

–Response time

–Release cycle

–Releases (12mo)

Commit activity

Resources

GitHub Repository

Need Help?

Related Servers

Unclaimed servers have limited discoverability.

Looking for Admin?

If you are the server author, to access and configure the admin panel.

Tools

Related MCP Servers

Snowflake MCP Service
Databases Cloud Platforms
davidamom
A
license
Not graded
quality
D
maintenance
A Model Context Protocol server that provides access to Snowflake databases for any MCP-compatible client, allowing execution of SQL queries with automatic connection management.
Updated a year ago (2025-09-25 13:27 UTC)
5
MIT
IcebergMCP
Databases Search
ryft-io
A
license
C
quality
D
maintenance
An MCP server that enables natural language interaction with Apache Iceberg data lakehouses, allowing users to query table metadata, schemas, and properties through Claude, Cursor, or other MCP clients.
Updated a year ago (2025-04-14 15:41 UTC)
5
41
Apache 2.0
DataPilot MCP Server
Databases Developer Tools Code Execution
rickyb30
A
license
A
quality
D
maintenance
A Model Context Protocol server that enables natural language interaction with Snowflake databases through AI guidance, supporting core database operations, warehouse management, and AI-powered data analysis features.
Updated a year ago (2025-07-08 02:18 UTC)
13
2
MIT
MCP Snowflake Server NSP
Cloud Platforms Databases
nsphung
A
license
A
quality
A
maintenance
A Snowflake MCP server — SQL queries, schema exploration, and data insights for AI assistants
Updated 12 days ago (2026-08-12 12:35 UTC)
6
2
MIT

View all related MCP servers

Related MCP Connectors

mcp
GibsonAI MCP server: manage your databases with natural language
Microsoft MCP Server for Enterprise
Official Microsoft MCP Server to query Microsoft Entra data using natural language
secureflows-mcp-server
MCP server for secureFlows: token-free URL builders and integration-linting tools for AI agents.

View all MCP Connectors

Latest Blog Posts

Who's Calling? MCP Hosts Are an Identity Blind Spot (And the Spec Knows It)
By Om-Shree-0709 on July 25, 2026.
mcp
Agent Identity
OAuth 2.1
Your AI Chatbot Just Exposed Your CEO's Salary to an Intern
By Om-Shree-0709 on July 2, 2026.
Agent Identity
MCP Security
OAuth Delegation
Why MCP Servers Need Execution Sandboxing (And Why Your Current Stack Isn't Enough)
By Om-Shree-0709 on June 30, 2026.
Agentic Ai
Prompt Injection
WebAssembly

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/Analytics-model-LTD/snowflake-analytics-mcp-server'

If you have feedback or need assistance with the MCP directory API, please join our Discord server

snowflake-analytics-mcp-server

Install

Configuration

Account identifier tip

Claude Desktop config

Key-pair auth example

Tools

Platform integration note

License

Maintenance

Resources

Looking for Admin?

Tools

Related MCP Servers

Snowflake MCP Service

IcebergMCP

DataPilot MCP Server

MCP Snowflake Server NSP

Related MCP Connectors

Latest Blog Posts

MCP directory API