get_object_details
Retrieve detailed information about a database table, view, or sequence including columns, data types, constraints, indexes, size, and row count. Use this to understand table structure before writing queries.
Instructions
Get detailed info about a table/view/sequence: columns, data types, constraints, indexes, size, row count. Use this to understand table structure before writing queries. Optionally use server/database/targetSchema params for one-time execution on a different server.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| schema | Yes | Schema name containing the object | |
| objectName | Yes | Name of the table, view, or sequence | |
| objectType | No | Object type (auto-detected if not specified) | |
| server | No | One-time server override. Execute on this server without changing main connection. | |
| database | No | One-time database override. Uses this database for execution. | |
| targetSchema | No | One-time schema override. Sets search_path for this execution only. |