mysql-db-reader
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| PORT | No | HTTP server port (default 3002) | |
| MYSQL_URL | No | MySQL connection URL, e.g. mysql://user:password@localhost:3306/mydb | |
| DATABASE_URL | No | Generic database URL (also accepted for MySQL) | |
| MYSQL_CONNECTION_STRING | No | Alternative MySQL connection string |
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 |
|---|---|
| mysql_explain_queryA | Run EXPLAIN on a SELECT query to show the query execution plan. Use this to analyze query performance and identify missing indexes. |
| mysql_get_table_schemaA | Get table column definitions, primary key, indexes, and constraints. Use this to understand table structure before writing queries. |
| mysql_list_databasesA | List available databases (schemas) on the MySQL server. Use this first to discover what databases exist before querying tables. |
| mysql_list_tablesA | List tables (and optionally views) in a database. Use this after mysql_list_databases to discover available tables before querying or inspecting schema. |
| mysql_preview_tableA | Preview first N rows from a table with optional ordering. Use this to quickly inspect sample data without writing SQL. |
| mysql_queryA | Run a read-only SQL query with optional positional parameters. For complex queries or when you need JOINs, aggregations, or filtering. Results are limited to 10,000 rows; use LIMIT for large tables. |
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 6 tools
Each tool has a clearly distinct purpose: listing databases, listing tables, getting schema, previewing rows, explaining queries, and running arbitrary queries. There is no overlap or ambiguity.
All tools follow a consistent 'mysql_verb_noun' pattern (e.g., mysql_list_databases, mysql_preview_table). The naming is uniform and predictable.
With 6 tools, the set is well-scoped for a read-only database server. Each tool earns its place by covering a distinct operation without redundancy or unnecessary bloat.
The tool set covers the main workflow: discovery (list databases, list tables), schema inspection, data preview, query execution, and performance analysis. Minor gaps like 'SHOW CREATE TABLE' or view support exist, but the core read-only operations are complete.