Advertise
MCP.so
Sign In

MCP Server for MySQL based on NodeJS

@MCP-Mirror

Repository

Basic information

Category

Databases

Transports

stdio

Author

MCP-Mirror

About MCP Server for MySQL based on NodeJS

Mirror of

#mcp-server#mysql#nodejs

MCP Server for MySQL based on NodeJS 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"
      }
    }
  }
}

MCP Server for MySQL based on NodeJS 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

Frequently asked questions

1

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.

2

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`.

3

Is the server truly read-only?

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

4

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.

5

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

Expired Domains MCP | Karma.Domains

karma-domains

Connect Karma.Domains to ChatGPT, Claude, Cursor, VS Code, or another MCP client — and find a domain in plain language. The same auctions, expired, backorder, and buy-now data you use in the app, plus saved filters, note

Xata MCP Server

The Xata MCP server lets AI assistants and agents interact with your Xata organizations, projects, and Postgres database branches.

Dbhub

bytebase

Zero-dependency, token-efficient database MCP server for Postgres, MySQL, SQL Server, MariaDB, SQLite.

3.1K

Redis

modelcontextprotocol

Model Context Protocol Servers

88.2K

Schemity

tbson

Local database MCP server: your agent sees a migration's impact before it runs, for PostgreSQL, MySQL, SQL Server and SQLite, with no database credentials.

Advertise