mysql-mcp-server

mysql-mcp-server

3.2

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

  1. execute_query

    Execute a SQL query and return results

  2. execute_update

    Execute an update/insert SQL query

  3. get_tables

    Get a list of tables in the database

  4. get_table_schema

    Get schema information for a specific table

  5. describe_database

    Get comprehensive database structure information