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

MySQL MCP Server

designcomputer

A Model Context Protocol (MCP) server that enables secure interaction with MySQL databases

1.3K

Sqlite

modelcontextprotocol

Model Context Protocol Servers

88.1K

Lawstronaut

Lawstronaut-FZCO

Access millions of official legal and regulatory source documents from 155+ jurisdictions via MCP. Lawstronaut supports AI agents with structured legal research, legal data, laws, regulations, cases, guidance, official s

MCP DB Wizard

srmadscience

Oracle MCP server with no run-sql tool: It generates tools for each of the PL/SQL procedures, tables and approved SQL you choose. The server doesn't expose a SQL prompt, and can't reveal how it's connected to Oracle.

1

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
Advertise