Snowflake MCP server by CData for read-only querying of live Snowflake data from AI agents and MCP clients.
If you want an AI assistant working directly with Snowflake, the snowflake mcp server is the bridge. Snowflake MCP server by CData for read-only querying of live Snowflake data from AI agents and MCP clients.
:heavy_exclamation_mark: This project builds a local, read-only MCP server. For fully remote MCP access, check out the first managed MCP platform: CData Connect AI. For locally hosted, full read, write, update, delete, and action capabilities and a simplified setup, check out our CData MCP Server for Snowflake. ## Purpose We created this read-only MCP Server to allow LLMs (like Claude Desktop) to query live data Snowflake supported by the CData JDBC Driver for Snowflake.
Once connected, the assistant can call these 3 tools directly:
snowflake_get_tables — The snowflake_get_tables tool exposed by this serversnowflake_get_columns — The snowflake_get_columns tool exposed by this serversnowflake_run_query — The snowflake_run_query tool exposed by this serverSetup follows the standard MCP pattern: clone or install the server, then register it in your client's configuration file and restart the client. The configuration snippets on this page cover Claude Desktop, Claude Code and Cursor.
| Tool | What it does |
|---|---|
| snowflake_get_tables | The snowflake_get_tables tool exposed by this server. |
| snowflake_get_columns | The snowflake_get_columns tool exposed by this server. |
| snowflake_run_query | The snowflake_run_query tool exposed by this server. |
**Linux/Mac**
```json
{
"mcpServers": {
"{classname_dash}": {
"command": "/PATH/TO/java",
"args": [
"-jar",
"/PATH/TO/CDataMCP-jar-with-dependencies.jar",
"/PATH/TO/snowflake.prp"
]
},
...
}
}Configuration as documented by the project. Restart the client after saving.
Read-only SQL access to Postgres — let your assistant inspect schemas and answer questions from real data.
Manage your whole Supabase project in conversation — database, auth, storage, Edge Functions and branches.
Query, modify and analyse local SQLite databases in conversation — the fastest way to chat with a data file.
Metabase ships its own MCP endpoint — search your BI content, build and run queries, and save questions and dashboards without leaving the chat.
Official MongoDB server covering data, schemas and Atlas management — from find queries to spinning up clusters.
Serverless Postgres with database branching — point your assistant at Neon and let it work on disposable copies.