MCP Server for MySQL based on NodeJS

Name: MCP Server for MySQL based on NodeJS
Author: MCP-Mirror

@MCP-Mirror

Repository

About MCP Server for MySQL based on NodeJS

Mirror of

#mcp-server #mysql #nodejs

Basic information

Config

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

{
  "mcpServers": {
    "mcp_server_myqsl": {
      "command": "npx",
      "args": [
        "-y",
        "@benborla29/mcp-server-mysql"
      ],
      "env": {
        "MYSQL_HOST": "127.0.0.1",
        "MYSQL_PORT": "3306",
        "MYSQL_USER": "root",
        "MYSQL_PASS": "",
        "MYSQL_DB": "db_name"
      }
    }
  }
}

Tools

Execute read-only SQL queries against the connected database

Overview

What is MCP Server for MySQL based on NodeJS?

MCP Server for MySQL based on NodeJS is a Model Context Protocol server that provides read-only access to MySQL databases. It enables LLMs to inspect database schemas and execute read-only SQL queries.

How to use MCP Server for MySQL based on NodeJS?

Add the server configuration to the mcpServers section of your Claude Desktop configuration file (claude_desktop_config.json), using npx with environment variables (MYSQL_HOST, MYSQL_PORT, MYSQL_USER, MYSQL_PASS, MYSQL_DB). The mysql_query tool can then be invoked for read‑only queries.

Key features of MCP Server for MySQL based on NodeJS

Read-only access to MySQL databases
Inspect database schemas automatically
Execute custom SQL queries via the mysql_query tool
All queries run within a READ ONLY transaction
Exposes JSON schema information for each table
Table schemas discovered from database metadata

Use cases of MCP Server for MySQL based on NodeJS

LLM-driven database schema exploration
Running read-only analysis queries against a MySQL database
Automating data retrieval for reporting or summarization

FAQ from MCP Server for MySQL based on NodeJS

What does the server do?

It provides a Model Context Protocol interface that gives an LLM read-only access to a MySQL database, allowing schema inspection and safe query execution.

How do I configure the database connection?

Set the environment variables MYSQL_HOST, MYSQL_PORT, MYSQL_USER, MYSQL_PASS, and MYSQL_DB in the server configuration inside claude_desktop_config.json.

Is the server truly read-only?

Yes. All SQL queries are executed within a READ ONLY transaction, preventing any write operations.

What resources does the server expose?

It exposes JSON schema information for each table, including column names and data types, automatically discovered from the database metadata.

What are the runtime requirements?

The server requires Node.js and npx. If the server fails to connect, you may need to explicitly set the PATH environment variable in the configuration to include the location of Node.js binaries.