MySQL Database Access MCP Server

@dpflucas

代码仓库

基本信息

分类

数据库

许可证

MIT

传输方式

stdio

作者

dpflucas

关于 MySQL Database Access MCP Server

An MCP server provides read-only access to MySQL databases.

MySQL Database Access MCP Server 配置

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

{
  "mcpServers": {
    "mysql-mcp-server": {
      "command": "npx",
      "args": [
        "-y",
        "@smithery/cli",
        "install",
        "@dpflucas/mysql-mcp-server",
        "--client",
        "claude"
      ]
    }
  }
}

MySQL Database Access MCP Server 工具

工具列表暂未提供

当前收录暂时没有可展示的工具列表，不代表服务没有工具。请查阅项目文档了解支持的能力。

点击上方按钮,在临时沙箱中运行此服务器并实时获取工具列表。

概览

What is MySQL Database Access MCP Server?

This MCP server provides read-only access to MySQL databases, allowing users to list databases, list tables, describe schemas, and execute safe SQL queries. It is designed for AI assistants and tools that need to inspect or query MySQL data without modification.

How to use MySQL Database Access MCP Server?

Install via npm (npm install -g mysql-mcp-server), build from source, or use Smithery. Configure environment variables (MYSQL_HOST, MYSQL_PORT, MYSQL_USER, MYSQL_PASSWORD, MYSQL_DATABASE) and add the server to your MCP settings file. Once connected, invoke the tools list_databases, list_tables, describe_table, or execute_query with the required parameters.

Key features of MySQL Database Access MCP Server

Read-only access to MySQL databases
Query validation against injection and modification
Query timeout and row limit protection
Tools: list databases, list tables, describe schema
Execute SELECT, SHOW, DESCRIBE, EXPLAIN queries
Advanced connection pool configuration

Use cases of MySQL Database Access MCP Server

Exploring database structure (tables, schemas) via an AI assistant
Retrieving read-only data for analysis or reporting
Inspecting table schemas before integration or migration
Debugging queries without risk of accidental writes

常见问题

What types of queries are allowed?

Only SELECT, SHOW, DESCRIBE, and EXPLAIN statements are permitted. All other statements are blocked for safety.

What environment variables are required?

`MYSQL_HOST`, `MYSQL_PORT`, `MYSQL_USER` are required. `MYSQL_PASSWORD` and `MYSQL_DATABASE` are optional but recommended.

How do I install the server?

Install globally from npm (`npm install -g mysql-mcp-server`), locally in a project, build from source, or use the Smithery CLI.

Are there any limits on queries?

Yes: a query timeout prevents long-running queries, and a row limit prevents excessive data return. The connection pool is also configurable.

Can I write or modify data?

No. The server enforces read-only access; any attempt to execute INSERT, UPDATE, DELETE, or DDL statements is rejected.

数据库分类下的更多 MCP 服务器

MySQL MCP Server

designcomputer

A Model Context Protocol (MCP) server that enables secure interaction with MySQL databases

1.3K

MCP DB Wizard

srmadscience

Oracle MCP server with no run-sql tool: It generates tools for each of the PL/SQL procedures, tables and approved SQL you choose. The server doesn't expose a SQL prompt, and can't reveal how it's connected to Oracle.

Sqlite

modelcontextprotocol

Model Context Protocol Servers

88.1K

Elasticsearch MCP Server

elastic

685

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