MCP MySQL Server
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| MYSQL_SSL | No | Use SSL connection | false |
| MYSQL_HOST | No | MySQL server hostname or IP address | |
| MYSQL_PORT | No | MySQL server port | 3306 |
| MYSQL_USER | No | Database username | |
| MYSQL_DATABASE | No | Database name to connect to | |
| MYSQL_PASSWORD | No | Database 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
Server capabilities have not been inspected yet.
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| mysql_connectC | Connect to a MySQL database with provided connection parameters |
| mysql_queryC | Execute a SQL query on the connected MySQL database |
| mysql_list_databasesB | List all databases on the MySQL server |
| mysql_list_tablesB | List all tables in the current or specified database |
| mysql_describe_tableB | Get the structure/schema of a specific table |
| mysql_show_indexesC | Show indexes for a specific table |
| mysql_get_table_statsC | Get statistics about a table (row count, size, etc.) |
| mysql_disconnectB | Disconnect from the MySQL 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 with no ambiguity. Tools like mysql_describe_table (structure), mysql_get_table_stats (statistics), and mysql_show_indexes (indexes) target specific metadata aspects, while mysql_query handles general SQL execution. The connection/disconnection tools are also clearly separated from data operations.
All tools follow a consistent 'mysql_verb_noun' pattern with snake_case throughout. The naming is predictable and readable, making it easy for agents to understand the action and target (e.g., mysql_list_databases, mysql_describe_table). No deviations or mixed conventions are present.
With 8 tools, the server is well-scoped for MySQL database interaction. It covers essential operations like connection management, metadata inspection, and query execution without being overly complex or sparse. Each tool earns its place by addressing a specific need in the domain.
The tool set provides strong coverage for core MySQL operations, including connection lifecycle, database/table listing, schema inspection, and query execution. A minor gap exists in data manipulation (e.g., no dedicated tools for insert/update/delete beyond mysql_query), but agents can work around this using the general query tool.