MCP.so
Sign In

MCP Server for MySQL based on NodeJS

@MCP-Mirror

Repository

About MCP Server for MySQL based on NodeJS

Mirror of

#mcp-server#mysql#nodejs

Basic information

Category

Databases

Transports

stdio

Publisher

MCP-Mirror

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

1

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.

Comments

More Databases MCP servers

Neon MCP Server

neondatabase

MCP server for interacting with Neon Management API and databases

617

MongoDB Lens

furey

🍃🔎 MongoDB Lens: Full Featured MCP Server for MongoDB Databases

204

mcp_mysql_server

xwb602625136

Model Context Protocol (MCP) server that supports secure interaction with MySQL databases and has anomaly analysis capabilities.更加牛逼！更加好用！不仅止于mysql的增删改查功能； 还包含了数据库异常分析能力；且便于开发者们进行个性化的工具扩展

245

MongoDB MCP Server

mongodb-js

A Model Context Protocol server to connect to MongoDB databases and MongoDB Atlas Clusters.

1.1K

Redis MCP Server

redis

The official Redis MCP Server is a natural language interface designed for agentic applications to manage and search data in Redis efficiently

539