Mysql_mcp_server

general MCP Server

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

FreshInstall Ready
generalgeneralmysql
12 views1,391 stars257 forksMIT

Why This Matters

Discovered via unknown and last synced 3d ago.

FreshInstall Ready
Source
unknown
Stars
1,391
Last synced
3d ago
Install
Instructions detected

Install

1. Install the package

uvx --from mysql-mcp-server mysql_mcp_server

2. Add to claude_desktop_config.json

{
  "mcpServers": {
    "mysql_mcp_server": {
      "command": "uvx",
      "args": [
        "--from",
        "mysql-mcp-server",
        "mysql_mcp_server"
      ]
    }
  }
}

Config file location: ~/Library/Application Support/Claude/claude_desktop_config.json (macOS) / %APPDATA%\Claude\claude_desktop_config.json (Windows)

19
Tools
0
Resources
0
Prompts
Standard I/O
Transport

Available Tools (19)

Variable

Description

MYSQL_HOST

MySQL host

mysql_list_tables

List tables in the configured database

No

`1000`

mysql_describe_table

Show schema for a table

mysql_execute_write_query

Execute a single INSERT, UPDATE, or DELETE

mysql_get_table_ddl

Return `SHOW CREATE TABLE` output

LOG_LEVEL

Python logging level

MYSQL_DATABASE

MySQL database name

mysql_execute_ddl

Execute a single CREATE, DROP, ALTER, or TRUNCATE

MYSQL_USER

MySQL username

mysql_execute_read_query

Execute a single bounded SELECT query

Tool

Purpose

mysql_explain_query

Run `EXPLAIN` for a single query

mysql_get_database_summary

Return table list and row counts

Arguments:

`query` (string)

Features:

Supports `SELECT`, `SHOW`, `DESCRIBE`, and DML (`INSERT`, `UPDATE`, `DELETE`). DML operations are marked with a destructive hint.

Limitation:

Single statements only. Multi-statement queries are not supported.

Cross-database:

Use `database.table` notation to query any database regardless of the `MYSQL_DATABASE` setting.