get_table_structure
Retrieve table structure details including columns, data types, and constraints from Vertica databases to analyze schema information and verify database design.
Instructions
Get the structure of a table including columns, data types, and constraints.
Args:
ctx: FastMCP context for progress reporting and logging
table_name: Name of the table to inspect
schema: Schema name (default: public)
Returns:
Table structure information as a string
Input Schema
Name | Required | Description | Default |
---|---|---|---|
schema | No | public | |
table_name | Yes |
Input Schema (JSON Schema)
{
"properties": {
"schema": {
"default": "public",
"title": "Schema",
"type": "string"
},
"table_name": {
"title": "Table Name",
"type": "string"
}
},
"required": [
"table_name"
],
"title": "get_table_structureArguments",
"type": "object"
}