MySQL Database Access MCP Server

@MCP-Mirror

Repository

Basic information

About MySQL Database Access MCP Server

Mirror of

#mysql #database #mcp-server

MySQL Database Access MCP Server config

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

{
  "mcpServers": {
    "mysql": {
      "command": "npx",
      "args": [
        "mysql-mcp-server"
      ],
      "env": {
        "MYSQL_HOST": "",
        "MYSQL_PORT": "",
        "MYSQL_USER": "",
        "MYSQL_PASSWORD": "",
        "MYSQL_DATABASE": ""
      }
    }
  }
}

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?

This MCP server provides read-only access to MySQL databases. It allows listing databases, listing tables, describing table schemas, and executing read-only SQL queries. It is designed for developers who need safe, read-only database exploration and querying via the Model Context Protocol.

How to use MySQL Database Access MCP Server?

Install globally via npm install -g mysql-mcp-server or locally. Configure environment variables (MYSQL_HOST, MYSQL_PORT, MYSQL_USER, MYSQL_PASSWORD, MYSQL_DATABASE). Add the server to your MCP settings file using either npx mysql-mcp-server (npm install) or node /path/to/build/index.js (build from source).

Key features of MySQL Database Access MCP Server

Read-only access: only SELECT, SHOW, DESCRIBE, EXPLAIN allowed
Query validation prevents SQL injection and data modification
Query timeout prevents long-running queries
Row limit prevents excessive data return
Tools: list_databases, list_tables, describe_table, execute_query

Use cases of MySQL Database Access MCP Server

Exploring database structure (list tables, describe schemas)
Running safe, read-only analytics queries
Integrating MySQL data with AI assistants via MCP
Checking database content without write risk

Frequently asked questions

What dependencies does this server require?

Node.js and npm. A MySQL database server accessible via the provided credentials is also required.

How is authentication handled?

Authentication uses environment variables: `MYSQL_USER`, `MYSQL_PASSWORD`, and optionally `MYSQL_HOST` and `MYSQL_PORT`.

What security restrictions are in place?

Only SELECT, SHOW, DESCRIBE, and EXPLAIN statements are allowed. Query validation blocks injection and data modification attempts. A query timeout and row limit protect resources.

Do I need to set up a MySQL user with specific permissions?

Yes. Your MySQL user must have appropriate permissions to list databases, list tables, describe schemas, and execute read-only queries on the target databases.