easy-mysql-admin-mcp
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| MYSQL_HOST | Yes | MySQL host name or IP address | |
| MYSQL_PORT | No | MySQL port | 3306 |
| MYSQL_USER | Yes | MySQL user name | |
| MYSQL_DATABASE | Yes | Default database/schema used for the admin connection | |
| MYSQL_MAX_IDLE | No | Maximum number of idle pool connections | 10 |
| MYSQL_PASSWORD | Yes | MySQL password | |
| MYSQL_QUEUE_LIMIT | No | Maximum queued connection requests | 0 |
| MYSQL_IDLE_TIMEOUT | No | Idle connection timeout in milliseconds | 60000 |
| MYSQL_CONNECTION_LIMIT | No | Maximum number of active pool connections | 10 |
| MYSQL_ENABLE_KEEP_ALIVE | No | Whether TCP keep-alive is enabled | true |
| MYSQL_WAIT_FOR_CONNECTIONS | No | Whether the pool waits when all connections are busy | true |
| MYSQL_ADMIN_TOKEN_TTL_SECONDS | No | Confirmation token lifetime in seconds | 120 |
| MYSQL_KEEP_ALIVE_INITIAL_DELAY | No | Initial TCP keep-alive delay in milliseconds | 0 |
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_list_databasesA | List databases in the current MySQL instance. |
| mysql_create_databaseC | Create a database. |
| mysql_describe_databaseC | Inspect a database definition. |
| mysql_drop_databaseA | Request database deletion and return a short-lived confirmation token. |
| mysql_list_usersA | List MySQL users. |
| mysql_create_userC | Create a MySQL user. |
| mysql_alter_user_passwordC | Change a MySQL user password. |
| mysql_grant_privilegesC | Grant privileges on a database to a user. |
| mysql_revoke_privilegesB | Revoke privileges on a database from a user. |
| mysql_show_grantsC | Show grants for a user. |
| mysql_drop_userC | Request user deletion and return a short-lived confirmation token. |
| mysql_confirm_taskC | Confirm and execute a previously issued destructive action token. |
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 12 tools
Each tool has a clearly distinct purpose—creating, listing, describing, deleting databases and users, managing privileges and passwords, and confirming destructive actions. No ambiguity.
All tools follow a consistent 'mysql_verb_noun' pattern (e.g., mysql_create_database, mysql_revoke_privileges) using snake_case throughout.
With 12 tools, the set is well-scoped for MySQL administration—covering database and user management, privileges, and password changes without being excessive.
Covers core lifecycle operations (create/read/delete) for databases and users, plus grant/revoke, password change, and a safety mechanism for drops. Missing update operations (e.g., rename database or user) but these are minor gaps.