MySQL Database Access MCP Server

@shensiqi0701

Basic information

About MySQL Database Access MCP Server

No overview available yet

MySQL Database Access MCP Server config

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

{
  "mcpServers": {
    "mysql-mcp-server-modification": {
      "command": "npx",
      "args": [
        "-y",
        "@smithery/cli",
        "install",
        "@dpflucas/mysql-mcp-server",
        "--client",
        "claude"
      ]
    }
  }
}

MySQL Database Access MCP Server tools

Tool list not available yet

This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.

Fetch the live tool list by running this server in a temporary sandbox using the button above.

Overview

What is MySQL Database Access MCP Server?

A read-only MCP server that provides tools to interact with MySQL databases, including listing databases, listing tables, describing table structures, and executing read-only SQL queries.

How to use MySQL Database Access MCP Server?

Install via npm (npm install -g @valuprosys/mysql-mcp-server), set the required environment variables (MYSQL_HOST, MYSQL_PORT, MYSQL_USER, MYSQL_PASSWORD, and optionally MYSQL_DATABASE), then add the server configuration to your MCP client config under mcpServers.mysql.

Key features of MySQL Database Access MCP Server

List all accessible databases on the MySQL server
List tables within a specified database
Describe table structure including column comments
Execute read-only SQL queries (SELECT, SHOW, DESCRIBE, EXPLAIN)

Use cases of MySQL Database Access MCP Server

Querying database metadata without writing full SQL
Exploring table schemas during development or debugging
Performing safe, read-only data lookups from an AI assistant

Frequently asked questions

What queries are allowed?

Only SELECT, SHOW, DESCRIBE, and EXPLAIN statements are permitted. Other SQL statements will be rejected.

What environment variables are required?

`MYSQL_HOST`, `MYSQL_PORT` (default 3306), `MYSQL_USER`, and `MYSQL_PASSWORD` must be set. `MYSQL_DATABASE` (default database name) is optional.

How do I configure the server with my MCP client?

Add the following to your MCP configuration under `mcpServers.mysql`: command `npx`, args `["@valuprosys/mysql-mcp-server"]`, and the necessary environment variables.