mysql-mcp-server

Overview

The MCP MySQL Server is a comprehensive tool service built on the @modelcontextprotocol/sdk that enables AI agents and automation tools to interact with MySQL databases. It provides essential database operations including executing SQL queries (SELECT, INSERT, UPDATE, DELETE), retrieving table structure information, and detecting connection status. The server implements security measures to prevent SQL injection by validating SQL statements and parameters, blocking dangerous operations like DROP/TRUNCATE/ALTER commands.

Try asking AI

After installing, here are 5 things you can ask your AI assistant:

• execute_sql

  Execute SQL queries including SELECT, INSERT, UPDATE, and DELETE

  Try:Show me all customers from the databaseTry:Insert a new record into orders table
• get_tables_info

  Get database table structure information including all tables and their columns

  Try:List all tables in the databaseTry:Show me the structure of the products table
• get_connection_status

  Check if the MySQL database connection is active

  Try:Is the database connected?Try:Check connection status to MySQL

Comparable tools

Installation

git clone https://github.com/TickHaiJun/mysql-mcp-server.git
cd mysql-mcp-server

npm install

DB_HOST=localhost
DB_PORT=3306
DB_USER=root
DB_PASSWORD=yourpassword
DB_NAME=yourdatabase

node src/index.js

{
  "mcpServers": {
    "mysql": {
      "command": "node",
      "args": ["/path/to/mysql-mcp-server/src/index.js"],
      "env": {
        "DB_HOST": "localhost",
        "DB_PORT": "3306",
        "DB_USER": "yourusername",
        "DB_PASSWORD": "yourpassword",
        "DB_NAME": "yourdatabase"
      }
    }
  }
}

FAQ

Is DROP/TRUNCATE/ALTER supported?

No, these dangerous operations are explicitly blocked for security reasons.

How is SQL injection prevented?

All SQL statements and parameters are validated using validators that check for injection patterns and block suspicious operations.

Compare mysql-mcp-server with