get_table_schema_info
Retrieve column definitions, keys, indexes, constraints, and table metadata for a specific PostgreSQL table or all tables to analyze database structure and relationships.
Instructions
[Tool Purpose]: Retrieve detailed schema information for specific table or all tables in a database
[Exact Functionality]:
Retrieve detailed column information including data types, constraints, defaults
Display primary keys, foreign keys, indexes, and other table constraints
Show table-level metadata such as size, row count estimates
[Required Use Cases]:
When user requests "table schema", "column info", "table structure", etc.
When detailed table design information is needed for development
When analyzing database structure and relationships
[Strictly Prohibited Use Cases]:
Requests for actual data inside tables
Requests for table structure changes or DDL operations
Requests for performance statistics (use other tools for that)
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"database_name": "<database_name>"
},
"name": "get_table_schema_info"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table_name | No | Specific table name to analyze (if None, shows all tables) | |
| schema_name | No | Schema name to search in (default: "public") | public |
| database_name | Yes | Database name to query (REQUIRED - specify which database to analyze) |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |