MCP server for executing Snowflake queries
| Tool name | Description | Destructive? |
|---|---|---|
| test_connection | โ no | |
| execute_queryโ | โ yes | |
| explain_query | โ no | |
| list_databases | โ no | |
| list_schemas | โ no |
| list_tables | โ no | |
| list_views | โ no | |
| describe_table | โ no | |
| get_table_sample | โ no | |
| get_table_row_count | โ no | |
| get_primary_keys | โ no |
{
"mcpServers": {
"snowflake-1": {
"command": "npx",
"args": [
"-y",
"snowflake-mcp"
]
}
}
}