Skip to main content
Glama
ugurcl

dbridge-mcp

Explain a query

explain_query

Check SQL query cost by retrieving the query plan and estimated cost without executing. Ensures queries are cheap before running.

Instructions

Returns the query plan and estimated cost without running the query. Use it to check a query is cheap before running it.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
sqlYesA single read-only SELECT or WITH statement to analyze
Behavior5/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

Discloses that the query is not executed and only analyzed, making it safe. Also specifies that input must be read-only SELECT or WITH, covering security constraints.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

Two concise sentences; first tells what it does, second tells when to use it. No unnecessary words.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness5/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Covers all essential aspects: output (query plan and cost), parameter constraint, and usage context. With no output schema, the description adequately fills the gap.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters5/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Adds value beyond schema by requiring the SQL to be a single read-only SELECT or WITH statement, which is not in the schema description.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

Clearly states it returns the query plan and estimated cost, differentiating from run_query which executes. The verb 'Returns' and resource 'query plan' are specific.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines4/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

Explicitly recommends using it to check if a query is cheap before running it. Lacks explicit when-not-to-use, but the contrast with run_query is implied.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

Install Server

Other Tools

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/ugurcl/dbridge-mcp'

If you have feedback or need assistance with the MCP directory API, please join our Discord server