pg_manage_comments
Manage PostgreSQL database object comments - retrieve, add, update, or delete descriptive text on tables, columns, functions, and other database objects to document schema structure.
Instructions
Manage PostgreSQL object comments - get, set, remove comments on tables, columns, functions, and other database objects. Examples: operation="get" with objectType="table", objectName="users", operation="set" with comment text, operation="bulk_get" for discovery
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| connectionString | No | PostgreSQL connection string (optional) | |
| operation | Yes | Operation: get (retrieve comments), set (add/update comment), remove (delete comment), bulk_get (discovery mode) | |
| objectType | No | Type of database object (required for get/set/remove) | |
| objectName | No | Name of the object (required for get/set/remove) | |
| schema | No | Schema name (defaults to public, required for most object types) | |
| columnName | No | Column name (required when objectType is "column") | |
| comment | No | Comment text (required for set operation) | |
| includeSystemObjects | No | Include system objects in bulk_get (defaults to false) | |
| filterObjectType | No | Filter by object type in bulk_get operation |