Skip to main content
Glama
lemonq3q

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.

This server cannot be deployed

One endpoint for every MCP toolRayrun runs every MCP server behind one URL and holds the credentials. Each call is decided per client, tool, and argument, then recorded.ray.runAd

Maintenance

ActivityStale
ResponsivenessNo 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.
    600 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.
    133 npm
    MIT