@davewind/mysql-mcp-server

Name: @davewind/mysql-mcp-server
Author: dave-wind

@dave-wind

代码仓库

关于 @davewind/mysql-mcp-server

mcp model-context-protocol mysql cursor n8n

基本信息

分类

数据库

许可证

MIT

运行时

node

传输方式

stdio

发布者

dave-wind

配置

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

{
  "mcpServers": {
    "mysql": {
      "command": "npx",
      "args": [
        "-y",
        "@davewind/mysql-mcp-server",
        "mysql://user:password@localhost:port/database"
      ]
    }
  }
}

工具

Execute read-only SQL queries against the connected database

概览

What is @davewind/mysql-mcp-server?

@davewind/mysql-mcp-server is a Model Context Protocol server that provides read-only access to MySQL databases. It enables LLMs to inspect database schemas and execute read-only SQL queries using a secure, MCP-compliant interface.

How to use @davewind/mysql-mcp-server?

Install the package globally via npm install @davewind/mysql-mcp-server -g, then configure your MCP settings file with the server command and a MySQL connection string. The server is invoked with npx -y @davewind/mysql-mcp-server mysql://user:password@localhost:port/database.

Key features of @davewind/mysql-mcp-server

Read-only database access with SQL validation and READ ONLY transactions
Automatic schema discovery for all tables in the database
Single query tool that accepts and executes SELECT statements
Full compliance with the Model Context Protocol specification
Simple configuration requiring only a connection string

Use cases of @davewind/mysql-mcp-server

Enabling LLMs to answer questions about database structure and contents
Allowing AI assistants to generate reports from read-only data
Providing safe, auditable database introspection for MCP-compatible agents
Building tools that let language models explore relational data without risk of modification

FAQ from @davewind/mysql-mcp-server

What SQL operations does @davewind/mysql-mcp-server support?

Only SELECT statements are allowed. The server enforces read-only access through SQL validation and executes all queries within READ ONLY transactions. Modification commands (INSERT, UPDATE, DELETE) and schema changes (CREATE, ALTER, DROP) are not supported.

What are the runtime requirements?

Node.js version 18 or higher is required. The server runs as an MCP tool and communicates via stdio using JSON-RPC.

Where does the data live?

The server connects to an external MySQL database specified by the user in the connection string. No data is stored locally; all queries operate directly on the target database.

How does authentication work?

Authentication is handled through the MySQL connection string passed at startup, which includes username and password (e.g., mysql://user:password@localhost:port/database).

Can this server modify the database schema?

No. The security model explicitly prevents any schema modification (CREATE, ALTER, DROP) as well as data modification (INSERT, UPDATE, DELETE). Only read-only SELECT queries are permitted.