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.