Skip to main content
Glama
Strom-Capital

mcp-server-db2i

List Schemas

list_schemas
Read-onlyIdempotent

List every schema (library) in an IBM Db2 for i database and optionally filter names using * as a wildcard.

Instructions

List all schemas (libraries) in the IBM Db2i database. Optionally filter by name pattern using * as wildcard.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
filterNoFilter pattern for schema names. Use * as wildcard. Example: "QSYS*" matches schemas starting with QSYS

Output Schema

TableJSON Schema
NameRequiredDescriptionDefault
dataNo
countNo
errorNo
successYes

Schema Changelog

Changes observed during successful MCP inspections.

  1. First observedv3.0.0

TDQS

A3.9/5.0
Behavior3/5

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

Annotations already declare readOnlyHint=true, idempotentHint=true, destructiveHint=false, and openWorldHint=false, so the safety and repeatability profile is fully covered by structured data. The description adds the (libraries) terminology mapping, which is useful context, but nothing about result scope or limits beyond what annotations provide. With annotations carrying the behavioral burden, a 3 is appropriate.

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 sentences, zero waste, and the core action is front-loaded before the optional filter detail. Every clause earns its place.

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 zero-required-parameter listing tool with rich annotations and an output schema, the description covers purpose, scope, and the only parameter's behavior. Nothing an agent needs to call it correctly 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% and the filter parameter is fully documented in the schema, including the wildcard syntax and an example. The description restates the wildcard behavior in one clause without adding format or edge-case detail beyond the schema. Baseline 3 is correct when the schema does the heavy lifting.

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?

States a specific verb (List) and resource (schemas/libraries) in a named database, and the parenthetical 'libraries' disambiguates the Db2 for i terminology. An agent can distinguish this from list_tables or list_views without opening any schema.

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 optional filter usage is stated ('Optionally filter by name pattern'), which implies when the parameter applies, but there is no explicit when-to-use versus siblings or when-not-to-use guidance. For an inventory-listing tool the usage context is largely self-evident, so this is adequate but not rich.

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