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 |
Capabilities
Features and capabilities supported by this server
| 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 | |
Latest Blog Posts
MCP directory API
We provide all the information about MCP servers via our MCP API.
curl -X GET 'https://glama.ai/api/mcp/v1/servers/chenkumi/easy-mysql-admin-mcp'
If you have feedback or need assistance with the MCP directory API, please join our Discord server