Skip to main content
Glama
igorolv

jdbc-mcp-server

listQueries

listQueries
Read-onlyIdempotent

Browse or search stored usage-catalog queries by source, business metadata, parse status, or free text, returning summaries newest-ingest first.

Instructions

Browse or search stored usage-catalog queries by source, business metadata, parse status or free text. Returns summaries newest-ingest first; use getQuery for the complete SQL and evidence of one selected record.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
tagNoExact tag.
limitNoRows to return (default 100, max 1000).
offsetNoPaging offset (default 0).
connectionYesDatabase to run against. Call listConnections for valid names; do not guess.
searchTextNoCase-insensitive full-text search over SQL, labels, domains and source paths.
sourceKindNoSource kind, e.g. bi-publisher-report or dao.
sourcePathNoSource path LIKE pattern ('%'/'_').
parseStatusNoParse status: parsed or failed.
businessDomainNoExact business domain.

Output Schema

TableJSON Schema
NameRequiredDescriptionDefault
countYesNumber of query entries returned in this page.
limitYesRow limit applied to the query or page size requested by the caller.
offsetYesZero-based result offset for pagination, or true when SQL contains OFFSET depending on context.
queriesNoUsage-catalog query entries returned by the current filter or disabled-catalog response.

Schema Changelog

Changes observed during successful MCP inspections.

  1. First observedv0.1.0

TDQS

A4.3/5.0
Behavior4/5

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

Annotations already declare readOnlyHint=true, idempotentHint=true, and destructiveHint=false, so the safety profile is covered. The description adds valuable behavioral context beyond annotations by specifying that results are 'summaries newest-ingest first' and that the complete SQL and evidence require a follow-up getQuery call. This informs ordering and return granularity without contradicting the annotations.

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?

The description is two sentences with no filler. The first sentence states the tool's purpose and filter dimensions; the second explains result ordering and directs the agent to getQuery for deeper detail. This is efficient, front-loaded, and every clause adds useful information.

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?

For a read-only browsing/search tool, the description is complete: it explains the resource, the search dimensions, the result type ('summaries'), the sort order ('newest-ingest first'), and the relationship to getQuery for full detail. An output schema exists, so return-value details are not required in the description. Combined with the schema's thorough parameter documentation and the non-destructive annotations, an agent has everything needed to call this tool correctly.

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

Parameters3/5

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

Schema description coverage is 100%, so the baseline is 3 because the schema already documents all nine parameters. The description does add a light conceptual grouping ('source, business metadata, parse status or free text'), but this mostly mirrors parameter names like sourceKind, sourcePath, businessDomain, parseStatus, and searchText. It does not introduce new semantic detail such as value formats, LIKE patterns, or interaction between filters beyond the schema.

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?

The description states a specific verb ('Browse or search') on a specific resource ('stored usage-catalog queries') and lists the filtering dimensions: source, business metadata, parse status, and free text. It also distinguishes itself from getQuery by noting that listQueries returns summaries while getQuery provides complete SQL and evidence. This makes the tool's purpose immediately clear and separable from its siblings.

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?

The description gives clear context for when to use the tool versus getQuery: use listQueries for browsing/searching summaries, then getQuery for full SQL and evidence of a selected record. It does not explicitly mention exclusions against searchObjects or other sibling search-like tools, but the emphasis on 'usage-catalog queries' implies the intended scope. The guidance is clear enough for an agent to make a sound initial selection.

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