@davewind/mysql-mcp-server

Name: @davewind/mysql-mcp-server
Author: MCP-Mirror

@MCP-Mirror

Repository

About @davewind/mysql-mcp-server

Mirror of

#mysql #mcp-server #database-access

Basic information

Config

Add this server to your MCP-compatible client using the configuration below.

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

Tools

Execute read-only SQL queries against the connected database

Overview

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

FAQ from @davewind/mysql-mcp-server

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.