mysql-mcp-server-by-cdata

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.