Advertise
MCP.so
Sign In

MySQL MCP Server

@kerongon

Repository

Basic information

Category

Databases

Transports

stdio

Author

kerongon

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

1

Is the server read-only?

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

2

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.

3

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.

4

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

MotherDuck's DuckDB MCP Server

motherduckdb

Local MCP server for DuckDB and MotherDuck

498

Sqlite

modelcontextprotocol

Model Context Protocol Servers

88.1K

Elasticsearch MCP Server

elastic

685

Multi Database MCP Server

FreePeak

A powerful multi-database server implementing the Model Context Protocol (MCP) to provide AI assistants with structured access to databases.

397

Lawstronaut

Lawstronaut-FZCO

Access millions of official legal and regulatory source documents from 155+ jurisdictions via MCP. Lawstronaut supports AI agents with structured legal research, legal data, laws, regulations, cases, guidance, official s

Advertise