mysql-mcp-server-by-cdata

Name: mysql-mcp-server-by-cdata
Author: CDataSoftware

@CDataSoftware

关于 mysql-mcp-server-by-cdata

This read-only MCP Server allows you to connect to MySQL data from Claude Desktop through CData JDBC Drivers. Free (beta) read/write servers available at

#mysql #mcp-server #cdata

基本信息

分类

数据库

许可证

MIT license

运行时

java

传输方式

stdio

发布者

CDataSoftware

配置

暂无标准配置

该服务器的 README 中没有可解析的 MCP 配置块，请前往代码仓库查看安装说明。

代码仓库

工具

未检测到工具

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

What is mysql-mcp-server-by-cdata?

mysql-mcp-server-by-cdata is a read-only MCP (Model Context Protocol) server that allows LLMs like Claude Desktop to query live MySQL data using natural language. It wraps the CData JDBC Driver for MySQL, exposing database tables and columns as SQL models through an MCP interface.

How to use mysql-mcp-server-by-cdata?

Clone the repository, build the JAR with Maven (mvn clean install), download and license the CData JDBC Driver for MySQL, create a .prp file with your JDBC connection string and driver path, then add the server to your Claude Desktop config file. Run the server via java -jar CDataMCP-jar-with-dependencies.jar <path-to>.prp. The server communicates over stdio, so the client must be on the same machine.

Key features of mysql-mcp-server-by-cdata

Read-only access to MySQL data via natural language queries.
Uses CData JDBC Driver for live connectivity to MySQL.
Exposes tools: get_tables, get_columns, and run_query (SQL SELECT only).
Setup requires building the JAR and configuring the JDBC driver.

Use cases of mysql-mcp-server-by-cdata

Query MySQL databases from Claude Desktop without writing SQL.
Retrieve live business insights by asking natural language questions.
Explore MySQL table schemas before running SELECT queries.
Enable non-technical users to get data from MySQL through chat.

FAQ from mysql-mcp-server-by-cdata

Is this server read-only?

Yes, this project explicitly builds a read-only MCP server. For full CRUD capabilities, use the free CData MCP Server for MySQL (beta).

What are the runtime requirements?

Java and Maven are required to build the server. The CData JDBC Driver for MySQL must be installed and licensed before use.

How is data accessed?

Data is queried live through the CData JDBC Driver. The server does not store or cache data; all queries are executed against the connected MySQL database.

What transport does the server use?

The server uses stdio transport. It only works with MCP clients running on the same machine, such as Claude Desktop.

How do I authenticate to MySQL?

Authentication is handled via the CData JDBC Driver’s connection string utility. The driver supports OAuth flows if needed; you must click "Test Connection" in the utility before copying the connection string.