Skip to main content
Glama
mcp-mysql-explorer

mcp-mysql-explorer

by xsg22

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault
MYSQL_HOSTYesThe MySQL host address.
MYSQL_PORTNoThe MySQL port number.3306
MYSQL_USERYesThe MySQL user name.
MYSQL_DATABASEYesThe MySQL database name.
MYSQL_PASSWORDYesThe MySQL password.
MYSQL_READ_ONLYNoWhether to run in read-only mode (true/false). Set to false to allow write operations.true

Instructions

Guidance the server publishes about itself, which clients place ahead of the tool catalog so the model reads it before choosing anything.

This server publishes no instructions, or was last inspected before Glama recorded them.

Capabilities

Features and capabilities supported by this server

Protocol revision2025-11-25

CapabilityDetails
tools
{
  "listChanged": false
}
prompts
{
  "listChanged": false
}
resources
{
  "subscribe": false,
  "listChanged": false
}
experimental
{}

Tools

Functions exposed to the LLM to take actions

NameDescription
list_tablesA

List all tables in the connected MySQL database.

describe_tableC

Get the schema (columns, types, keys) of a specific table.

Args: table_name: Name of the table to describe.

queryA

Execute a read-only SQL query (SELECT / SHOW / DESCRIBE / EXPLAIN).

Only SELECT, SHOW, DESCRIBE, and EXPLAIN statements are allowed.

Args: sql: The SQL query to execute.

execute_sqlB

Execute a write SQL statement (INSERT / UPDATE / DELETE / ALTER / CREATE / DROP, etc).

Use with caution: this modifies the database.

Args: sql: The SQL statement to execute.

get_table_indexesB

Show all indexes of a specific table.

Args: table_name: Name of the table.

get_create_tableC

Get the CREATE TABLE statement of a specific table.

Args: table_name: Name of the table.

get_database_infoA

Get overview information about the connected database, including size, table count, and charset.

Prompts

Interactive templates invoked by user choice

NameDescription

No prompts

Resources

Contextual data attached and managed by the client

NameDescription

No resources

TDQS

B3.3/5.0

Scored across 7 tools

Disambiguation4/5

The read/write split between query and execute_sql is explicitly stated in both descriptions, so an agent can pick correctly. The introspection tools (describe_table, get_table_indexes, get_create_table) overlap somewhat since DESCRIBE/SHOW can also surface keys and index info, but each has a distinct output focus.

Naming Consistency3/5

All names are snake_case, but verb conventions are mixed: list_tables/describe_table use one verb family, while get_table_indexes/get_create_table/get_database_info use 'get', and query/execute_sql are bare verb forms. Readable overall, but 'get_create_table' is awkward and the pattern isn't uniform.

Tool Count5/5

Seven tools is well-scoped for a MySQL explorer: schema discovery, ad-hoc read queries, writes, and database metadata each have exactly one owner. No tool feels redundant padding.

Completeness4/5

The surface covers introspection, read queries, write DDL/DML, and database-level info, so core workflows are supported. Minor gaps exist around database/schema switching (e.g. listing databases or selecting a schema) and explicit transaction control, which agents would have to work around with raw SQL.

Maintenance

ActivityMaintained
ResponsivenessNo recent community issues