@imrieul/mysql-mcp-server

Name: MySQL MCP Server
Availability: InStock

한국어 | 日本語 | 中文 | Español | Português | Français | Русский

A simple MySQL MCP server.

Features

LLM-friendly — compact column/row format, auto LIMIT, error hints with next-action suggestions
Bulk schema — describe_all_tables returns entire DB schema in one call
Read-only mode — app-level prefix check + DB-level SET SESSION TRANSACTION READ ONLY
Query timeout — Promise.race() based timeout with guaranteed connection cleanup
SSL support — one env var to enable encrypted connections
Minimal — 3 dependencies, zero config required

Quick Start

Add to your MCP config (.mcp.json or claude_desktop_config.json):

{
  "mcpServers": {
    "mysql": {
      "command": "npx",
      "args": ["-y", "@imrieul/mysql-mcp-server"],
      "env": {
        "MYSQL_HOST": "localhost",
        "MYSQL_PORT": "3306",
        "MYSQL_USER": "root",
        "MYSQL_PASSWORD": "your-password",
        "MYSQL_DATABASE": "your-database"
      }
    }
  }
}

Or with a connection string:

{
  "mcpServers": {
    "mysql": {
      "command": "npx",
      "args": ["-y", "@imrieul/mysql-mcp-server", "mysql://root:password@localhost:3306/mydb"]
    }
  }
}

Read-only mode with SSL

{
  "mcpServers": {
    "mysql": {
      "command": "npx",
      "args": ["-y", "@imrieul/mysql-mcp-server", "--readonly"],
      "env": {
        "MYSQL_HOST": "db.example.com",
        "MYSQL_USER": "readonly_user",
        "MYSQL_PASSWORD": "password",
        "MYSQL_DATABASE": "production",
        "MYSQL_SSL": "true",
        "MYSQL_QUERY_TIMEOUT": "10000"
      }
    }
  }
}

Tools

Tool	Description	Read-only mode
`query`	Execute SELECT, SHOW, DESCRIBE, EXPLAIN	Allowed
`execute`	Execute INSERT, UPDATE, DELETE, DDL	Blocked
`list_databases`	List all databases	Allowed
`list_tables`	List tables in a database	Allowed
`describe_table`	Show table schema	Allowed
`describe_all_tables`	Show all table schemas at once	Allowed

Configuration

Environment variables

Variable	Required	Default	Description
`MYSQL_HOST`	Yes	—	MySQL host
`MYSQL_USER`	Yes	—	MySQL user
`MYSQL_PASSWORD`	Yes	—	MySQL password
`MYSQL_PORT`	No	`3306`	MySQL port
`MYSQL_DATABASE`	No	—	Default database
`MYSQL_READONLY`	No	`false`	Read-only mode
`MYSQL_MAX_ROWS`	No	`100`	Auto LIMIT for SELECT queries
`MYSQL_QUERY_TIMEOUT`	No	`30000`	Query timeout in ms (0 to disable)
`MYSQL_SSL`	No	`false`	Enable SSL connection

Connection string

mysql://user:password@host:port/database

Passed as the first CLI argument. Takes priority over environment variables.

License

MIT

MySQL MCP Server