Skip to main content
Glama
ServiceNow_Developer_Panel

ServiceNow_Developer_Panel

query_cache

Read-only

Query cached ServiceNow table data with read-only SQLite to filter, join, and inspect records; returns up to 2,000 rows and flags truncated results.

Instructions

Run read-only SQLite against a cached response. Each ServiceNow table is a SQLite table with TEXT columns. Returns at most 2000 rows; truncated is true when more matched.

Input Schema

NameRequiredDescriptionDefault
sqlYesSQLite statements, separated by semicolons. Every cached ServiceNow table is a SQLite table with the same name and TEXT columns. Reference fields hold the sys_id of the referenced record: join on it, or request dot-walked fields such as group.name. Double-quote column names that contain dots or are SQL keywords, for example "caller_id.name", "group", "order" and "when". Only the last statement that returns rows is returned. The cache is read-only, TEMP tables are allowed.
cache_nameYesThe cache_name returned by a request tool or by list_cached_responses.

Output Schema

NameRequiredDescriptionDefault
rowsYes
columnsYes
row_countYes
truncatedYes
cache_nameYes

Schema Changelog

Changes observed during successful MCP inspections.

  1. First observedv0.1.0

TDQS

A3.8/5.0
Behavior4/5

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

Annotations already declare readOnlyHint and openWorldHint=false, but the description adds real operational context beyond them: a hard 2000-row cap and the truncated flag that signals when more rows matched. That truncation behavior is the single most important thing an agent needs to interpret results correctly, and it is disclosed.

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?

Three short sentences, front-loaded with the action and immediately followed by the data model the agent must reason about. Every sentence earns its place and nothing is padded.

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

Completeness4/5

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

An output schema exists, so return-shape explanation is unnecessary, and the description covers the one result-side surprise (truncation). It is nearly complete for a two-parameter query tool; the only missing piece is guidance on cache lifecycle relative to the request tools.

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 coverage is 100%, and the schema's sql description is itself detailed about semicolon separation, dot-walking, quoting, and the last-returned-statement rule. The tool description only restates that tables are SQLite with TEXT columns, adding no syntax or edge-case meaning not already in the schema, so baseline 3 applies.

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

Purpose4/5

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

The description states a specific verb and resource: 'Run read-only SQLite against a cached response,' which tells an agent exactly what the tool does. It does not, however, contrast itself with siblings like describe_table, request_table, or export_cache, so differentiation is left to inference.

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

Usage Guidelines3/5

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

Usage is implied rather than stated: an agent must already hold a cache_name to have any reason to call this. There is no explicit when-to-use versus describe_table or export_cache, and no stated prerequisite that a cache must first be populated by a request tool.

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