MCP Server for MySQL based on NodeJS

@MCP-Mirror

About MCP Server for MySQL based on NodeJS

Mirror of

Config

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

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

Tools

Execute read-only SQL queries against the connected database

Overview

What is MCP Server for MySQL based on NodeJS?

A Model Context Protocol server that provides read-only access to MySQL databases, enabling LLMs to inspect database schemas and execute read‑only queries. It is built on Node.js and is intended for developers who want their AI assistants to query MySQL safely.

How to use MCP Server for MySQL based on NodeJS?

Install via Smithery, MCP Get, or npm/pnpm globally, then configure your LLM application with the required environment variables (e.g., MYSQL_HOST, MYSQL_PORT, MYSQL_USER, MYSQL_PASS, MYSQL_DB). For Claude Desktop, add the server entry to claude_desktop_config.json with the command npx -y @benborla29/mcp-server-mysql and the env block. Once configured, the server exposes a mysql_query tool for read‑only queries and provides table schema resources.

Key features of MCP Server for MySQL based on NodeJS

Read‑only SQL execution via the mysql_query tool
Automatic discovery of table schemas, columns, indexes, and foreign keys
SQL injection prevention with prepared statements
Configurable rate limiting, query complexity analysis, and SSL encryption
Connection pooling, result caching, and streaming
Query logging, performance metrics, and health check endpoints

Use cases of MCP Server for MySQL based on NodeJS

LLMs answering questions by querying a MySQL database in a read‑only manner
Inspecting database schemas to help write accurate SQL queries
Generating reports or summaries from existing database content
Debugging or exploring unknown database structures via natural language

FAQ from MCP Server for MySQL based on NodeJS

What does this MCP server do?

It gives LLMs read‑only access to MySQL databases, allowing them to inspect schemas and run SELECT queries safely. All queries are executed within a READ ONLY transaction.

How do I install the server?

You can install it via Smithery (npx -y @smithery/cli@latest install @benborla29/mcp-server-mysql), MCP Get, or globally with npm (npm install -g @benborla29/mcp-server-mysql). After manual installation, configure your LLM app with environment variables.

What environment variables are required?

At minimum: MYSQL_HOST (default 127.0.0.1), MYSQL_PORT (default 3306), MYSQL_USER (default root), MYSQL_PASS, and MYSQL_DB. Optional variables control pool size, query timeout, cache TTL, rate limit, SSL, logging, and metrics.

Is the access really read‑only?

Yes. The server enforces read‑only transactions, uses prepared statements, and includes rate limiting and query complexity analysis to prevent dangerous operations.

How can I troubleshoot connection issues?

Verify that MySQL is running and accessible, check credentials and the caching_sha2_password plugin (MySQL 8.0+), ensure SSL/TLS settings are correct, and set the PATH environment variable if you get “Could not connect” errors.

Frequently asked questions

What does this MCP server do?

It gives LLMs read‑only access to MySQL databases, allowing them to inspect schemas and run SELECT queries safely. All queries are executed within a READ ONLY transaction.

How do I install the server?

You can install it via Smithery (`npx -y @smithery/cli@latest install @benborla29/mcp-server-mysql`), MCP Get, or globally with npm (`npm install -g @benborla29/mcp-server-mysql`). After manual installation, configure your LLM app with environment variables.

What environment variables are required?

At minimum: `MYSQL_HOST` (default 127.0.0.1), `MYSQL_PORT` (default 3306), `MYSQL_USER` (default root), `MYSQL_PASS`, and `MYSQL_DB`. Optional variables control pool size, query timeout, cache TTL, rate limit, SSL, logging, and metrics.

Is the access really read‑only?

Yes. The server enforces read‑only transactions, uses prepared statements, and includes rate limiting and query complexity analysis to prevent dangerous operations.

How can I troubleshoot connection issues?

Verify that MySQL is running and accessible, check credentials and the `caching_sha2_password` plugin (MySQL 8.0+), ensure SSL/TLS settings are correct, and set the `PATH` environment variable if you get “Could not connect” errors.

Comments

Basic information

More Databases MCP servers

Multi Database MCP Server

FreePeak

A powerful multi-database server implementing the Model Context Protocol (MCP) to provide AI assistants with structured access to databases.

397

MCP Alchemy

runekaagaard

A MCP (model context protocol) server that gives the LLM access to and knowledge about relational databases like SQLite, Postgresql, MySQL & MariaDB, Oracle, and MS-SQL.

412

MCP MongoDB Server

kiliczsh

A Model Context Protocol Server for MongoDB

281

MCP Server for MySQL based on NodeJS

benborla

A Model Context Protocol server that provides read-only access to MySQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.

1.9K

PostgreSQL

modelcontextprotocol

Model Context Protocol Servers

88.1K