MySQL MCP Server

@kevinwatt

Basic information

About MySQL MCP Server

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

MySQL MCP Server config

Add this server to your MCP-compatible client using the configuration below.

{
  "mcpServers": {
    "mysql-mcp": {
      "command": "npx",
      "args": [
        "@kevinwatt/mysql-mcp"
      ]
    }
  }
}

MySQL MCP Server tools

Execute read-only SELECT queries against the MySQL database. - Maximum query length: 4096 characters - Maximum result rows: 1000 - Query timeout: 30 seconds

Execute data modification queries (INSERT/UPDATE/DELETE). - Returns affected rows count and insert ID - Supports parameterized queries - Automatic transaction handling

List all tables in current database

Show table structure

Overview

What is MySQL MCP Server?

MySQL MCP Server is an MCP server implementation that integrates with MySQL databases, providing secure database access capabilities for LLMs. It enables language models to execute SQL queries, list tables, describe schemas, and perform data modifications with transaction support.

How to use MySQL MCP Server?

Install via npm install -g @kevinwatt/mysql-mcp, then configure environment variables (MYSQL_HOST, MYSQL_PORT, MYSQL_USER, MYSQL_PASS, MYSQL_DB) and run with a compatible MCP host like Dive Desktop. Alternatively, start manually with npx @kevinwatt/mysql-mcp.

Key features of MySQL MCP Server

Execute read-only SELECT queries with safety limits
Perform INSERT/UPDATE/DELETE with automatic transactions
List all tables and describe table structures
Parameterized queries for data safety
Query length (4096 chars) and result row (1000) limits

Use cases of MySQL MCP Server

Natural-language database querying via LLM
Automated schema exploration and documentation
Safe data modification with transaction rollback
Integration with MCP‑compatible AI assistants

Frequently asked questions

What limits are enforced on queries?

Maximum query length is 4096 characters, maximum result rows are 1000, and query timeout is 30 seconds.

What are the system requirements?

Node.js 18+ and a running MySQL Server are required. The server must be used with an MCP‑compatible LLM service.

How are write transactions handled?

`mysql_execute` automatically wraps INSERT/UPDATE/DELETE in transactions, returning affected rows count and last insert ID.

Is the server read‑only for SELECT queries?

Yes, the `mysql_query` tool enforces a read‑only transaction mode for all SELECT statements.

What authentication or transport configuration is needed?

Connection is configured via environment variables for host, port, user, password, and database. No separate auth mechanism is mentioned beyond standard MySQL credentials.

Comments

More Databases MCP servers

PostgreSQL Model Context Protocol (PG-MCP) Server

stuzero

540

Local YDB MCP

astandrik

Safety-first stdio MCP server with 38 tools for operating Docker-based local-ydb environments locally or over SSH.

MCP Alchemy

runekaagaard

A MCP (model context protocol) server that gives the LLM access to and knowledge about relational databases like SQLite, Postgresql, MySQL & MariaDB, Oracle, and MS-SQL.

412