What does snowflake-mcp-server-by-cdata do?
It lets LLMs like Claude Desktop query live Snowflake data by asking natural-language questions, without needing to write SQL. It is a read‑only server based on the CData JDBC Driver for Snowflake.
Snowflake MCP Server By Cdata
@CDataSoftware
基本信息
关于 Snowflake MCP Server By Cdata
This read-only MCP Server allows you to connect to Snowflake data from Claude Desktop through CData JDBC Drivers. Free (beta) read/write servers available at
Snowflake MCP Server By Cdata 配置
Snowflake MCP Server By Cdata 工具
工具列表暂未提供
当前收录暂时没有可展示的工具列表，不代表服务没有工具。请查阅项目文档了解支持的能力。
工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。
概览
What is snowflake-mcp-server-by-cdata?
snowflake-mcp-server-by-cdata is a read-only MCP (Model Context Protocol) server that allows LLMs like Claude Desktop to query live data in Snowflake using natural language. It wraps the CData JDBC Driver for Snowflake and exposes Snowflake tables as relational SQL models through a simple MCP interface.
How to use snowflake-mcp-server-by-cdata?
Clone the repository, build it with mvn clean install, then download and license the CData JDBC Driver for Snowflake. Create a .prp file with your JDBC connection string, driver path, and settings. Configure Claude Desktop by adding the server to its claude_desktop_config.json with the path to Java and the JAR and .prp file. The server uses stdio transport and must run on the same machine as the client.
Key features of snowflake-mcp-server-by-cdata
- Read‑only querying of Snowflake data via natural language.
- Built on the CData JDBC Driver for Snowflake.
- Exposes Snowflake tables as relational SQL models.
- Provides tools:
get_tables,get_columns, andrun_query(SQL SELECT). - Works with Claude Desktop and other MCP clients using
stdio. - MIT licensed and open source.
Use cases of snowflake-mcp-server-by-cdata
- Ask an LLM to analyze Snowflake data without writing SQL.
- Let Claude Desktop answer questions about live Snowflake tables.
- Quickly explore Snowflake schemas and run SELECT queries from a chatbot.
- Integrate Snowflake data into AI workflows for reporting or analytics.
常见问题
What dependencies are required?
You need Java, Maven to build, and the CData JDBC Driver for Snowflake (requires installation and licensing). The server runs on any OS with Java.
Is snowflake-mcp-server-by-cdata read‑only?
Yes, this MCP server is read‑only. For full CRUD and action capabilities, CData offers a separate beta MCP Server for Snowflake with a simplified setup.
What transport does it use?
The server uses `stdio` transport, so it must run on the same machine as the MCP client (e.g., Claude Desktop).
Where is the data stored?
Data remains in Snowflake; the server only queries live data. No local persistence is used.
数据库 分类下的更多 MCP 服务器
Xata MCP Server
The Xata MCP server lets AI assistants and agents interact with your Xata organizations, projects, and Postgres database branches.
mcp-server-qdrant: A Qdrant MCP server
qdrantAn official Qdrant Model Context Protocol (MCP) server implementation
637
Neon MCP Server
neondatabase-labsMCP server for interacting with Neon Management API and databases
617
MCP Server for MySQL based on NodeJS
benborlaA Model Context Protocol server that provides read-only access to MySQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.
1.9K
MCP DB Wizard
srmadscienceOracle MCP server with no run-sql tool: It generates tools for each of the PL/SQL procedures, tables and approved SQL you choose. The server doesn't expose a SQL prompt, and can't reveal how it's connected to Oracle.
1
评论