mysql-mcp-server
If you are the rightful owner of mysql-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 Model Context Protocol (MCP) server implemented with FastMCP 2.0 and Python.
The MySQL MCP Server is a robust implementation designed to facilitate the execution of SQL queries and retrieval of database schema information through the Model Context Protocol. Built using FastMCP 2.0 and Python, this server is fully containerized using Docker and docker-compose, ensuring easy deployment and scalability. It leverages Poetry for efficient dependency management, making it a reliable choice for developers looking to integrate MCP functionalities with MySQL databases. The server supports a range of MCP tools that allow for executing queries, updating records, and obtaining detailed database structure information, making it a comprehensive solution for database management tasks.
Features
- Execute SQL queries via MCP functions
- Get database schema information
- Fully containerized with Docker and docker-compose
- Packaged with Poetry for dependency management
Tools
execute_query
Execute a SQL query and return results
execute_update
Execute an update/insert SQL query
get_tables
Get a list of tables in the database
get_table_schema
Get schema information for a specific table
describe_database
Get comprehensive database structure information