Snowflake MCP
Run SQL queries, inspect schemas, manage Snowflake tasks and streams for data warehouse workflows.
Overview
| Catalog ID | mcp-snowflake |
| Category | database |
| Auth method | API key |
| Blast radius | moderate |
| Trust | Verified — published by cendriix |
| Version | 1.0.0 |
| Regions | us-east-1, eu-west-1 |
Tools
| Tool | Description |
|---|---|
run_query | Execute a SQL query against Snowflake. |
list_databases | List Snowflake databases. |
describe_table | Get the schema of a table. |
create_task | Create a Snowflake task (scheduled SQL). |
get_query_history | Get recent query history. |
Tool parameters
run_query
Execute a SQL query against Snowflake.
| Parameter | Type | Description | |
|---|---|---|---|
query | string | required | SQL query |
warehouse | string | optional | Warehouse name |
database | string | optional | Database name |
describe_table
Get the schema of a table.
| Parameter | Type | Description | |
|---|---|---|---|
database | string | optional | Database name |
schema | string | optional | Schema name |
table_name | string | required | Table name |
create_task
Create a Snowflake task (scheduled SQL).
| Parameter | Type | Description | |
|---|---|---|---|
name | string | required | Task name |
warehouse | string | required | Warehouse |
schedule | string | optional | Cron schedule |
sql | string | required | SQL statement to execute |
get_query_history
Get recent query history.
| Parameter | Type | Description | |
|---|---|---|---|
warehouse | string | optional | Filter by warehouse |
limit | integer | optional | Max results |
Installing
- In Cendriix, go to Settings → MCPs
- Find Snowflake and click Install
- Paste your API key after installing. It is validated, then encrypted at rest in a secrets vault scoped to your tenant.
- Click Test Connection to run a health check and list available tools
Authentication. Paste your API key after installing. It is validated, then encrypted at rest in a secrets vault scoped to your tenant.
Blast radius
This MCP is classified moderate. This MCP can create and update records in the connected service, but cannot delete infrastructure.
Every tool invocation is recorded in your Audit Log. You can remove this MCP at any time from Settings → MCPs, which revokes tool access immediately.
Further reading
- MCP Marketplace — browse and install MCPs
- Policies & Guardrails — approval gates and blast radius
- Audit Log — review tool invocations
Last updated on