Skip to main content
Glama
hechtcarmel

Vertica MCP Server

by hechtcarmel

Inspect table structure

get_table_structure
Read-onlyIdempotent

Inspect an existing table's columns, nullability, constraints, and owner before composing SQL; does not read table data or inspect views.

Instructions

Inspect one existing table's columns, nullability, constraints and owner before composing SQL. Does not read table data. Fails if the table is absent or invisible; does not inspect views.

Input Schema

NameRequiredDescriptionDefault
tableNameYesExact existing table name, not a view. Pass the schema separately; do not add SQL quotes.
schemaNameNoExact schema name without SQL quotes. Omit for VERTICA_DEFAULT_SCHEMA, or public if unset.

Output Schema

NameRequiredDescriptionDefault

No arguments

Schema Changelog

Changes observed during successful MCP inspections.

  1. First observedv2.0.0

TDQS

A4.3/5.0
Behavior4/5

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

Annotations already declare readOnly, idempotent, non-destructive, so safety is covered. The description adds genuinely new behavioral facts: it fails on absent or invisible tables and it does not inspect views, which prevents wasted calls. It does not discuss visibility/permission implications further, keeping it just short of a 5.

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, front-loaded with the positive scope followed by the negative boundaries, and no filler. Every clause carries information the agent needs.

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?

An output schema exists so return values need no explanation, and annotations cover the safety profile. The remaining burden, scope boundaries and failure conditions, is fully addressed.

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 tableName and schemaName are already fully documented in the schema, including quote handling and default schema behavior. The description adds no parameter-level detail beyond what the schema provides, so the baseline 3 applies.

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 (inspect) and resource (one existing table) plus the exact returned fields: columns, nullability, constraints, owner. The scope is narrow and distinct from the listing siblings like list_tables and list_views.

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?

"before composing SQL" gives a clear triggering context, and the exclusions ("does not read table data", "does not inspect views", fails if absent) tell the agent when not to use it. It never names the sibling tools explicitly, so routing to list_views or execute_query still requires inference.

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