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"
]
}
}
}