Skip to main content
Glama

Nibomo SQL query (read-only)

sql_query
Read-onlyIdempotent

Read-only Nibomo SQL, not full PostgreSQL: SHOW TABLES, DESCRIBE, SHOW COLUMNS FROM and SELECT over workspace, cards, decks and review_events. A deck is a saved tag filter; cards have no deck_id. At most 100 rows per SELECT; paginate with ORDER BY, LIMIT, OFFSET; after data.rowsTruncated continue at OFFSET data.offset + data.rowCount. Run schema discovery in its own call. Grammar and examples: get_guide(sql_dialect).

Input Schema

NameRequiredDescriptionDefault
sqlYesOne or more semicolon-separated read statements.
workspaceIdNoWorkspace UUID from list_workspaces; omit for the selected default.

Output Schema

NameRequiredDescriptionDefault
dataYes

Schema Changelog

Changes observed during successful MCP inspections.

  1. Changed1 schema field changed
    • changedInput schema / properties / sql / description
      Previous value: -"One or more read statements in the published Nibomo SQL dialect (SHOW TABLES, DESCRIBE, SHOW COLUMNS, SELECT)."New value: +"One or more semicolon-separated read statements."
  2. First observed

TDQS

A4.3/5.0
Behavior5/5

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

Goes well beyond the readOnlyHint/idempotentHint annotations: it discloses the 100-row cap, the exact truncation signal (data.rowsTruncated) and resume protocol (OFFSET data.offset + data.rowCount), the dialect restrictions, and that schema discovery must be a separate call. It also pre-empts likely query mistakes by stating that a deck is a saved tag filter and cards have no deck_id.

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?

Front-loads the most decision-relevant fact ('Read-only Nibomo SQL') and then packs limits, pagination, and domain caveats into a few dense sentences with no filler. Every clause—including the deck/cards note—prevents a concrete failure mode.

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?

Even though an output schema exists, the description still clarifies the key response fields used for pagination (rowsTruncated, offset, rowCount), which is what an agent needs to loop correctly. Combined with dialect limits, table inventory, and the get_guide pointer, nothing needed to invoke it safely is missing.

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 both parameters are already documented, including the semicolon-separated statement semantics and the 'omit for the selected default' workspace behavior. The description adds dialect constraints on what the sql parameter may contain but no new per-parameter syntax or format detail, so this sits at the baseline.

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+resource: read-only SQL over named tables (workspace, cards, decks, review_events), with an explicit scope boundary ('not full PostgreSQL') and an enumerated statement whitelist. It does not name the sibling sql_execute, so the read/write split is left to be inferred from the read-only framing rather than stated outright.

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?

Gives actionable when-to-do-what: run schema discovery in its own call, consult get_guide(sql_dialect) for grammar and examples, and paginate with ORDER BY/LIMIT/OFFSET. It never explicitly says when to prefer sql_query over sibling sql_execute, which is the most likely routing ambiguity an agent would face.

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

Try in Browser

Glama MCP Gateway

Add one secure layer between your agents and this server.