@longlonga/mysql

A Model Context Protocol (MCP) server for interacting with MySQL databases. Provides tools for querying, inspecting, and modifying MySQL databases directly from Claude.

Installation

Via Claude Code (recommended)

claude mcp add --scope user mysql \
  -e MYSQL_HOST=your-host \
  -e MYSQL_PORT=3306 \
  -e MYSQL_USER=your-user \
  -e MYSQL_PASSWORD=your-password \
  -e MYSQL_DATABASE=your-database \
  -- npx -y @longlonga/mysql

Via claude_desktop_config.json

{
  "mcpServers": {
    "mysql": {
      "command": "npx",
      "args": ["-y", "@longlonga/mysql"],
      "env": {
        "MYSQL_HOST": "your-host",
        "MYSQL_PORT": "3306",
        "MYSQL_USER": "your-user",
        "MYSQL_PASSWORD": "your-password",
        "MYSQL_DATABASE": "your-database"
      }
    }
  }
}

Configuration

Environment Variable	Required	Default	Description
MYSQL_HOST	Yes	—	MySQL server hostname or IP
MYSQL_PORT	No	3306	MySQL server port
MYSQL_USER	Yes	—	MySQL username
MYSQL_PASSWORD	Yes	—	MySQL password
MYSQL_DATABASE	No	—	Default database (can be overridden per tool call)

Tools

Tool	Description
mysql_list_databases	List all databases the user has access to
mysql_list_tables	List all tables in a database
mysql_describe_table	Get column definitions for a table
mysql_show_create_table	Get the full CREATE TABLE DDL statement
mysql_query	Execute a read-only SELECT/SHOW/EXPLAIN query
mysql_execute	Execute a write SQL statement (INSERT/UPDATE/DELETE/DDL)
mysql_table_stats	Get row count and size statistics for tables

Usage Examples

Once connected, you can ask Claude things like:

• "List all tables in my database"
• "Describe the structure of the users table"
• "Query the last 10 orders"
• "How many rows are in each table?"

License

MIT