MCP Mysql Server

What f4ww4z/mcp-mysql-server MCP server does

The f4ww4z/mcp-mysql-server MCP server gives AI models a standardized MCP interface for working with a MySQL database. It supports establishing a database connection, reading data with SELECT statements, changing data with INSERT, UPDATE, or DELETE statements, listing tables, and inspecting an individual table's structure.

The project is implemented for Node.js and includes TypeScript support. It is intended for use from MCP clients such as Claude Desktop, with configuration examples also provided for Codex on macOS and Windows.

How it works

The client starts the server with npx and supplies database connection details. Configuration can use a single MySQL URI, such as a connection string containing the user, password, host, port, and database name. Alternatively, the settings can be supplied through MYSQL_HOST, MYSQL_USER, MYSQL_PASSWORD, and MYSQL_DATABASE environment variables.

After the server has access to the database, the client can call these tools:

• connect_db establishes a connection using supplied credentials.
• query runs SELECT statements and accepts optional prepared-statement parameters.
• execute runs INSERT, UPDATE, or DELETE statements with optional parameters.
• list_tables returns the tables in the connected database.
• describe_table reports the structure of a named table.

The query and execute examples use ? placeholders with a separate params array. The project describes automatic connection management and cleanup, along with validation and error messages for connection failures, invalid queries, missing parameters, and database errors.

Setup and configuration

Install or run the package with the Node package runner:

npx -y @f4ww4z/mcp-mysql-server

An MCP configuration can pass the connection URI as an argument:

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

The alternative environment-based configuration passes the package without a URI and defines the four MySQL variables in the MCP server's env section. Replace the example credentials and database values with the target database's actual settings.

Tools and capabilities

The f4ww4z/mcp-mysql-server MCP server provides database access at the level of explicit MCP tool calls rather than a separate application interface. Its documented capabilities include:

• Running parameterized read queries.
• Running parameterized data modification statements.
• Connecting with supplied MySQL credentials.
• Enumerating tables in the active database.
• Inspecting a selected table's columns and structure.
• Handling passwords through environment variables.

Prepared statements are documented as a measure against SQL injection. Connections are automatically closed when finished, according to the project documentation.

Limitations and notes

It does not specify support for other database engines, migrations, transactions, stored procedures, or administrative operations. The execute tool is described for INSERT, UPDATE, and DELETE statements; other SQL statement types should not be assumed to be supported.

Database credentials and connection details must be supplied by the operator. The project is released under the MIT license.