mysql-mcp-server-by-cdata
If you are the rightful owner of mysql-mcp-server-by-cdata and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.
CData's Model Context Protocol (MCP) Server for MySQL is a read-only server that allows LLMs to query live MySQL data using natural language.
The CData MCP Server for MySQL is designed to facilitate the interaction between large language models (LLMs) and MySQL databases. By leveraging the CData JDBC Driver for MySQL, this server exposes MySQL data as relational SQL models, enabling LLMs to access live data without requiring SQL knowledge. This server is particularly useful for applications like Claude Desktop, where users can query MySQL databases using natural language. The server is read-only, but a full-featured version with read, write, update, and delete capabilities is available in beta. The setup involves cloning the repository, building the server, and configuring the JDBC connection. Once configured, the server can be integrated with AI clients to provide seamless data access.
Features
- Read-only access to MySQL data through MCP interface.
- Integration with CData JDBC Driver for MySQL.
- Natural language querying without SQL knowledge.
- Support for various AI clients like Claude Desktop.
- JSON-RPC support for scripting requests.
Tools
{servername}_get_tables
Get a list of available tables in the data source
{servername}_get_columns
Get column information for the specified table
{servername}_run_query
Execute SQL SELECT query
