MySQL MCP Server

Name: MySQL MCP Server
Author: MCP-Mirror

@MCP-Mirror

代码仓库

关于 MySQL MCP Server

Mirror of

#mysql #mcp-server #database

基本信息

分类

数据库

许可证

MIT license

运行时

node

传输方式

stdio

发布者

MCP-Mirror

配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

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

工具

未检测到工具

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

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

FAQ from MySQL MCP Server

What operations are allowed?

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

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.