Production Safe Mysql Mcp Server

Name: Production Safe Mysql Mcp Server
Author: turkeryildirim

@turkeryildirim

Repository

About Production Safe Mysql Mcp Server

No overview available yet

#mysql #database #production

Basic information

Config

Add this server to your MCP-compatible client using the configuration below.

{
  "mcpServers": {
    "mysql": {
      "command": "node",
      "args": [
        "/absolute/path/to/mysql-mcp/dist/index.js"
      ],
      "env": {
        "MYSQL_HOST": "localhost",
        "MYSQL_PORT": "3306",
        "MYSQL_USER": "mcp_user",
        "MYSQL_PASSWORD": "your_password",
        "MYSQL_DATABASE": "",
        "MAX_ROWS": "1000",
        "ALLOW_DESTRUCTIVE_DDL": "false"
      }
    }
  }
}

Tools

No tools detected

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

What is Production Safe Mysql Mcp Server?

Production Safe Mysql Mcp Server is an Model Context Protocol (MCP) server that provides AI agents with direct, controlled access to MySQL databases. It supports data query and mutation, schema management, database administration, and introspection, with built-in safety restrictions to prevent destructive or system-level operations.

How to use Production Safe Mysql Mcp Server?

Install Node.js 20+, clone the repository, run npm install and npm run build, then copy .env.example to .env and configure MySQL credentials. Integrate with Claude Desktop via claude_desktop_config.json or with Claude CLI using .mcp.json or claude mcp add. All tools accept a database parameter for multi-database access within the same session.

Key features of Production Safe Mysql Mcp Server

execute_query – Run SELECT, INSERT, UPDATE, DELETE with parameterized queries
execute_transaction – Execute atomic batches with automatic rollback on failure
Schema management: create_table, alter_table, drop_table (with flag)
Database management: list_databases, create_database, drop_database (with flag)
Introspection tools: ping, show_columns, get_server_info
Multi-database support via database parameter on every tool
Security filter permanently blocks user/privilege/replication/file/plugin commands

Use cases of Production Safe Mysql Mcp Server

Query and view table structures in natural language
Insert, update, or delete rows with parameterized safety
Run multi‑statement operations as a single atomic transaction
Create or alter tables and databases through AI agent commands
Inspect server version, character set, and connection health

FAQ from Production Safe Mysql Mcp Server

What operations are permanently blocked?

Commands in categories like MySQL settings (SET GLOBAL), user/privilege management (CREATE USER, GRANT), system commands (FLUSH, KILL), replication, file access (SELECT INTO OUTFILE), and plugins (INSTALL PLUGIN) are blocked and cannot be bypassed.

How do I enable `drop_table` or `drop_database`?

Set the environment variable ALLOW_DESTRUCTIVE_DDL=true. By default (false), these tools return an error. This flag can be disabled for production safety.

What is the maximum number of rows returned?

Query results are capped by the MAX_ROWS environment variable (default 1000). For large tables, add a LIMIT clause.

Can I execute multiple SQL statements in one call?

No. Multiple statements separated by semicolons are not allowed in a single tool call. Use execute_transaction to run multiple statements atomically.

Do I need a separate MySQL user?

Yes, it is recommended to create a dedicated user with only the necessary grants (SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER, INDEX) and avoid granting SUPER, FILE, RELOAD, or GRANT OPTION.