mcp-server-mysql-schema
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| MYSQL_HOST | No | MySQL host | 127.0.0.1 |
| MYSQL_PASS | No | MySQL password | |
| MYSQL_PORT | No | MySQL port | 3306 |
| MYSQL_USER | No | MySQL user | root |
| MYSQL_DEFAULT_DB | No | Default database for resource URIs |
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 | {} |
| resources | {} |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| schema_databasesA | List all non-system MySQL databases with charset and collation |
| schema_tablesA | List all tables in a database with engine, row count, size estimates, and comments |
| schema_viewsB | List all views in a database |
| schema_table_detailB | Show columns, types, defaults, nullable, keys, and comments for a table |
| schema_foreign_keysB | List foreign key relationships for a database or specific table (incoming + outgoing) |
| schema_indexesA | List all indexes for a table with columns, uniqueness, and type |
| schema_relationshipsB | Full relationship map across all tables in a database: primary keys, foreign keys, and references |
| schema_searchB | Search across table and column names in a database |
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 8 tools
Each tool has a clearly distinct purpose: databases, foreign keys, indexes, relationships, search, table details, tables, and views. No two tools overlap in function.
All tool names follow a consistent 'schema_noun' pattern using snake_case, making it easy to predict what each tool does.
With 8 tools, the server is well-scoped for MySQL schema exploration. Each tool covers a distinct aspect without excessive granularity.
The set covers essential schema exploration: databases, tables, columns, indexes, foreign keys, relationships, views, and search. Missing stored procedures or events, but these are not core to schema inspection.