MySQL MCP Server Qrx

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).