vitalydv

MySQL MCP Server

by vitalydv

データ分析

An MCP server that allows working with MySQL databases by providing tools for executing read-only SQL queries, getting table schemas, and listing database tables.

GitHubで見る

MySQL MCP Server

This project implements an MCP (Model Context Protocol) server for working with MySQL database.

Repository

This project is available on GitHub: https://github.com/vitalyDV/mysql-mcp

Clone the repository

git clone https://github.com/vitalyDV/mysql-mcp.git
cd mysql-mcp
npm install

add config to mcp.json

{
  "mcpServers": {
    "mysql_mcp_readonly": {
      "command": "node",
      "args": [
        "./mysql-mcp/index.js"
      ],
      "env": {
        "MYSQL_HOST": "127.0.0.1",
        "MYSQL_PORT": "3306",
        "MYSQL_USER": "root",
        "MYSQL_PASS": "",
        "MYSQL_DB": "db",
      }
    }
  }
}

Environment Variables

MYSQL_HOST - MySQL server host
MYSQL_PORT - MySQL server port
MYSQL_USER - MySQL username
MYSQL_PASS - MySQL password
MYSQL_DB - MySQL database name

Available MCP tools

query - execute SQL queries (only SELECT, SHOW, EXPLAIN, DESCRIBE)
table-schema - get table structure
list-tables - get list of all tables in the database

Available MCP resources

table://{name} - get data from the specified table (up to 100 rows)