Advertise
MCP.so
Sign In

MySQL MCP Server

@MCP-Mirror

Repository

Basic information

Category

Databases

License

MIT license

Transports

stdio

Author

MCP-Mirror

About MySQL MCP Server

Mirror of

#mysql#mcp-server#database

MySQL MCP Server config

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

{
  "mcpServers": {
    "SuMiaoALi_mysql-mcp-server": {
      "command": "npx",
      "args": [
        "mysql-mcp-server"
      ]
    }
  }
}

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.

Fetch the live tool list by running this server in a temporary sandbox using the button above.

Overview

What is MySQL MCP Server?

MySQL MCP Server is a Model Context Protocol server that provides secure MySQL database operations for AI assistants and other MCP clients. It exposes database queries and schema introspection as MCP tools and resources.

How to use MySQL MCP Server?

Install via npm install mysql-mcp-server and configure with environment variables (MYSQL_HOST, MYSQL_PORT, MYSQL_USER, MYSQL_PASSWORD, MYSQL_DB, MYSQL_TIMEZONE). Add it to your Claude Desktop config or run directly with npx mysql-mcp-server.

Features of MySQL MCP Server

  • Execute safe SQL queries (SELECT, INSERT, SHOW, DESCRIBE)
  • Get detailed table structure information
  • Insert data with automatic parameterization
  • List all tables in the database
  • Automatic LIMIT clauses on SELECT queries
  • Connection pooling for efficient database management

Use cases of MySQL MCP Server

  • AI assistants answering questions from a MySQL database
  • Automated database schema inspection and documentation
  • Safe, read-mostly database access for chat-based tools
  • Inserting records via natural language instructions
  • Exploring and understanding table structures interactively

Frequently asked questions

1

What operations are allowed?

Only SELECT, INSERT, SHOW, and DESCRIBE operations are permitted. Destructive operations like UPDATE and DELETE are explicitly forbidden.

2

How do I configure the server?

Set environment variables for MySQL connection: `MYSQL_HOST`, `MYSQL_PORT`, `MYSQL_USER`, `MYSQL_PASSWORD`, `MYSQL_DB`, and `MYSQL_TIMEZONE`. All have defaults except password and database.

3

Does the server protect against SQL injection?

Yes. All user inputs are handled with parameterized queries, and SELECT queries automatically get LIMIT clauses to prevent large data dumps.

4

What are the runtime dependencies?

Node.js 18 or later, TypeScript, and access to a MySQL database. The server uses connection pooling to manage database connections.

5

How do I test or debug the server?

Run `npm run inspector` to start the MCP Inspector, which provides a browser URL for testing tools and resources interactively.

Comments

More Databases MCP servers

Chroma MCP Server

chroma-core

A Model Context Protocol (MCP) server implementation that provides database capabilities for Chroma

569

mcp-server-qdrant: A Qdrant MCP server

qdrant

An official Qdrant Model Context Protocol (MCP) server implementation

637

MCP Server for MySQL based on NodeJS

benborla

A Model Context Protocol server that provides read-only access to MySQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.

1.9K

MotherDuck's DuckDB MCP Server

motherduckdb

Local MCP server for DuckDB and MotherDuck

498

nuzur

nuzur is a model-first database platform for MySQL and PostgreSQL. The MCP server lets any AI assistant or agent (Claude, Cursor, Gemini, or anything else that speaks MCP) design your schema, query your data, generate mi

Advertise