Database · Developer Tools

MySQL MCP Server Qrx logo

MySQL MCP Server Qrx

kaulvimal/mysql-mcp

This project provides a read-only Model Context Protocol (MCP) server for interacting with MySQL & PostgreSQL databases. It allows clients compatible with MCP to inspect database schemas, retrieve metadata, and execute read-only SQL queries through a set of defined tools.

Install

Client configuration

{
  "mcpServers": {
    "mysql-mcp": {
      "command": "/path/to/your/mysql-mcp.sh"
    }
  }
}

Environment variables

MYSQL_HOSTMYSQL_USERMYSQL_PASSWORDMYSQL_PORTPG_HOSTPG_USERPG_PASSWORDPG_PORTPG_DATABASE
GitHub stars
2
Category
Database, Developer Tools
Updated
Oct 6, 2026

About MySQL MCP Server Qrx

The server is built with extensibility in mind and enforces read-only operations for safety.

Tools (16)

  • get_table_columns

    Retrieves column definitions for a specific table.

  • get_schema

    Fetches detailed schema information including tables, columns, indexes, and constraints, with varying detail levels.

  • get_indexes

    Retrieves index information for a specific table or all tables.

  • get_constraints

    Fetches constraint information (Primary Key, Foreign Key, Unique, Check) for a specific table or all tables.

  • compare_schemas

    Compares the structure (tables and columns) of two different database schemas.

  • explain_schema

    Generates a textual or structured (JSON) description of the database schema.

  • detect_schema_changes

    Returns a snapshot of the current schema.

  • find_relationships

    Discovers explicit foreign key relationships.

  • find_navigation_paths

    Finds paths between two tables using explicit foreign key relationships (BFS algorithm).

  • execute_query

    Executes a given read-only SQL query (SELECT, SHOW, DESCRIBE, EXPLAIN).

  • execute_batch

    Runs multiple read-only SQL queries sequentially.

  • prepare_statement

    Prepares and executes a read-only SQL statement with parameters.

  • explain_query

    Executes EXPLAIN on a given SQL statement to show the query execution plan (TEXT or JSON format).

  • get_query_history

    Placeholder tool.

  • visualize_schema

    Generates schema representations (tables, columns, relationships) in JSON, DOT (Graphviz), or Mermaid syntax suitable for creating ER diagrams.

  • get_performance_metrics

    Retrieves selected global status variables from MySQL (e.g., Uptime, Threads, Queries).

Details on this page are taken from the project's README. Open README

Supported clients

Clients mentioned in this server's README:

View all
Cursor logo

Cursor

Desktop · Freemium · Proprietary

The first agentic IDE. The Cursor editor truly merges how developers and AI work together, delivering a magical coding experience.

WindowsMacOSLinux

Related MCP servers

More servers
Supabase MCP logo

Supabase MCP

supabase-community/supabase-mcp

1.3k

The Model Context Protocol (MCP) standardizes how Large Language Models (LLMs) talk to external services like Supabase. It connects AI assistants directly with your Supabase project and allows them to perform tasks like managing tables, fetching config, and querying data. See the full list of tools.

Database
Genai Toolbox logo

Genai Toolbox

googleapis/genai-toolbox

769

MCP Toolbox for Databases is an open source Model Context Protocol (MCP) server that connects your AI agents, IDEs, and applications directly to your enterprise databases.

Database
Supabase MCP Server logo

Supabase MCP Server

alexander-zuev/supabase-mcp-server

677

Query MCP is an open-source MCP server that lets your IDE safely run SQL, manage schema changes, call the Supabase Management API, and use Auth Admin SDK — all with built-in safety controls.

Database
Awesome MCP List logo

Awesome MCP List

MobinX/awesome-mcp-list

645

This is a continuously updated curated list of MCP servers, covering categories such as browser control, arts and culture, cloud platforms, command line, communication, customer data platforms, databases, developer tools, data science tools, file systems, finance and fintech, gaming, knowledge and memory, location services, marketing, monitoring, search and utilities. Each project includes a GitHub link and star count for quick reference and use.

Database
PostgreSQL Model Context Protocol (PG MCP) Server logo

PostgreSQL Model Context Protocol (PG MCP) Server

stuzero/pg-mcp-server

440

PG-MCP is a server implementation of the Model Context Protocol for PostgreSQL databases. It provides a comprehensive API for AI agents to discover, connect to, query, and understand PostgreSQL databases through MCP's resource-oriented architecture.

Database
dbhub logo

dbhub

bytebase/dbhub

332

[!NOTE] If you need an enterprise-level database MCP server with built-in guardrails like approval flow, access control, data masking, and audit logging beyond what DBHub offers, check out Bytebase.

Database