MySQL MCP Server

@kerongon

Repository

Basic information

About MySQL MCP Server

No overview available yet

#mcp-server #mysql #database-access

MySQL MCP Server config

No standard config provided

This server doesn't expose a parseable MCP config block in its README. See the repository for install instructions.

Repository

MySQL MCP Server tools

Tool list not available yet

This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

What is MySQL MCP Server?

The MySQL MCP Server is a Model Context Protocol (MCP) server that provides MySQL database access, allowing LLMs and MCP-compatible systems to interact with a MySQL database through read-only queries and schema inspection.

How to use MySQL MCP Server?

Clone the repository, install dependencies with npm install, build the project with npm run build, and configure required environment variables (MYSQL_HOST, MYSQL_PORT, MYSQL_USER, MYSQL_PASS, MYSQL_DB). Optionally set MYSQL_SOCKET for socket connections and MYSQL_POOL_LIMIT to control the connection pool size. The server starts automatically when initialized by the MCP system.

Key features of MySQL MCP Server

List database tables and their schemas
Execute read-only SQL queries
Secure connection handling with connection pooling

Use cases of MySQL MCP Server

Let an LLM browse and understand your database schema
Enable AI agents to perform read-only data analysis on MySQL databases
Provide safe, sandboxed MySQL access to MCP clients for reporting or exploration

Frequently asked questions

Is the server read-only?

Yes, the README explicitly states it supports executing read-only SQL queries.

What environment variables are required to configure it?

You must set `MYSQL_HOST`, `MYSQL_PORT`, `MYSQL_USER`, `MYSQL_PASS`, and `MYSQL_DB`. Alternatively, you can use `MYSQL_SOCKET` instead of host and port.

How do I install and run the server?

Clone the repo, run `npm install` and `npm run build`, then set the required environment variables. The MCP system will start the server automatically.

Does it support connection pooling?

Yes, it uses connection pooling with a configurable limit via the `MYSQL_POOL_LIMIT` environment variable (default is 10).

Comments

More Databases MCP servers

Schemity

tbson

Local database MCP server: your agent sees a migration's impact before it runs, for PostgreSQL, MySQL, SQL Server and SQLite, with no database credentials.