easy-mysql-admin-mcp
Provides tools for managing MySQL databases, including listing, creating, dropping databases; creating, altering, and dropping users; granting and revoking privileges; with safety tokens for destructive actions.
Click on "Install Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@easy-mysql-admin-mcplist databases"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
easy-mysql-admin-mcp
High-privilege MySQL admin MCP server for database and user/grant management.
Features
List, create, and inspect databases
List, create, and update users
Grant and revoke privileges at database scope
Protect destructive actions with short-lived confirmation tokens
Related MCP server: mysql-mcp-server
Available Tools
Tool | Description |
| List databases in the current MySQL instance |
| Create a database |
| Inspect database charset and collation settings |
| Request database deletion and return a confirmation token |
| List MySQL users |
| Create a MySQL user |
| Change a MySQL user password |
| Grant database privileges to a user |
| Revoke database privileges from a user |
| Show grants for a user |
| Request user deletion and return a confirmation token |
| Confirm and execute a destructive action token |
Safety
No raw SQL passthrough
No table, view, index, or trigger management
DROP DATABASEandDROP USERrequiremysql_confirm_taskConfirmation tokens are random, single-use, and expire quickly
Configuration
Use environment variables, matching the rest of the easy-*-mcp family.
Variable | Required | Default | Description |
| Yes | - | MySQL host name or IP address |
| No |
| MySQL port |
| Yes | - | MySQL user name |
| Yes | - | MySQL password |
| Yes | - | Default database/schema used for the admin connection |
| No |
| Maximum number of active pool connections |
| No |
| Maximum number of idle pool connections |
| No |
| Idle connection timeout in milliseconds |
| No |
| Maximum queued connection requests |
| No |
| Whether the pool waits when all connections are busy |
| No |
| Whether TCP keep-alive is enabled |
| No |
| Initial TCP keep-alive delay in milliseconds |
| No |
| Confirmation token lifetime in seconds |
Example
MYSQL_HOST=localhost
MYSQL_PORT=3306
MYSQL_USER=root
MYSQL_PASSWORD=your_password
MYSQL_DATABASE=mysql
MYSQL_ADMIN_TOKEN_TTL_SECONDS=120Claude Desktop Example
{
"mcpServers": {
"easy-mysql-admin-mcp": {
"command": "npx",
"args": ["-y", "easy-mysql-admin-mcp"],
"env": {
"MYSQL_HOST": "localhost",
"MYSQL_PORT": "3306",
"MYSQL_USER": "root",
"MYSQL_PASSWORD": "your_password",
"MYSQL_DATABASE": "mysql",
"MYSQL_ADMIN_TOKEN_TTL_SECONDS": "120"
}
}
}
}Codex config.toml Example
[mcp_servers.easy-mysql-admin-mcp]
args = ["-y", "easy-mysql-admin-mcp"]
command = "npx"
enabled = true
[mcp_servers.easy-mysql-admin-mcp.env]
MYSQL_HOST = "localhost"
MYSQL_PORT = "3306"
MYSQL_USER = "root"
MYSQL_PASSWORD = "your_password"
MYSQL_DATABASE = "mysql"
MYSQL_ADMIN_TOKEN_TTL_SECONDS = "120"OpenCode opencode.jsonc Example
{
"$schema": "https://opencode.ai/config.json",
"mcp": {
"easy-mysql-admin-mcp": {
"type": "local",
"command": ["npx", "-y", "easy-mysql-admin-mcp"],
"enabled": true,
"environment": {
"MYSQL_HOST": "localhost",
"MYSQL_PORT": "3306",
"MYSQL_USER": "root",
"MYSQL_PASSWORD": "your_password",
"MYSQL_DATABASE": "mysql",
"MYSQL_ADMIN_TOKEN_TTL_SECONDS": "120",
},
},
},
}Available Tools
12 toolsmysql_alter_user_passwordC
Change a MySQL user password.
| Name | Required | Description | Default |
|---|---|---|---|
| host | Yes | ||
| user | Yes | ||
| password | Yes |
TDQS
Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?
No annotations; description fails to disclose critical behavioral traits like required privileges, validation, or side effects of password change.
Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.
Is the description appropriately sized, front-loaded, and free of redundancy?
Single sentence with no fluff, but too minimal to be useful; could be slightly longer to include essential info.
Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.
Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?
Lacks any description of constraints, return values, or behavior; insufficient for a 3-parameter mutation tool with no output schema or annotations.
Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.
Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?
0% schema description coverage and description adds no extra meaning to parameters (user, host, password) beyond their names.
Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.
Does the description clearly state what the tool does and how it differs from similar tools?
Clearly states 'Change a MySQL user password' with a specific verb and resource. Distinct from sibling tools like create_user or drop_user.
Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.
Does the description explain when to use this tool, when not to, or what alternatives exist?
No guidance on when to use this tool versus alternatives, no prerequisites or context provided.
Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.
mysql_confirm_taskC
Confirm and execute a previously issued destructive action token.
| Name | Required | Description | Default |
|---|---|---|---|
| token | Yes |
TDQS
Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?
The description mentions 'destructive action' but does not disclose token validity, error handling, or authorization needs; no annotations are present to compensate.
Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.
Is the description appropriately sized, front-loaded, and free of redundancy?
A single sentence conveying the core action with no unnecessary words, though it could benefit from more context without becoming verbose.
Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.
Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?
The description omits essential context such as how to obtain the token, success/failure responses, and that it is a one-time confirmation step.
Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.
Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?
The schema defines a single 'token' parameter with no description, and the description adds no meaning beyond the schema.
Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.
Does the description clearly state what the tool does and how it differs from similar tools?
The description states the tool confirms and executes a destructive action token, clearly distinguishing it from sibling tools that directly manage MySQL entities.
Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.
Does the description explain when to use this tool, when not to, or what alternatives exist?
No guidance on when to use this tool versus alternatives, such as after receiving a token from a prior destructive operation.
Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.
mysql_create_databaseC
Create a database.
| Name | Required | Description | Default |
|---|---|---|---|
| database | Yes |
TDQS
Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?
With no annotations provided, the description must disclose behavioral traits. It does not mention any side effects (e.g., whether the database already exists), required permissions, or potential errors. For a creation tool, this is a significant gap.
Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.
Is the description appropriately sized, front-loaded, and free of redundancy?
The description is very short, which is concise but at the expense of useful detail. It could be expanded slightly without becoming verbose to include basic parameter guidance.
Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.
Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?
For a simple creation tool, the description lacks essential context: it does not explain what happens if the database already exists, whether the operation is idempotent, or what the output looks like. Given no output schema, these details are missing.
Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.
Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?
The single parameter 'database' has no description in the schema (0% coverage), and the tool description adds no meaning. The agent receives no information about naming conventions, length limits, or allowed characters.
Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.
Does the description clearly state what the tool does and how it differs from similar tools?
The description clearly states the tool's action ('Create a database') and resource, matching the name. However, it does not differentiate from sibling tools like 'mysql_drop_database' or 'mysql_list_databases', which could lead to confusion if the agent needs to choose among them.
Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.
Does the description explain when to use this tool, when not to, or what alternatives exist?
No guidance is provided on when to use this tool versus alternatives. There is no mention of prerequisites, conditions, or scenarios where using a different tool would be more appropriate.
Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.
mysql_create_userC
Create a MySQL user.
| Name | Required | Description | Default |
|---|---|---|---|
| host | Yes | ||
| user | Yes | ||
| password | Yes |
TDQS
Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?
No annotations are provided, so the description carries the full burden. It fails to disclose required privileges, behavior on duplicate users, or whether the user is created with authentication plugin defaults. For a mutation tool, more transparency is needed.
Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.
Is the description appropriately sized, front-loaded, and free of redundancy?
The description is a single front-loaded sentence, which is concise. However, it lacks necessary details to be truly useful. While not verbose, the minimalism undermines clarity.
Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.
Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?
Given the tool complexity (3 required params, no output schema, many sibling tools), the description is severely incomplete. It does not address common usage scenarios, error cases, or required permissions, leaving the agent underinformed.
Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.
Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?
Schema description coverage is 0%, and the description does not explain any parameter. Key information about 'host' (allowed connect hosts), 'password' (authentication method, requirements) is missing. The description adds no value beyond the schema field names.
Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.
Does the description clearly state what the tool does and how it differs from similar tools?
The description 'Create a MySQL user' clearly states the verb (create) and resource (user). It distinguishes from sibling tools like drop_user, alter_user_password, etc. However, it doesn't mention that it also sets a password, which is implicit from the required 'password' parameter.
Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.
Does the description explain when to use this tool, when not to, or what alternatives exist?
No guidance is provided on when to use this tool versus alternatives like alter_user_password or grant_privileges. There is no mention of prerequisites or exclusions, which is insufficient for selecting the right tool among many sibling tools.
Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.
mysql_describe_databaseC
Inspect a database definition.
| Name | Required | Description | Default |
|---|---|---|---|
| database | Yes |
TDQS
Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?
No annotations provided, so description must disclose behavior. It does not mention whether the tool is read-only, what happens if the database doesn't exist, or any side effects. Minimal info.
Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.
Is the description appropriately sized, front-loaded, and free of redundancy?
Extremely concise (one sentence) but under-specified. It could be longer without becoming verbose; e.g., it should include what 'definition' entails.
Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.
Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?
Given no output schema, no annotations, and sibling tools, the description is insufficient. It does not explain the return format, error behavior, or when to use this over other inspection tools.
Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.
Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?
Schema coverage is 0%, meaning description should clarify parameter meaning. It only reiterates the parameter name as 'database' without adding context (e.g., expected format or examples). The schema already defines it as a string, so no added value.
Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.
Does the description clearly state what the tool does and how it differs from similar tools?
Description states 'Inspect a database definition', which is a specific action on a database resource. It vaguely distinguishes from siblings like mysql_list_databases (list names) and mysql_create_database (create), but 'inspect' is ambiguous—could mean show schema options or tables.
Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.
Does the description explain when to use this tool, when not to, or what alternatives exist?
No guidance on when to use this tool vs. alternatives like mysql_list_databases or mysql_show_grants. The description lacks context about prerequisites or limitations.
Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.
mysql_drop_databaseA
Request database deletion and return a short-lived confirmation token.
| Name | Required | Description | Default |
|---|---|---|---|
| database | Yes |
TDQS
Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?
With no annotations, the description carries the full burden. It discloses that the tool is destructive ('deletion') and that it returns a short-lived token, implying the action is not immediate and requires confirmation. This is good transparency for a simple tool, though it could mention that the database is not actually dropped until confirmation.
Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.
Is the description appropriately sized, front-loaded, and free of redundancy?
A single sentence of 11 words that efficiently conveys the essential information. No superfluous language; every word earns its place.
Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.
Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?
For a simple tool with one parameter and no output schema, the description is complete enough. It covers the purpose, the two-step nature, and the token output. Could mention existence requirements or error conditions, but not lacking for minimal viability.
Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.
Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?
Schema description coverage is 0%, and the tool description does not describe the 'database' parameter. However, the parameter name is self-explanatory given the tool purpose. The description adds no additional semantic value beyond the name.
Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.
Does the description clearly state what the tool does and how it differs from similar tools?
The description clearly states the action ('Request database deletion') and the result ('return a short-lived confirmation token'). It effectively distinguishes from siblings by implying a two-step process where this tool initiates deletion and another tool (like mysql_confirm_task) uses the token to confirm.
Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.
Does the description explain when to use this tool, when not to, or what alternatives exist?
The description hints at a two-step process by mentioning the confirmation token but does not explicitly state when to use this vs. alternatives or that the token must be used with mysql_confirm_task. No direct guidance on prerequisites or exclusions.
Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.
mysql_drop_userC
Request user deletion and return a short-lived confirmation token.
| Name | Required | Description | Default |
|---|---|---|---|
| host | Yes | ||
| user | Yes |
TDQS
Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?
With no annotations, the description carries full burden. It discloses that deletion is not immediate and requires a token, which is a key behavioral trait beyond the tool name. However, it omits details like token expiration, error conditions, or side effects (e.g., privilege cleanup).
Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.
Is the description appropriately sized, front-loaded, and free of redundancy?
The single sentence is concise and front-loaded with the action, but it underspecifies critical details. It is not wasteful but trades completeness for brevity, earning a mid-range score.
Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.
Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?
Given the two-step deletion process (implied by 'request deletion' and 'confirmation token'), the description lacks context about how to proceed after receiving the token, what user/host refer to, and failure scenarios. It is incomplete for a mutation tool with no output schema or annotations.
Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.
Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?
Schema description coverage is 0%, and the description does not explain the 'user' and 'host' parameters. It adds no meaning beyond the schema's existence. Parameter names alone are insufficient without context.
Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.
Does the description clearly state what the tool does and how it differs from similar tools?
The description states the verb 'request user deletion' and mentions the notable output 'short-lived confirmation token', clearly distinguishing it from sibling tools like mysql_create_user or mysql_drop_database. It could explicitly mention 'MySQL' but the tool name implies it.
Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.
Does the description explain when to use this tool, when not to, or what alternatives exist?
No guidance on when to use this tool vs alternatives, such as prerequisites (e.g., admin privileges) or relationship to mysql_confirm_task for the token. The description does not clarify whether to use this before confirmation or after.
Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.
mysql_grant_privilegesC
Grant privileges on a database to a user.
| Name | Required | Description | Default |
|---|---|---|---|
| host | Yes | ||
| user | Yes | ||
| database | Yes | ||
| privileges | Yes | ||
| withGrantOption | No |
TDQS
Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?
With no annotations, the description should disclose behavioral traits. It only states the action, omitting side effects (e.g., overwriting existing privileges?), required permissions (GRANT privilege?), or whether it is reversible. A bare minimum.
Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.
Is the description appropriately sized, front-loaded, and free of redundancy?
Single sentence is concise, but it sacrifices completeness. Not every word earns its place because it omits essential details.
Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.
Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?
Given 5 parameters, 4 required, no output schema, and no annotations, the description is woefully insufficient. Missing return value, error handling, and parameter context make the tool hard to use correctly.
Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.
Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?
Schema description coverage is 0%, so the description must compensate. It adds no explanation for parameters like 'privileges' (valid values?), 'host' (format?), or 'withGrantOption' (effect). Users are left guessing.
Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.
Does the description clearly state what the tool does and how it differs from similar tools?
The description clearly states the action (grant privileges) and the target objects (database, user). However, it does not distinguish from sibling tools like mysql_revoke_privileges or mysql_show_grants, missing an opportunity to clarify scope.
Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.
Does the description explain when to use this tool, when not to, or what alternatives exist?
No guidance provided on when to use this tool versus alternatives (e.g., revoke privileges, show grants). There is no mention of prerequisites (e.g., user/database must exist) or context for appropriate use.
Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.
mysql_list_databasesA
List databases in the current MySQL instance.
| Name | Required | Description | Default |
|---|---|---|---|
No parameters | |||
TDQS
Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?
With no annotations provided, the description carries the full burden of behavioral disclosure. It merely states 'list databases' with no indication of read-only nature, potential rate limits, or any side effects. This is insufficient for a tool with no annotation safety net.
Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.
Is the description appropriately sized, front-loaded, and free of redundancy?
The description is a single, compact sentence of eight words that conveys the essential purpose with no redundant information.
Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.
Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?
Given no parameters and no output schema, the description is minimal but might be adequate for a simple listing tool. However, it lacks any indication of output format, ordering, or limits, leaving the agent with uncertainty about the return value.
Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.
Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?
The input schema has zero parameters, so the description adds no parameter information. With schema coverage at 100% (trivially), the baseline is 4. The description does not need to add parameter details, and it does not.
Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.
Does the description clearly state what the tool does and how it differs from similar tools?
The description clearly states the verb 'list' and resource 'databases' in the current MySQL instance. It distinguishes itself from sibling tools like mysql_create_database, mysql_drop_database, and user/privilege management tools.
Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.
Does the description explain when to use this tool, when not to, or what alternatives exist?
The description implies usage when needing to see all databases, but provides no explicit guidance on when to use this tool versus alternatives, such as mysql_describe_database for details or mysql_create_database for creation.
Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.
mysql_list_usersA
List MySQL users.
| Name | Required | Description | Default |
|---|---|---|---|
No parameters | |||
TDQS
Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?
No annotations are provided, and the description does not disclose behavioral traits such as being read-only, requiring privileges, or listing only current user's databases. Minimal info beyond the obvious.
Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.
Is the description appropriately sized, front-loaded, and free of redundancy?
Extremely concise, front-loaded, no unnecessary words. Every word earns its place.
Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.
Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?
Adequate for a simple zero-parameter list tool. No output schema, but description sufficiently covers the action. Could mention return format but not required given simplicity.
Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.
Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?
Zero parameters, schema coverage 100%. Description adds slight meaning (specifically 'MySQL users') beyond empty schema, but baseline for 0 params is 4.
Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.
Does the description clearly state what the tool does and how it differs from similar tools?
The description 'List MySQL users' clearly states the verb (list) and resource (MySQL users), distinguishing it from sibling tools that create, drop, or modify users.
Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.
Does the description explain when to use this tool, when not to, or what alternatives exist?
No guidance on when to use this tool versus alternatives like mysql_show_grants or mysql_list_databases. Implicit purpose exists but no explicit when or when-not.
Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.
mysql_revoke_privilegesB
Revoke privileges on a database from a user.
| Name | Required | Description | Default |
|---|---|---|---|
| host | Yes | ||
| user | Yes | ||
| database | Yes | ||
| privileges | Yes |
TDQS
Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?
No annotations are provided, and the description fails to disclose behavioral traits such as required permissions, error handling, or whether the operation is reversible. As a mutation tool, more transparency is needed.
Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.
Is the description appropriately sized, front-loaded, and free of redundancy?
The description is a single sentence that is extremely concise and front-loaded, containing no unnecessary words.
Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.
Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?
For a sensitive operation like revoking privileges, the description lacks important context about prerequisites, side effects (e.g., immediate effect), and what happens if the grant does not exist. No output schema is provided.
Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.
Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?
The description adds minimal meaning beyond the schema by hinting at 'database' and 'user', but does not clarify 'host' or 'privileges'. With 0% schema coverage, the description should compensate more.
Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.
Does the description clearly state what the tool does and how it differs from similar tools?
The description uses a specific verb ('Revoke') and resource ('privileges on a database from a user'), clearly distinguishing it from its sibling tool 'mysql_grant_privileges'.
Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.
Does the description explain when to use this tool, when not to, or what alternatives exist?
No guidance is provided on when to use this tool versus alternatives (e.g., mysql_grant_privileges, mysql_show_grants). The context for use is only implied but not explicitly stated.
Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.
mysql_show_grantsC
Show grants for a user.
| Name | Required | Description | Default |
|---|---|---|---|
| host | Yes | ||
| user | Yes |
TDQS
Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?
No annotations are present, and the description does not disclose that this is a read-only, non-destructive operation. For a query tool, behavioral traits like safety are left implicit.
Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.
Is the description appropriately sized, front-loaded, and free of redundancy?
The description is extremely concise (4 words) and front-loaded, but it lacks important details that would justify its brevity. It is not overly verbose, but it is under-specified.
Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.
Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?
Given no output schema and no annotations, the description should cover what the tool returns (grants) and clarify parameter roles. It fails to do so, leaving the agent with insufficient context for correct usage.
Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.
Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?
Schema description coverage is 0%, and the description adds no meaning to the parameters 'user' and 'host'. It fails to explain their purpose or format beyond the schema's basic type constraints.
Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.
Does the description clearly state what the tool does and how it differs from similar tools?
The description 'Show grants for a user' uses a specific verb ('Show') and resource ('grants'), clearly distinguishing it from sibling tools that alter or create users/databases.
Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.
Does the description explain when to use this tool, when not to, or what alternatives exist?
No guidance is provided on when to use this tool versus alternatives like mysql_grant_privileges or mysql_revoke_privileges. The description only states what it does, without context for selection.
Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.
TDQS
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.
Maintenance
Resources
Unclaimed servers have limited discoverability.
Looking for Admin?
If you are the server author, to access and configure the admin panel.
Related MCP Connectors
MCP server for Product Management
Read-only MCP server for turva.dev, an agent-readiness audit and advisory service.
Related MCP Servers
- AlicenseNot gradedqualityCmaintenanceRead-only MySQL MCP server for safe schema inspection and SELECT-style queries.33MIT
- AlicenseNot gradedqualityDmaintenanceA production-ready MCP server for MySQL database operations, providing secure HTTP endpoints for read-only queries, performance analysis, and server monitoring.12116MIT
- FlicenseNot gradedqualityCmaintenanceA generic MCP server for MySQL operations, enabling listing databases/tables, describing schemas, running read-only SQL, and optionally executing write SQL with logging.1
- AlicenseAqualityCmaintenanceA read-only MySQL MCP server supporting stdio, SSE, and Streamable HTTP transports, enabling secure querying and schema inspection of MySQL databases from MCP clients.3MIT
Latest Blog Posts
- Who's Calling? MCP Hosts Are an Identity Blind Spot (And the Spec Knows It)By Om-Shree-0709 on .mcpAgent IdentityOAuth 2.1
- Your AI Chatbot Just Exposed Your CEO's Salary to an InternBy Om-Shree-0709 on .Agent IdentityMCP SecurityOAuth Delegation
- Why MCP Servers Need Execution Sandboxing (And Why Your Current Stack Isn't Enough)By Om-Shree-0709 on .Agentic AiPrompt InjectionWebAssembly
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