get_object_details
Retrieve detailed metadata for database objects like tables, views, sequences, or extensions in Postgres MCP by specifying schema and object names for accurate insights.
Instructions
Show detailed information about a database object
Input Schema
Name | Required | Description | Default |
---|---|---|---|
object_name | Yes | Object name | |
object_type | No | Object type: 'table', 'view', 'sequence', or 'extension' | table |
schema_name | Yes | Schema name |
Input Schema (JSON Schema)
{
"properties": {
"object_name": {
"description": "Object name",
"title": "Object Name",
"type": "string"
},
"object_type": {
"default": "table",
"description": "Object type: 'table', 'view', 'sequence', or 'extension'",
"title": "Object Type",
"type": "string"
},
"schema_name": {
"description": "Schema name",
"title": "Schema Name",
"type": "string"
}
},
"required": [
"schema_name",
"object_name"
],
"title": "get_object_detailsArguments",
"type": "object"
}