mysql_show_grants
Retrieve all MySQL grants assigned to a specific user and host. View database privileges to manage user access.
Instructions
Show grants for a user.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| host | Yes | ||
| user | Yes |
Retrieve all MySQL grants assigned to a specific user and host. View database privileges to manage user access.
Show grants for a user.
| Name | Required | Description | Default |
|---|---|---|---|
| host | Yes | ||
| user | Yes |
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.
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