Skip to content

mysql-mcp-server

Apache-2.0★ 45updated 13 Nov 2026

MySQL Server implementation for Model Context Protocol (MCP) written in Go.

What can you do with mysql-mcp-server?

  • Fully read-only (blocks all non-SELECT/SHOW/DESCRIBE/EXPLAIN)
  • Multi-DSN Support: Connect to multiple MySQL or MariaDB instances, switch via tool
  • MariaDB Support: Native compatibility with MariaDB 10.x, 11.x and 12.x
  • Vector Search (MySQL 9.0+): Similarity search on vector columns
  • MCP tools:
  • listdatabases, listtables, describe_table
  • run_query (safe and row-limited)
  • ping, server_info

Features as listed in the project's README, checked 16 Nov 2026.

About mysql-mcp-server

A fast, read-only MySQL Server for the Model Context Protocol (MCP) written in Go. This project exposes safe MySQL introspection tools to Claude Desktop via MCP. Claude can explore databases, describe schemas, and execute controlled read-only SQL queries — ideal for secure development assistance, debugging, analytics, and schema documentation.

Opening text of the project's README, checked 16 Nov 2026.

Install

{
  "mcpServers": {
    "mysql": {
      "command": "mysql-mcp-server",
      "env": {
        "MYSQL_DSN": "user:password@tcp(127.0.0.1:3306)/mydb?parseTime=true",
        "MYSQL_MAX_ROWS": "200",
        "MYSQL_MCP_EXTENDED": "1"
      }
    }
  }
}

Config as documented in its source, checked 16 Nov 2026. Placeholders such as API keys are the project's own: replace them with your values.

Requirements listed

  • Docker and Docker Compose (for integration tests)
  • MySQL client (optional, for manual database access)

Tools (24)

list_databases
list_tables
describe_table
run_query
server_info
list_connections
use_connection
add_connection
vector_search
vector_info
list_indexes
show_create_table
explain_query
list_views
list_triggers
list_procedures
list_functions
list_partitions
database_size
table_size
foreign_keys
list_status
list_variables
ping

Tool names from the README, checked 16 Nov 2026.

mysql-mcp-server compared with other MySQL servers

ServerLicenceToolsLast commitStars
mysql-mcp-serverApache-2.02413 Nov 202645
mysql-mcp-serverMIT422 Sept 202675

Every value is a checked fact on that server's own page. This is a comparison of facts, not a ranking.

Verified facts

Maintainer
askdba

Source · checked 16 Nov 2026

Licence
Apache-2.0

Source · checked 16 Nov 2026

Setup documented for
  • Claude Code
  • Claude Desktop
  • Cursor
  • ChatGPT

Source · checked 16 Nov 2026

Repository
github.com/askdba/mysql-mcp-server

Source · checked 16 Nov 2026

Last commit
13 Nov 2026

Source · checked 16 Nov 2026

GitHub stars
45

Source · checked 16 Nov 2026

Open issues
7

Source · checked 16 Nov 2026

Each value links to where it was found and shows the date it was checked. How we verify

Frequently asked questions

What does mysql-mcp-server do?

MySQL Server implementation for Model Context Protocol (MCP) written in Go.

Which MCP clients does mysql-mcp-server document setup for?

Its README documents setup for Claude Code, Claude Desktop, Cursor, ChatGPT.

How do I install mysql-mcp-server?

Add the install config shown on this page to your MCP client's configuration. Check the README for client-specific steps.

What licence is mysql-mcp-server under?

Apache-2.0, as reported by the repository on 16 Nov 2026.

Is mysql-mcp-server still maintained?

The last commit was on 13 Nov 2026, and the repository had 7 open issues.

What tools does mysql-mcp-server expose?

24 tools: list_databases, list_tables, describe_table, run_query, server_info, list_connections, use_connection, add_connection, vector_search, vector_info, list_indexes, show_create_table, and more.

More MySQL MCP servers