Skip to main content
Glama

data_sqlite_query

Run read-only SELECT/WITH SQL queries against SQLite files in a sandbox to inspect data while blocking writes and DDL.

Instructions

Run a READ-ONLY SQL query (SELECT/WITH) against a SQLite file in the sandbox. Writes and DDL are blocked.

Input Schema

NameRequiredDescriptionDefault
sqlYes
pathYes
limitNo

Output Schema

NameRequiredDescriptionDefault
resultYes

Schema Changelog

Changes observed during successful MCP inspections.

  1. First observedv0.1.0

TDQS

B3.3/5.0
Behavior3/5

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

With no annotations, the description carries the full disclosure burden and does well on the most important trait: it is explicitly read-only and states that writes and DDL are blocked. It says nothing about permissions, query timeouts, error behavior, or how results are returned, so the disclosure is partial.

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 short sentences with the read-only constraint front-loaded. Nothing is wasted and the critical restriction appears before the caveat.

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

Completeness3/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 values need not be explained, and the safety profile is covered. However, for a tool that takes an arbitrary filesystem path and an arbitrary SQL string, the absence of any path-resolution or limit guidance leaves real gaps for an agent composing a call.

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

Parameters2/5

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

Schema description coverage is 0% for three parameters, so the description must compensate and largely does not. 'SELECT/WITH' and 'SQLite file' give indirect meaning to sql and path, but path resolution (sandbox-relative? absolute?) and the purpose of limit (default 100) are entirely undocumented.

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?

States a specific verb ('Run') and resource ('SQL query against a SQLite file in the sandbox') and constrains it to SELECT/WITH. The SQLite-file resource implicitly separates it from data_read_csv and data_read_json, though no sibling is named explicitly.

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?

The description implies usage through the SELECT/WITH constraint and the note that writes and DDL are blocked, giving the agent a clear picture of the allowed operation class. It never says when to prefer this over data_read_csv or data_read_json, nor what to do when a query is rejected.

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