mysql-mcp-server-by-cdata
by CDataSoftware
CData's Model Context Protocol (MCP) Server for MySQL allows LLMs to query live MySQL data. It wraps the CData JDBC Driver for MySQL and makes data available through a simple MCP interface, enabling natural language queries.
Last updated: N/A
What is mysql-mcp-server-by-cdata?
This is a read-only MCP server that allows LLMs like Claude Desktop to query live data from MySQL. It leverages the CData JDBC Driver for MySQL to expose MySQL data as relational SQL models and then provides a simple MCP interface for LLMs to retrieve information using natural language.
How to use mysql-mcp-server-by-cdata?
- Clone the repository. 2. Build the server using Maven. 3. Download and license the CData JDBC Driver for MySQL. 4. Configure the connection to MySQL using the Connection String utility. 5. Create a .prp file with connection properties. 6. Configure your client (e.g., Claude Desktop) to use the MCP server by adding it to the config file. 7. Run or refresh your client.
Key features of mysql-mcp-server-by-cdata
Read-only access to MySQL data
MCP interface for LLM integration
Uses CData JDBC Driver for MySQL
Enables natural language queries
Simple setup and configuration
Use cases of mysql-mcp-server-by-cdata
Querying MySQL data using natural language with LLMs
Integrating MySQL data with Claude Desktop
Retrieving live information from MySQL without SQL knowledge
Building AI-powered applications that access MySQL data
FAQ from mysql-mcp-server-by-cdata
How do I troubleshoot connection issues?
How do I troubleshoot connection issues?
Ensure you have configured your connection properly using the Connection String builder and copied the connection string into the property (.prp) file. If you are still having trouble, contact the CData Support Team.
How do I add the MCP server to Claude Desktop?
How do I add the MCP server to Claude Desktop?
Create or modify the claude_desktop_config.json file to include the MCP server configuration, specifying the command and arguments to run the server.
What if I can't see the CData MCP Server in Claude Desktop?
What if I can't see the CData MCP Server in Claude Desktop?
Be sure that you have fully quit Claude Desktop (Windows: use the Task Manager, Mac: use the Activity Monitor) and restarted it.
What is the purpose of the .prp file?
What is the purpose of the .prp file?
The .prp file contains the configuration properties for the JDBC connection, including the driver path, driver class, JDBC URL, and server details.
Can I access all tables in my MySQL database?
Can I access all tables in my MySQL database?
Yes, you can leave the 'Tables' property in the .prp file blank to access all data. Alternatively, you can explicitly declare the tables you wish to create access for.