MySQL MCP Server

An MCP server implementation that integrates with MySQL databases, providing secure database access capabilities for LLMs.

Features

Read Operations
- Execute read-only SELECT queries
- List all database tables
- Show table structures
- View schema information
Write Operations
- Execute INSERT/UPDATE/DELETE with transaction support
- Parameterized queries for data safety
- Returns affected rows and insert IDs
Security
- Read-only transaction mode for SELECT queries
- Query length and result size limits
- Performance monitoring and logging
- Automatic transaction handling

Installation

npm install -g @kevinwatt/mysql-mcp

Usage with Dive Desktop

Click "+ Add MCP Server" in Dive Desktop
Copy and paste this configuration:

{
  "mcpServers": {
    "mysql": {
      "command": "npx",
      "args": [
        "-y",
        "@kevinwatt/mysql-mcp"
      ],
      "env": {
        "MYSQL_HOST": "127.0.0.1",
        "MYSQL_PORT": "3306",
        "MYSQL_USER": "root",
        "MYSQL_PASS": "",
        "MYSQL_DB": "your_database"
      }
    }
  }
}

Click "Save" to install the MCP server

Tool Documentation

mysql_query
- Execute read-only SELECT queries
- Inputs:
  - sql (string): SQL SELECT query to execute
- Limits:
  - Maximum query length: 4096 characters
  - Maximum result rows: 1000
  - Query timeout: 30 seconds
mysql_execute
- Execute data modification operations
- Inputs:
  - sql (string): SQL statement (INSERT/UPDATE/DELETE)
  - params (array, optional): Parameters for the SQL statement
- Features:
  - Returns affected rows count
  - Returns last insert ID
  - Automatic transaction handling
list_tables
- List all tables in current database
- No inputs required
describe_table
- Show table structure
- Inputs:
  - table (string): Table name to describe

Usage Examples

Ask your LLM to:

"Show me all tables in the database"
"Describe the structure of users table"
"Select all active users from the database"
"Insert a new record into orders table"

Manual Start

If needed, start the server manually:

npx @kevinwatt/mysql-mcp

Requirements

Node.js 18+
MySQL Server
MCP-compatible LLM service

License

MIT

Author

Dewei Yen

Keywords

mcp
mysql
database
dive
llm
ai