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.
“The official Snowflake MCP server. Cortex AI, object management, SQL orchestration, and semantic view consumption. 279 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 TOOLS AVAILABLE
OUR ASSESSMENT
- 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
ADOPTION METRICS
// Reading this279 stars on Snowflake-Labs/mcp. 2 commits on main in the last 30 days.
// Reading thisPairs with Tableau, Power BI, dbt, Google Analytics MCPs in the data category. Cortex AI tools differentiate from generic SQL MCPs.
SOURCES & VERIFICATION
We don't take any single directory's word for it. Before scoring, we cross-reference 5 public MCP sources, install the server ourselves against the clients we cover, and record when we last re-verified.
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
Web intelligence layer that turns any URL into LLM-optimised markdown. Handles JavaScript rendering, pagination, and structured extraction so your agent reads the live web instead of stale training data.
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.
Bright Data MCP
Web data extraction over the Bright Data network with two operating modes: Rapid Mode (free, basic search and scrape) and Pro Mode (60+ structured-dataset tools targeting Amazon, LinkedIn, Walmart, Instagram, and more).
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.