Skip to main content
Glama
Arun-kc

schemabrain

describe_table

Read-onlyIdempotent

Retrieve column details, types, nullability, primary-key flags, descriptions, and outgoing foreign keys for a given qualified table name.

Instructions

Use this when the user names a specific table by qualified name (e.g. 'show me public.orders'). Returns columns with types, nullability, primary-key flags, LLM descriptions, and outgoing foreign keys. Use find_relevant_tables instead when the user describes the table semantically. Common compositions: chain to describe_column to drill into one column's join graph; chain to suggest_joins to find paths from this table to others.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
qualified_nameYesPostgres `schema.table` qualified name (e.g. `public.orders`). Call `find_relevant_tables` first if you don't know the schema.

Output Schema

TableJSON Schema
NameRequiredDescriptionDefault
statusYes
dataNo
errorNo
confidenceNo
provenanceNo
follow_up_hintsNo
degradation_reasonNo
charter_versionNo1.2
Behavior4/5

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

Annotations already declare readOnlyHint=true, destructiveHint=false, idempotentHint=true, openWorldHint=true, covering safety and idempotency. The description adds valuable behavioral context by listing exactly what is returned (columns with types, nullability, PK flags, LLM descriptions, outgoing FKs), leveraging the annotations effectively.

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 a single, well-structured paragraph that front-loads the purpose and then provides usage guidance. Every sentence adds value, with no redundancy.

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?

Given the presence of an output schema (not needed to explain return values), the description covers all necessary aspects: when to use, what it returns, and how to chain with other tools. It is complete for a single-parameter tool.

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

Parameters4/5

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

Schema description coverage is 100% with a clear parameter description. The tool description adds extra guidance by advising to call `find_relevant_tables` first if the schema is unknown, which goes beyond the schema alone.

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 specifies the tool's exact purpose: describing a table by qualified name, returning detailed schema information. It clearly distinguishes from sibling tools like `find_relevant_tables` (for semantic description) and `describe_column` (drilling into columns).

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

Usage Guidelines5/5

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

Explicitly states when to use this tool (user provides qualified name) and when to use `find_relevant_tables` instead (user describes table semantically). Provides common compositions like chaining to `describe_column` or `suggest_joins`, offering clear guidance.

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

Install Server

Other Tools

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/Arun-kc/schemabrain'

If you have feedback or need assistance with the MCP directory API, please join our Discord server