Snowflake
Tooling for Snowflake Cortex AI, object management, and SQL orchestration.
Snowflake
Tooling for Snowflake Cortex AI, object management, and SQL orchestration. With Lunar.dev MCPX, the MCP Gateway for secure and governed tool access, you connect the Snowflake MCP server to Claude, ChatGPT, Cursor, and any MCP client through one gateway that routes, authenticates, and governs every Snowflake tool call against your policies.
Why MCPX
MCPX is Lunar.dev's MCP Gateway. It sits between your AI agents and your MCP servers as a single gateway for every tool call, routing, authenticating, and governing traffic against your policies. Connect Snowflake once and govern it everywhere: role-based access per agent with on-behalf-of attribution, real-time visibility, and an immutable audit trail of who did what, all deployable inside your own VPC.
Tools content
- cortex_agent · Read-only
Cortex Agent tool that combines structured and unstructured data querying with configured custom tools. - cortex_search · Read-only
Semantic search against a configured Cortex Search service using Snowflake's REST API. - cortex_analyst · Read-only
Natural language to SQL conversion against a configured Cortex Analyst service. - create_object · Write
Create a Snowflake object (database, schema, table, view, warehouse, role, stage, user, and more). - drop_object · Write
Drop a Snowflake object (database, schema, table, view, warehouse, role, stage, user, and more). - create_or_alter_object · Write
Create or alter a Snowflake object. - describe_object · Read-only
Describe a Snowflake object. - list_objects · Read-only
List Snowflake objects of a given type. - run_snowflake_query · Write
Run a SQL query in Snowflake; DML and DDL queries are supported. - list_semantic_views · Read-only
List all semantic views in the account, database, or schema. - describe_semantic_view · Read-only
Describe a semantic view. - show_semantic_dimensions · Read-only
Show all semantic dimensions in the account, database, or schema. - show_semantic_metrics · Read-only
Show all semantic metrics in the account, database, or schema. - get_semantic_view_ddl · Read-only
Get the DDL for a semantic view. - write_semantic_view_query_tool · Read-only
Write a query statement to query a semantic view using dimensions, metrics, and facts. - query_semantic_view · Read-only
Write and run a statement to query a semantic view using dimensions, metrics, and facts.
Frequently asked questions
What is the Snowflake MCP server?
Tooling for Snowflake Cortex AI, object management, and SQL orchestration. Through Lunar.dev MCPX, Snowflake connects to any MCP-compatible AI client behind a single governed gateway.
How do I connect Snowflake to MCPX?
Add the Snowflake server in the MCPX control plane or your app.yaml, then point your AI client at your MCPX gateway. MCPX handles Config file and routes every Snowflake call through the gateway.
Is the Snowflake MCP server official?
Snowflake is a community-maintained MCP server. MCPX lets you risk-assess and sandbox it before rolling it out to your teams.
What authentication does Snowflake use with MCPX?
Snowflake uses Config file. MCPX enforces authentication at the gateway with token-based auth, OAuth, and role-based profiles, so you control which agents can invoke it.
How many tools does Snowflake expose in MCPX?
Snowflake's tools can be enabled or disabled individually in MCPX for least-privilege access.
