ai2mysql-mcp-server

ai2mysql-mcp-server

3.2

If you are the rightful owner of ai2mysql-mcp-server 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.

A MySQL database connection server built on go-mcp, supporting communication with clients via stdio, allowing execution of SQL queries and data manipulation operations.

The MySQL MCP Server is a robust solution for connecting to MySQL databases using the Model Context Protocol (MCP). Built on the go-mcp library, it facilitates seamless communication with clients through standard input/output, enabling the execution of SQL queries and data manipulation operations. The server supports a wide range of SQL operations, including SELECT, SHOW, DESCRIBE, INSERT, UPDATE, and DELETE, with configurable permission controls for data manipulation tasks. It offers flexible configuration through environment variables, allowing users to tailor the server's behavior to their specific needs. Additionally, the server includes a debug mode that provides detailed logging, aiding in troubleshooting and performance monitoring. This makes it an ideal choice for developers and database administrators looking for a reliable and customizable MySQL connection solution.

Features

  • Communicates with clients through the MCP protocol
  • Supports connection to MySQL databases
  • Supports query operations (SELECT, SHOW, DESCRIBE)
  • Supports data manipulation operations (INSERT/UPDATE/DELETE)
  • Permission control (configurable for insert, update, delete operations)

Tools

  1. mcp_mysql_query

    Perform SQL query operations

  2. mcp_mysql_execute

    Perform SQL data operations