@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.