Share:
About
Connect AI agents to Snowflake for governed data exploration: list databases and schemas, inspect table definitions, execute read-only or read/write SQL, and stream large result sets efficiently. Uses key-pair or password auth and respects Snowflake role-based access control.
Example tools
Illustrative tool names — the actual tool set is defined by the server at runtime.
query
Run a read-only SQL query
list_tables
List tables in the connected database
describe_table
Return column info for a table
Screenshots
No screenshots yet.
Frequently Asked Questions
Common questions about Snowflake MCP.
- What does the Snowflake MCP enable?
- The Snowflake MCP connects AI agents to Snowflake data warehouses. It supports listing databases/schemas, inspecting table definitions, and executing read-only or read/write SQL queries.
- How do I configure Snowflake authentication for this MCP?
- Authentication uses either key-pair or password-based credentials. The MCP respects Snowflake's role-based access control for governing agent permissions.
- Can I perform data modifications using this Snowflake MCP?
- Yes, this MCP supports executing both read-only and read/write SQL queries against your Snowflake warehouses, based on the granted permissions.
- Does this MCP require specific Snowflake roles or privileges?
- It depends on the specific operations the AI agent needs to perform. The MCP leverages Snowflake's native role-based access control (RBAC), so you should grant only the necessary privileges to the user or role used for authentication.
- What are typical use cases for the Snowflake MCP?
- Typical use cases include AI agents exploring data, generating reports, performing analyses, and streaming large result sets from Snowflake for further processing or display.
Install Snowflake MCP
Claude Desktop
Add this to claude_desktop_config.json.
{
"mcpServers": {
"snowflake": {
"command": "npx",
"args": [
"-y",
"@modelcontextprotocol/server-snowflake"
]
}
}
}Cursor
Add this to ~/.cursor/mcp.json.
{
"mcpServers": {
"snowflake": {
"command": "npx",
"args": [
"-y",
"@modelcontextprotocol/server-snowflake"
]
}
}
}VS Code
Add this to your workspace settings.json.
{
"mcp.servers": {
"snowflake": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"@modelcontextprotocol/server-snowflake"
]
}
}
}Reviews
Sign in to leave a review.
No reviews yet. Be the first!
Discussion(0)
No comments yet.