Skip to main content
Glama
enesjakozh

MySQL MCP Server

by Mineru98
GitHub
Python
MIT License
28
  • Linux
  • Apple
OverviewInspectNewEndpointsSchemaRelated ServersReviewsScore
Need Help?View Source CodeReport Issue

mysql-mcp-server

한국어 README.md

0. Execution

Running with Docker

Change the database connection information as needed.

docker run -d --name mcp-mysql \ -e MYSQL_HOST=localhost \ -e MYSQL_PORT=3306 \ -e MYSQL_USER=root \ -e MYSQL_PASSWORD=mcpTest1234!!! \ -e MYSQL_DATABASE=mcp_test \ -e MCP_PORT=8081 \ -p 3306:3306 mineru/mcp-mysql:1.0.0

Running with Docker Compose

This will proceed with a pre-configured setup.

docker-compose up -d

Running directly with Python

pip install -r requirements.txt python mysql_mcp_server/main.py run

Cursor Configuration

MCP functionality is available from Cursor version 0.46 and above.

Additionally, the MCP feature is only accessible to Cursor Pro account users.

Cursor Setting

Tool Addition Tips

  • Adding a Tool

    • execute functions implement the actual logic execution (Service Layer).

    • The @tool decorator helps register the tool with MCP (Controller Layer).

  • Explanation

    • Each file under mysql_mcp_server/executors represents a single tool.

    • If a new tool is added, it must be imported in mysql_mcp_server/executors/__init__.py and included in the __all__ array.

    • This ensures the module is automatically registered in the TOOLS_DEFINITION variable.

flowchart LR; A[AI Model] -->|Request tool list| B[MCP Server] B -->|Return available tools| A A -->|Request specific tool execution| B B -->|Call the corresponding executor| C[Executors] subgraph Executors C1[execute_create_table] -->|Create table| D C2[execute_desc_table] -->|View table schema| D C3[execute_explain] -->|Query execution plan| D C4[execute_insert_query] -->|Execute INSERT query| D C5[execute_insight_starter] -->|Checking the schema for building reports| D C6[execute_invoke_viz_pro] -->|Visualization chart recommendations| D C7[execute_select_query] -->|Execute SELECT query| D C8[execute_show_tables] -->|Retrieve table list| D end D[DatabaseManager] -->|Connect to MySQL| E[MySQL 8.0] E -->|Return results| D D -->|Send results| C C -->|Return results| B B -->|Return execution results| A

🚧 Development Roadmap 🚧

  • ⚙️ Parameter Options

    • 🔧 Enable/Disable Switch for Each Tool: Provide a function to reduce Input Context costs 💰

    • 🔒 Query Security Level Setting: Offer optional control over functions that could damage asset value, such as DROP, DELETE, UPDATE 🚫

  • ✨ Features

    • 📊 Data Analysis Report Generation: Provide a report generation function optimized for the model to appropriately select various charts based on user requests 📈

      • 📝 Reporting capabilities for prescribed forms

      • 🖌️ Diversify report templates

    • 🗄️ Extended Text2SQL Support

    • 🌐 SSH Connection Support: Enable secure remote access via SSH for advanced operations 🔑

    • 📥 File Extraction Function

      • 📄 CSV

      • 📑 JSON

      • 📉 Excel

1. Overview

MCP MySQL Server is a server application for MySQL database operations based on MCP (Model Context Protocol). This server provides tools that allow AI models to interact with the MySQL database.

2. System Configuration

2.1 Key Components

  • MCP Server: A FastMCP server that communicates with AI models

  • MySQL Database: Manages and stores data

  • Tools: Executors that perform database operations

2.2 Tech Stack

  • Language: Python

  • Database: MySQL 8.0

  • Key Libraries:

    • mcp: Implements Model Context Protocol for AI communication

    • PyMySQL: Connects to MySQL and executes queries

    • pandas: Processes and analyzes data

    • python-dotenv: Manages environment variables

    • fire: Implements command-line interfaces

2.3 Deployment Environment

  • Containerized deployment via Docker and Docker Compose

  • Ports: 8081 (MCP Server), 3306 (MySQL)

3. Directory Structure

MCPBoilerPlate/ ├── mysql_mcp_server/ # Main application directory │ ├── executors/ # Database operation executors │ │ ├── create_table.py # Tool for creating tables │ │ ├── desc_table.py # Tool for viewing table schema │ │ ├── explain.py # Tool for query execution plans │ │ ├── insert_query.py # Tool for INSERT query execution │ │ ├── insight_starter.py # Schema verification tools for write reports │ │ ├── invoke_viz_pro.py # Tool for Visualization chart recommendation │ │ ├── select_query.py # Tool for SELECT query execution │ │ └── show_tables.py # Tool for retrieving table lists │ ├── helper/ # Utility modules │ │ ├── db_conn_helper.py # Manages database connections │ │ ├── logger_helper.py # Logging utilities │ │ └── tool_decorator.py # Tool decorator │ └── main.py # Application entry point ├── docker-compose.yml # Docker Compose configuration ├── Dockerfile # Docker image build settings ├── requirements.txt # Dependency package list └── .env.example # Example environment variables file

4. Architecture Design

4.1 Layered Structure

  1. Interface Layer: MCP Server (FastMCP)

  2. Business Logic Layer: Handlers and Executors

  3. Data Access Layer: Database connection and query execution

4.2 Key Classes and Modules

  • MySQLMCPServer: Main server class that initializes and runs the MCP server

  • DatabaseManager: Singleton pattern-based database connection manager

  • Executors: Collection of tools for database operations

    • execute_create_table: Creates tables

    • execute_desc_table: Checks table schema

    • execute_explain: Provides query execution plans

    • execute_insert_query: Executes INSETR queries

    • execute_select_query: Executes SELECT queries

    • execute_show_tables: Retrieves table lists

4.3 Communication Flow

  1. AI model requests a list of available tools from the MCP server.

  2. The server returns the available tools list.

  3. The AI model requests the execution of a specific tool.

  4. The server calls the corresponding executor to perform the database operation.

  5. The execution results are returned to the AI model.

5. Scalability and Maintenance

  • Adding Tools: Implement new tools in the executors directory and register them in __init__.py.

  • Environment Configuration: Manage environment variables via the .env file.

  • Logging: Ensure consistent logging using logger_helper.

6. Deployment and Execution

6.1 Local Execution

# Setup environment cp .env.example .env # Modify .env file as needed # Install dependencies pip install -r requirements.txt # Run the server python mysql_mcp_server/main.py run

6.2 Docker Deployment

# Start database using Docker Compose docker-compose up -d db # Build and run mysql-mcp-server with Docker Compose (including rebuilds) docker-compose up -d --build mysql-mcp-server

7. Security Considerations

  • Manage database credentials via environment variables.

  • Use strong passwords in production environments.

  • Consider implementing SSL/TLS encryption for database connections when necessary.

This server cannot be installed

-
security - not tested
A
license - permissive license
-
quality - not tested

How are these scores calculated?

remote-capable server

The server can be hosted and run remotely because it primarily relies on remote services or has no dependency on the local environment.

A server that enables AI models to interact with MySQL databases through a Model Control Protocol, providing tools for table creation, schema inspection, query execution, and data retrieval.

  1. 0. Execution
    1. Running with Docker
    2. Running with Docker Compose
    3. Running directly with Python
    4. Cursor Configuration
    5. Tool Addition Tips
  2. 🚧 Development Roadmap 🚧
    1. 1. Overview
      1. 2. System Configuration
        1. 2.1 Key Components
        2. 2.2 Tech Stack
        3. 2.3 Deployment Environment
      2. 3. Directory Structure
        1. 4. Architecture Design
          1. 4.1 Layered Structure
          2. 4.2 Key Classes and Modules
          3. 4.3 Communication Flow
        2. 5. Scalability and Maintenance
          1. 6. Deployment and Execution
            1. 6.1 Local Execution
            2. 6.2 Docker Deployment
          2. 7. Security Considerations

            Related Resources

            Related MCP Servers

            • mcp-mysql-server

              f4ww4z
              A
              security
              A
              license
              A
              quality
              This server enables AI models to interact with MySQL databases through a standardized interface.
              Last updated -
              283
              114
              MIT License
              • Linux
              • Apple

            • MCP MySQL Server

              Atomzzm
              A
              security
              A
              license
              A
              quality
              A Model Context Protocol server that enables AI models to interact with MySQL databases, providing tools for querying, executing statements, listing tables, and describing table structures.
              Last updated -
              5
              283
              MIT License

            • MCP MySQL Server

              kevinbin
              A
              security
              F
              license
              A
              quality
              A Model Context Protocol server that enables AI models to interact with MySQL databases through a standardized interface, providing tools for querying, executing commands, and managing database schemas.
              Last updated -
              7

            • MySQL MCP Server

              caicongyang
              -
              security
              F
              license
              -
              quality
              A Model Context Protocol server that enables AI models to interact with MySQL databases through natural language, supporting SQL queries, table creation, and schema exploration.
              Last updated -
              3
              • Linux
              • Apple

            View all related MCP servers

            Appeared in Searches

            New MCP Servers

            MCP directory API

            We provide all the information about MCP servers via our MCP API.

            curl -X GET 'https://glama.ai/api/mcp/v1/servers/Mineru98/mysql-mcp-server'

            If you have feedback or need assistance with the MCP directory API, please join our Discord server