Skip to main content
Glama
CobaltBlue3699

MySQL MCP Server

by CobaltBlue3699
OverviewSchemaRelated ServersScoreDiscussions
TypeScript
Hybrid

MySQL MCP Server

A Model Context Protocol (MCP) server for MySQL databases, built with NestJS and MCP-Nest. Enables AI assistants like Claude and Cursor to interact with MySQL databases through a standardized protocol.

English · 繁體中文

Overview

MySQL MCP Server exposes MySQL database operations as MCP tools, allowing AI assistants to:

  • Query and explore database schemas

  • Execute SQL queries with permission controls

  • List tables, describe table structures, and browse databases

  • Run in multiple transport modes (stdio, HTTP SSE, Streamable HTTP)

Features

Description

Connection Pool

Efficient MySQL connection management with configurable pool size

Permission Control

Granular SQL operation permissions (SELECT, INSERT, UPDATE, DELETE, DDL)

DRY_RUN Mode

Validate SQL queries without returning actual data

MCP Tools

Standardized database operations exposed via Model Context Protocol

Graceful Shutdown

Clean resource cleanup on process termination

File Logging

Configurable log output with rotation support

Prerequisites

  • Node.js 18+

  • MySQL 5.7+ database

  • npm or pnpm package manager

Installation

# Global installation (recommended)
npm install -g @johnson.lee/mysql-mcp-server

# Or use npx
npx @johnson.lee/mysql-mcp-server

Quick Start

# Set environment variables
export DB_HOST=localhost
export DB_PORT=3306
export DB_USER=root
export DB_PASSWORD=your_password
export DB_NAME=your_database

# Run the server
mysql-mcp

Configuration

Configure via environment variables:

Database Connection

Variable

Default

Description

DB_HOST

localhost

MySQL host

DB_PORT

3306

MySQL port

DB_USER

root

MySQL user

DB_PASSWORD

-

MySQL password

DB_NAME

test_db

Database name

DB_POOL_MIN

2

Min pool connections

DB_POOL_MAX

10

Max pool connections

Permission Control

Variable

Default

Description

ALLOW_SELECT

true

Allow SELECT queries

ALLOW_VIEW

true

Allow SHOW / DESCRIBE

ALLOW_INSERT

false

Allow INSERT

ALLOW_UPDATE

false

Allow UPDATE

ALLOW_DELETE

false

Allow DELETE

ALLOW_DDL

false

Allow CREATE/ALTER/DROP/TRUNCATE

Server Options

Variable

Default

Description

MCP_SERVER_NAME

mysql-mcp-server

Server name — used as log file prefix

MCP_TRANSPORT

stdio

Transport: stdio/http-sse/streamable-http

LOG_LEVEL

info

Log level: debug/info/warn/error

LOG_DIR

./logs

Log directory

DRY_RUN

false

Validate SQL without returning data

Editor Integration

Claude Desktop

Edit ~/.config/claude/claude_desktop_config.json:

{
  "mcpServers": {
    "mysql": {
      "command": "npx",
      "args": ["@johnson.lee/mysql-mcp-server"],
      "env": {
        "DB_HOST": "localhost",
        "DB_USER": "root",
        "DB_PASSWORD": "your_password",
        "DB_NAME": "your_database"
      }
    }
  }
}

Cursor

Create .cursor/mcp.json:

{
  "mcpServers": {
    "mysql": {
      "command": "npx",
      "args": ["@johnson.lee/mysql-mcp-server"],
      "env": {
        "DB_HOST": "localhost",
        "DB_USER": "root",
        "DB_PASSWORD": "your_password",
        "DB_NAME": "your_database"
      }
    }
  }
}

Multi-Environment Setup

You can register multiple instances to connect different databases simultaneously. Each instance should have a unique MCP_SERVER_NAME, which is also used as the log file prefix — e.g. dev-info.log, prod-error.log.

Note: All env values must be strings. Use "true" / "false", not bare booleans.

{
  "mcpServers": {
    "dev-mysql": {
      "command": "npx",
      "args": ["@johnson.lee/mysql-mcp-server"],
      "env": {
        "MCP_SERVER_NAME": "dev",
        "DB_HOST": "dev-db.example.com",
        "DB_PORT": "3306",
        "DB_USER": "dev_user",
        "DB_PASSWORD": "dev_password",
        "DB_NAME": "dev_db",
        "LOG_DIR": "/tmp/mcp-logs"
      }
    },
    "prod-mysql": {
      "command": "npx",
      "args": ["@johnson.lee/mysql-mcp-server"],
      "env": {
        "MCP_SERVER_NAME": "prod",
        "DB_HOST": "prod-db.example.com",
        "DB_PORT": "3306",
        "DB_USER": "prod_user",
        "DB_PASSWORD": "prod_password",
        "DB_NAME": "prod_db",
        "LOG_DIR": "/tmp/mcp-logs",
        "DRY_RUN": "true"
      }
    }
  }
}

With the above config, log files are written to LOG_DIR with the server name as prefix:

/tmp/mcp-logs/
├── dev-info.log
├── dev-error.log
├── prod-info.log
└── prod-error.log

Available Tools

list_tables

List all tables in the current database.

describe_table

Get table structure (columns, types, keys, etc.).

{
  "name": "describe_table",
  "arguments": { "tableName": "users" }
}

execute_query

Execute SQL queries.

{
  "name": "execute_query",
  "arguments": { "sql": "SELECT * FROM users LIMIT 10" }
}

list_databases

List all available databases on the MySQL server.

Built with NestJS and MCP-Nest

Install Server
A
license - permissive license
A
quality
C
maintenance

How are these scores calculated?

Resources

Unclaimed servers have limited discoverability.

Looking for Admin?

If you are the server author, to access and configure the admin panel.

Tools

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/CobaltBlue3699/mysql-mcp-server'

If you have feedback or need assistance with the MCP directory API, please join our Discord server