Skip to main content
Glama
Sign In
MySQL Ops MCP

MySQL Ops MCP

by lemonq3q
OverviewSchemaSourceRelated ServersDiscussionsAdmin
TypeScript
Remote

# MySQL Ops MCP

A generic MCP server for MySQL operations.

It supports:

  • Listing databases and tables.

  • Describing tables.

  • Showing indexes and triggers.

  • Running read-only SQL: SELECT, SHOW, DESCRIBE, DESC, EXPLAIN.

  • Running explicitly requested write SQL when MYSQL_WRITE_ENABLED=true.

  • Logging every executed write SQL file under mysql-ops-logs/ in the current project root.

Configuration

Copy .env.example to .env.local and set your MySQL connection:

MYSQL_HOST=127.0.0.1
MYSQL_PORT=3306
MYSQL_USER=root
MYSQL_PASSWORD=change-me
MYSQL_DEFAULT_DATABASE=insurance
MYSQL_WRITE_ENABLED=true
MYSQL_EXECUTION_LOG_DIR=mysql-ops-logs

.env.local is ignored by Git.

Related MCP server: keevor-mysql-mcp-server

Tools

  • mysql_current_config

  • mysql_list_databases

  • mysql_list_tables

  • mysql_describe_table

  • mysql_show_indexes

  • mysql_show_triggers

  • mysql_query_readonly

  • mysql_explain

  • mysql_execute_sql

  • mysql_execute_file

  • mysql_create_backup_sql

High-risk SQL such as DROP DATABASE, TRUNCATE TABLE, and UPDATE or DELETE without WHERE requires confirmHighRisk=true.

Tool Schema Changelog

Recent tool additions, removals, and schema changes observed during successful MCP inspections.

Loading tool schema changelog…

    This server cannot be deployed

    Claude Code, inside the Godot 4 editorFlockbay puts an AI agent in the real Godot 4 editor: it writes GDScript, runs your game and fixes what breaks. Free, or bring your own Claude Code or Codex.flockbay.comAd

    Maintenance

    ActivityInactive
    ResponsivenessNo recent community issues

    Resources

    Related MCP Connectors

    Related MCP Servers

    • mysql-mcp

      eastgatedev
      A
      license
      Not graded
      quality
      B
      maintenance
      A MySQL MCP server for local stdio clients, enabling database queries and management with read-only/write modes, audit logging, and configurable security.
      526 npm
      MIT

    • MCP MySQL Server

      efeabio
      A
      license
      Not graded
      quality
      D
      maintenance
      A robust MCP server for interacting with MySQL databases through AI agents, providing tools for schema analysis, query execution, and dynamic connection management with read-only security.
      81 npm
      MIT