MySQL MCP Server

What does “MySQL” MCP Server do?

The MySQL MCP Server is a Model Context Protocol (MCP) implementation that enables secure interaction between AI assistants and MySQL databases. Serving as a bridge, it allows AI applications to safely explore, analyze, and interact with MySQL databases through a controlled interface. This server is not intended to run standalone, but is designed to be integrated into broader AI development workflows as a backend component. With features such as listing available MySQL tables, reading table contents, executing SQL queries, and enforcing secure database access via environment variables, the MySQL MCP Server empowers developers to connect AI systems with live database data, manage queries, and streamline database-centric tasks—all while maintaining comprehensive logging and error handling for robust operations.

List of Prompts

No information about prompt templates is available in the repository.

List of Resources

• MySQL Tables as Resources
  The server exposes available MySQL tables as resources, allowing AI clients to discover database structure.
• Table Contents
  Clients can access and read the contents of MySQL tables, enabling data-driven AI workflows.
• Query Results
  Results from executed SQL queries are provided as contextual resources to the client for further processing.

List of Tools

• List Tables
  Provides a tool to list all available MySQL tables in the connected database.
• Read Table Contents
  Allows reading the contents of specified tables, supporting data exploration and retrieval.
• Execute SQL Query
  Executes arbitrary SQL queries against the connected MySQL database, with error handling and security controls.

Use Cases of this MCP Server

• Database Management
  AI assistants can securely manage and query MySQL databases, streamlining database administration for developers.
• Data Analysis and Exploration
  Enables AI-driven data exploration, summary, and visualization by allowing access to live database tables and content.
• Automated Reporting
  Automate the generation of reports or analytics by querying and processing database information directly via AI tools.
• Code Generation and Debugging
  Developers can leverage AI to generate or optimize SQL queries, and debug database-related code using real schema and data.
• Secure Data Access for LLMs
  LLM-based agents can access database context and perform tasks without direct database credentials, improving security.

How to set it up

Windsurf

1. Ensure Python and MySQL are installed, and the mysql-mcp-server package is installed via pip install mysql-mcp-server.
2. Locate your Windsurf configuration file.
3. Add the MySQL MCP Server using the following JSON in your config:

   {
     "mcpServers": {
       "mysql": {
         "command": "uv",
         "args": [
           "--directory",
           "path/to/mysql_mcp_server",
           "run",
           "mysql_mcp_server"
         ],
         "env": {
           "MYSQL_HOST": "localhost",
           "MYSQL_PORT": "3306",
           "MYSQL_USER": "your_username",
           "MYSQL_PASSWORD": "your_password",
           "MYSQL_DATABASE": "your_database"
         }
       }
     }
   }
   

4. Save your configuration and restart Windsurf.
5. Verify that the MySQL MCP Server is listed as active.

Securing API Keys:
Use the "env" object to set sensitive values via environment variables, as shown above.

Claude

1. Install mysql-mcp-server using pip install mysql-mcp-server.
2. Edit your claude_desktop_config.json file.
3. Add the MySQL MCP Server configuration:

   {
     "mcpServers": {
       "mysql": {
         "command": "uv",
         "args": [
           "--directory",
           "path/to/mysql_mcp_server",
           "run",
           "mysql_mcp_server"
         ],
         "env": {
           "MYSQL_HOST": "localhost",
           "MYSQL_PORT": "3306",
           "MYSQL_USER": "your_username",
           "MYSQL_PASSWORD": "your_password",
           "MYSQL_DATABASE": "your_database"
         }
       }
     }
   }
   

4. Save the file and restart Claude Desktop.
5. Confirm the server is running and accessible in the Claude interface.

Cursor

1. Install the MCP server (pip install mysql-mcp-server).
2. Open the Cursor configuration file.
3. Add the following server definition:

   {
     "mcpServers": {
       "mysql": {
         "command": "uv",
         "args": [
           "--directory",
           "path/to/mysql_mcp_server",
           "run",
           "mysql_mcp_server"
         ],
         "env": {
           "MYSQL_HOST": "localhost",
           "MYSQL_PORT": "3306",
           "MYSQL_USER": "your_username",
           "MYSQL_PASSWORD": "your_password",
           "MYSQL_DATABASE": "your_database"
         }
       }
     }
   }
   

4. Restart Cursor for the new server to be detected.
5. Validate the server is connected.

Cline

1. Install the server package with pip install mysql-mcp-server.
2. Edit your Cline configuration file.
3. Configure the server as follows:

   {
     "mcpServers": {
       "mysql": {
         "command": "uv",
         "args": [
           "--directory",
           "path/to/mysql_mcp_server",
           "run",
           "mysql_mcp_server"
         ],
         "env": {
           "MYSQL_HOST": "localhost",
           "MYSQL_PORT": "3306",
           "MYSQL_USER": "your_username",
           "MYSQL_PASSWORD": "your_password",
           "MYSQL_DATABASE": "your_database"
         }
       }
     }
   }
   

4. Save changes and restart Cline.
5. Test the server connection in your client interface.

Securing API Keys Example:

"env": {
  "MYSQL_HOST": "localhost",
  "MYSQL_PORT": "3306",
  "MYSQL_USER": "your_username",
  "MYSQL_PASSWORD": "your_password",
  "MYSQL_DATABASE": "your_database"
}

Store sensitive credentials in the env section to avoid hardcoding them elsewhere.

How to use this MCP inside flows

Using MCP in FlowHunt

To integrate MCP servers into your FlowHunt workflow, start by adding the MCP component to your flow and connecting it to your AI agent:

Click on the MCP component to open the configuration panel. In the system MCP configuration section, insert your MCP server details using this JSON format:

{
  "mysql": {
    "transport": "streamable_http",
    "url": "https://yourmcpserver.example/pathtothemcp/url"
  }
}

Once configured, the AI agent is now able to use this MCP as a tool with access to all its functions and capabilities. Remember to change “mysql” to whatever the actual name of your MCP server is and replace the URL with your own MCP server URL.

Overview

Our opinion

The MySQL MCP Server is a focused, robust MCP implementation for secure database access, with clear configuration and security features. However, it lacks prompt templates and does not mention advanced MCP features like sampling or roots. Still, its solid documentation, resource exposure, and tool set make it a practical choice for database-driven AI integration.

MCP Score