local-mysql
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| MYSQL_HOST | Yes | MySQL host, e.g., 127.0.0.1 | |
| MYSQL_PORT | Yes | MySQL port, e.g., 3306 | |
| MYSQL_USER | Yes | MySQL user, e.g., mcp_reader | |
| MYSQL_DATABASE | Yes | MySQL database name | |
| MYSQL_MAX_ROWS | Yes | Maximum rows returned by queries, e.g., 200 | |
| MYSQL_PASSWORD | Yes | MySQL password |
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
| Capability | Details |
|---|---|
| tools | {
"listChanged": true
} |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| queryB | Run a single read-only MySQL query. SELECT, SHOW, DESCRIBE, DESC, EXPLAIN, and WITH are allowed. |
| list_databasesA | List databases visible to the configured MySQL user. |
| list_tablesA | List tables in the configured database or in the database argument. |
| describe_tableC | Show column metadata for a table. |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |
TDQS
Scored across 4 tools
Each tool has a clearly distinct purpose: describe_table for column metadata, list_databases for databases, list_tables for tables, and query for arbitrary read-only SQL. No overlap.
All tool names follow a consistent verb_noun pattern: describe_table, list_databases, list_tables, query. The pattern is uniform and predictable.
With 4 tools, the set is well-scoped for a read-only MySQL server. It covers the essential operations without unnecessary extras.
The tools cover listing databases and tables, describing table structure, and running arbitrary read queries. Minor omissions like SHOW VARIABLES could be added but are accessible via query.