redshift_describe_table
Retrieve column definitions and structure details for Amazon Redshift database tables to understand data schema and relationships.
Instructions
Get the column definitions for a table.
Args:
table_name: Name of the table
schema: Schema name (default: "public")
Returns:
JSON description of columnsInput Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table_name | Yes | ||
| schema | No | public |
Output Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |
Implementation Reference
- redshift_mcp_server.py:96-115 (handler)The handler function for the 'redshift_describe_table' tool. It is registered via the @mcp.tool() decorator and executes a SQL query against information_schema.columns to describe the table structure, returning JSON via redshift_query.
@mcp.tool() def redshift_describe_table(table_name: str, schema: str = "public") -> str: """ Get the column definitions for a table. Args: table_name: Name of the table schema: Schema name (default: "public") Returns: JSON description of columns """ sql = f""" SELECT column_name, data_type, is_nullable, column_default FROM information_schema.columns WHERE table_schema = '{schema}' AND table_name = '{table_name}' ORDER BY ordinal_position """ return redshift_query(sql)