mysql-mcp-server-by-cdata

mysql-mcp-server-by-cdata

0
databases

CData's MCP Server for MySQL facilitates querying of live MySQL data by LLMs without needing SQL knowledge. It supports natural language queries and integrates with tools like Claude Desktop.

mysql-mcp-server-by-cdata

CData's Model Context Protocol (MCP) Server for MySQL

Purpose

  • This read-only MCP Server enables LLMs to query live MySQL data supported by the CData JDBC Driver for MySQL.
  • MySQL data is made available through a simple MCP interface, allowing LLMs to retrieve information using natural language questions without SQL.

Setup Guide

  1. Clone the repository and build the server to create the necessary JAR file.
  2. Download, install, and license the CData JDBC Driver for MySQL.
  3. Configure your data source connection and create a .prp file for JDBC connection.

Usage Details

  • Allows AI clients to read, write, update, and delete underlying data using built-in tools.

Tools & Descriptions

  • {servername}_get_tables: Retrieves available tables.
  • {servername}_get_columns: Retrieves columns for a table.

Running the Server

  • Use the appropriate Java command to run the MCP Server.