Mysql MCP Server

What davewind/mysql-mcp-server MCP server does

davewind/mysql-mcp-server MCP server provides an MCP interface for inspecting MySQL databases and running read-only SQL. The connection is supplied as a MySQL URI, and the server acts as an intermediary between an MCP client and the database.

Its main query capability accepts a SQL string and executes it against the configured database. The README describes the query input as sql, and the repository listing identifies the exposed MCP tool as sql. In either case, the supported operation is read-only query execution rather than mutation.

The server also makes table schema information available as MCP resources. Discovered metadata includes table structures, column names, and data types, allowing an LLM to inspect the database before forming a query.

How it works

The davewind/mysql-mcp-server MCP server communicates with compatible LLM applications using JSON-RPC over standard input and output. An MCP client starts the Node.js process and passes the MySQL connection URI as a command-line argument.

Before execution, SQL is validated to allow SELECT statements. Each accepted query runs in a READ ONLY transaction. The implementation also excludes INSERT, UPDATE, DELETE, and other data modification operations, as well as schema changes such as CREATE, ALTER, and DROP.

Schema resources use a MySQL-style URI, such as mysql://user:password@localhost:3306/database, to identify the connected database. The supplied credentials and host details therefore need to provide access to the target MySQL instance.

Setup and configuration

The package can be installed globally with npm:

npm install @davewind/mysql-mcp-server -g

The recommended MCP configuration starts it with npx and passes the database URI as an argument:

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

Replace the example connection string with the credentials, host, port, and database for your MySQL deployment. The README lists Node.js 18 or newer as the runtime requirement. The project communicates over stdio, so the client must support launching local MCP processes.

Tools and capabilities

The davewind/mysql-mcp-server MCP server supports:

• Executing read-only SQL queries supplied as a string.
• Validating queries so only SELECT operations are accepted.
• Running queries inside READ ONLY transactions.
• Discovering table schemas from database metadata.
• Returning table column names and data types as schema resources.

The repository describes the server as suitable for Cursor and n8n, while its MCP implementation is intended for LLM systems that support the protocol.

Limitations and notes

This server is not a general-purpose MySQL administration tool. It does not support writes or schema modification, including INSERT, UPDATE, DELETE, CREATE, ALTER, and DROP operations. Access is limited by the permissions and reachability of the MySQL connection supplied at startup.

The README documents a local stdio integration rather than a hosted endpoint. It does not describe environment variables, OAuth, API-key authentication, or a managed database service. The project is released under the MIT license.