@davewind/mysql MCP Server

@MCP-Mirror

代码仓库

基本信息

分类

数据库

许可证

MIT license

传输方式

stdio

作者

MCP-Mirror

关于 @davewind/mysql MCP Server

Mirror of

#mysql #mcp-server #database-access

@davewind/mysql MCP Server 配置

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

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

@davewind/mysql MCP Server 工具

Execute read-only SQL queries against the connected database

概览

What is @davewind/mysql-mcp-server?

It is a Model Context Protocol server that enforces read-only access to MySQL databases, allowing LLMs to inspect database schemas and execute read-only SQL queries. It acts as an intermediary between LLMs and MySQL databases, processing requests according to the MCP specification.

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 command npx -y @davewind/mysql-mcp-server followed by the MySQL connection string (e.g., mysql://user:password@localhost:port/database). The server exposes a single tool query that accepts a sql parameter and executes SELECT statements within READ ONLY transactions.

Key features of @davewind/mysql-mcp-server

Read-only access enforced through SQL validation and READ ONLY transactions
Automatic schema discovery of database table structures
Secure SQL query execution for SELECT statements only
Full compliance with the Model Context Protocol specification
Minimal configuration required for setup

Use cases of @davewind/mysql-mcp-server

Enable LLMs to explore database schemas without risk of modification
Execute safe read-only queries for data analysis or reporting
Integrate database knowledge into AI assistants without write access
Automate schema inspection for documentation or migration planning

常见问题

Does the server support write operations?

No. It strictly enforces read-only access by validating SQL queries (only SELECT allowed) and running all queries in READ ONLY transactions. INSERT, UPDATE, DELETE, CREATE, ALTER, DROP operations are not supported.

What runtime environment is required?

Node.js v18 or higher is required to run the server.

How does the server communicate with LLMs?

It uses JSON-RPC over stdio, following the Model Context Protocol specification, and is compatible with any LLM system that supports the MCP standard.

What is the security model implemented?

The server validates SQL queries to block any non-SELECT statements, executes all queries in READ ONLY transactions, and prevents data modification or schema alteration (e.g., CREATE, ALTER, DROP).

How do I configure the connection to my MySQL database?

In your MCP settings file, set the command to `npx -y @davewind/mysql-mcp-server` and provide the MySQL connection string as a command argument in the format `mysql://user:password@localhost:port/database`.

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

MySQL MCP Server

designcomputer

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

1.3K

MCP Alchemy

runekaagaard

A MCP (model context protocol) server that gives the LLM access to and knowledge about relational databases like SQLite, Postgresql, MySQL & MariaDB, Oracle, and MS-SQL.

412

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