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 | localhost |
| 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, mysql_get_table_stats, and mysql_show_indexes all target different aspects of table metadata without overlap, while mysql_query handles general SQL execution separately from specific operations.
All tools follow a perfect mysql_verb_noun pattern with consistent snake_case throughout. The naming is highly predictable, making it easy for agents to understand and locate tools (e.g., mysql_list_databases, mysql_list_tables, mysql_describe_table).
With 8 tools, this server is well-scoped for MySQL database operations. Each tool earns its place by covering essential functions like connection management, metadata inspection, and query execution without being overly sparse or bloated.
The toolset provides strong coverage for core MySQL operations, including connection lifecycle, database/table listing, schema inspection, and query execution. A minor gap exists in lacking explicit CRUD operations (e.g., insert, update, delete), but agents can work around this using mysql_query for such tasks.