Snowflake MCP
The official Snowflake MCP server. Cortex AI access, object management, SQL orchestration, and semantic view consumption. 279 GitHub stars and 2 commits on main in the last 30 days.
INSTALL THIS SERVER
{
"mcpServers": {
"snowflake": {
"command": "python",
"args": [
"-m",
"snowflake_labs_mcp"
],
"env": {
"SNOWFLAKE_ACCOUNT": "your-account.region",
"SNOWFLAKE_USER": "agent-service-user",
"SNOWFLAKE_PASSWORD": "YOUR_PASSWORD",
"SNOWFLAKE_ROLE": "AGENT_READ_ROLE",
"SNOWFLAKE_WAREHOUSE": "AGENT_WH"
}
}
}
}
{
"mcpServers": {
"snowflake": {
"command": "python",
"args": [
"-m",
"snowflake_labs_mcp"
],
"env": {
"SNOWFLAKE_ACCOUNT": "your-account.region",
"SNOWFLAKE_USER": "agent-service-user",
"SNOWFLAKE_PASSWORD": "YOUR_PASSWORD",
"SNOWFLAKE_ROLE": "AGENT_READ_ROLE",
"SNOWFLAKE_WAREHOUSE": "AGENT_WH"
}
}
}
}
{
"mcpServers": {
"snowflake": {
"command": "python",
"args": [
"-m",
"snowflake_labs_mcp"
],
"env": {
"SNOWFLAKE_ACCOUNT": "your-account.region",
"SNOWFLAKE_USER": "agent-service-user",
"SNOWFLAKE_PASSWORD": "YOUR_PASSWORD",
"SNOWFLAKE_ROLE": "AGENT_READ_ROLE",
"SNOWFLAKE_WAREHOUSE": "AGENT_WH"
}
}
}
}
{
"mcpServers": {
"snowflake": {
"command": "python",
"args": [
"-m",
"snowflake_labs_mcp"
],
"env": {
"SNOWFLAKE_ACCOUNT": "your-account.region",
"SNOWFLAKE_USER": "agent-service-user",
"SNOWFLAKE_PASSWORD": "YOUR_PASSWORD",
"SNOWFLAKE_ROLE": "AGENT_READ_ROLE",
"SNOWFLAKE_WAREHOUSE": "AGENT_WH"
}
}
}
}
{
"mcpServers": {
"snowflake": {
"command": "python",
"args": [
"-m",
"snowflake_labs_mcp"
],
"env": {
"SNOWFLAKE_ACCOUNT": "your-account.region",
"SNOWFLAKE_USER": "agent-service-user",
"SNOWFLAKE_PASSWORD": "YOUR_PASSWORD",
"SNOWFLAKE_ROLE": "AGENT_READ_ROLE",
"SNOWFLAKE_WAREHOUSE": "AGENT_WH"
}
}
}
}
7 SELECTED TOOLS
OUR ASSESSMENT
Snowflake-Labs/mcp ships the official Snowflake MCP server. Tool surface covers SQL execution, database and schema discovery, Cortex Search and Cortex Complete (Snowflake LLM and retrieval), and semantic view listing. Distinguishes from a generic Postgres MCP by exposing Cortex AI primitives and Snowflake-specific governance metadata.
- 279 GitHub stars and Apache-2.0 license.
- Snowflake official maintenance under the Snowflake-Labs org.
- Cortex Search and Cortex Complete tools expose Snowflake LLM and retrieval inside the agent.
- Semantic view listing surfaces governed analyst views, not just raw tables.
- 2 commits on main in the last 30 days.
- Snowflake account required; not a self-hosted MCP.
- Cortex AI tools incur per-query Snowflake compute cost beyond the underlying warehouse.
- Service-account permissioning is the operator responsibility; default role can over-grant.
Use a dedicated service-account user with a role scoped to the specific databases the agent should reach. Cortex Complete and execute_query carry compute cost; set per-warehouse spending limits in the Snowflake admin console.
Snowflake-first analytics teams adopting agentic data workflows; Cortex AI users who want LLM completions inside the warehouse exposed to the agent; teams using semantic views for analyst-friendly query surfaces.
TECHNICAL DETAILS
RECORDED ADOPTION METRICS
Saved directory snapshots. Record last checked MAY 5, 2026. The review date above does not refresh these figures.
// Recorded note279 stars on Snowflake-Labs/mcp. 2 commits on main in the last 30 days.
// Recorded notePairs with Tableau, Power BI, dbt, Google Analytics MCPs in the data category. Cortex AI tools differentiate from generic SQL MCPs.
SOURCES & RECORDED CHECKS
These are the directory listings and check details held in this record. Client compatibility, directory listings and installation testing are separate signals. Recorded client names describe the scope of a check; they do not establish a security assessment or a recurring test schedule.
The same server, 5 different lenses. We reconcile these signals into our editorial score, which is why our number sometimes diverges from a directory-aggregate star count.
| Source | Their rating | Their star count | Their downloads | Last synced |
|---|---|---|---|---|
| AutomationSwitch This page | 4.4editorial | 279 | — | MAY 5, 2026 |
| PulseMCP | — unrated | unavailable | unavailable | MAY 5, 2026 |
| MCP.so | — unrated | unavailable | unavailable | MAY 5, 2026 |
| Glama | — unrated | unavailable | unavailable | MAY 5, 2026 |
| Smithery | — unrated | unavailable | unavailable | MAY 5, 2026 |
| Official MCP Registry | — unrated | unavailable | unavailable | MAY 5, 2026 |
// Counts are directory-reported; we don't adjust them. Discrepancies usually come from different snapshot times or star-caching.
OTHER DATA / ANALYTICS MCP SERVERS
Firecrawl
Official Firecrawl MCP server for web search, page extraction and site discovery, with Markdown and structured content workflows.
Google Analytics MCP
Official Google MCP server for Google Analytics 4. Query reports, dimensions, metrics, custom audiences, and admin entities through MCP. 1,981 GitHub stars and 5 commits on main in the last 30 days. Apache-2.0.
Apify Actors MCP
Apify Actors as MCP tools: 6,000+ web scrapers, automation actors, and AI agents callable from Claude, Cursor, or any MCP client. Hosted streamable transport at https://mcp.apify.com plus stdio via npx. Dynamic actor discovery at runtime.
dbt MCP
Official dbt Labs MCP server covering SQL execution, Semantic Layer queries, Discovery API, dbt CLI, Admin API, dbt Codegen, dbt LSP, and Product Docs. 41 commits on main in the last 30 days, joint top cadence in this batch.
Tableau MCP
Tableau's official MCP server. Lets agents see and understand Tableau workbooks, datasources, and views over MCP. 259 GitHub stars and 12 commits on main in the last 30 days.
AntV Chart MCP
Visualization MCP and skills with 25+ chart types using AntV. Generate charts and analyse data from inside agents. 4,047 GitHub stars and 2 commits on main in the last 30 days.
DISCUSS YOUR
MCP REQUIREMENTS.
Evaluating a server, scoping an internal deployment, or working out whether MCP is the right fit at all. Start the conversation and we will point you at the right piece of the ecosystem.