mysql_mcp_servers

mysql_mcp_servers

3.3

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

This project provides a server to interact with MySQL databases using the Model Context Protocol (MCP), offering an interface to access MySQL databases in a WSL environment.

The MySQL MCP Server is designed to facilitate interaction with MySQL databases through the Model Context Protocol (MCP). It provides a robust interface for accessing MySQL databases, particularly in a Windows Subsystem for Linux (WSL) environment. The server supports various SQL operations, including retrieving table lists, reading data from tables, and executing SQL queries such as SELECT, SHOW TABLES, INSERT, UPDATE, and DELETE. The project is structured to include configuration modules, database operation modules, and tools for executing SQL commands. It is compatible with Python 3.11 and above, and can be run directly, as a module, or within a Docker container. The server uses environment variables to connect to MySQL, ensuring flexibility and ease of configuration. Additionally, it supports WSL integration, allowing seamless connection to MySQL servers running within WSL.

Features

  • Retrieve list of tables from MySQL database
  • Read data from tables (up to 100 rows)
  • Execute SQL queries (SELECT, SHOW TABLES, INSERT, UPDATE, DELETE)
  • Supports direct execution, module execution, and Docker container execution
  • Environment variable configuration for MySQL connection

Tools

  1. sql_tools.py

    Provide SQL query execution function