Skip to main content
Glama
arthurxavier106

duckdb-analytics-mcp

describe_table

Read-onlyIdempotent

Inspect a table's columns, types, null rates, distinct counts, and sample data before writing queries.

Instructions

Describe one table: columns, types, null rates, distinct counts, examples.

Call this before writing a query against an unfamiliar table. It answers "what can I filter on, and what will be NULL" in a single round trip, which a raw information_schema dump does not.

Args: table (str): Table name, case-insensitive (e.g. 'orders').

Returns: str: Markdown containing: - header with row count and grain - a table of (column, type, null%, distinct, range, examples) - column definitions from the semantic layer - declared join keys - caveats that affect correctness

On failure: "Error: No table named 'x'. Available tables: ..."

Examples: - Use when: "What columns does orders have?" - Use when: a query failed with an unknown-column error. - Don't use when: you need the distribution of one column (use profile_column instead).

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
tableYesTable name, e.g. 'orders'. Case-insensitive.

Output Schema

TableJSON Schema
NameRequiredDescriptionDefault
resultYes
Behavior5/5

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

Beyond the readOnlyHint/idempotentHint annotations, the description discloses the exact return format (Markdown with row count, columns, semantic definitions, join keys, caveats) and error behavior, including the error message with available tables. This is rich behavioral context.

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 well-structured with clear sections (main description, Args, Returns, Examples). Every sentence serves a purpose, and it is front-loaded with the core functionality. Length is justified by the depth of useful guidance.

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 tool's simplicity (one parameter, read-only, with output schema), the description is complete: it explains what it does, when to use it, what it returns, and error handling. No critical information 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?

The schema description already covers the parameter ('Table name, e.g. 'orders'. Case-insensitive.'). The description's Args section repeats the same information without adding new meaning, so baseline 3 for high schema coverage is appropriate.

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 uses a specific verb and resource: 'Describe one table: columns, types, null rates, distinct counts, examples.' It clearly differentiates from siblings by noting when not to use it and recommending profile_column for single-column distribution.

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?

Explicit guidance is provided: 'Call this before writing a query against an unfamiliar table' with concrete use cases and a non-use case that names an alternative tool (profile_column). This clearly explains when to use this tool versus siblings.

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/arthurxavier106/duckdb-analytics-mcp'

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