schemas
Manage PostgreSQL database schemas by listing, creating, dropping schemas, and handling permissions to organize database structure effectively.
Instructions
Schema management: list, create, drop schemas and manage schema permissions
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| action | Yes | Action: list (all schemas), create (new schema), drop (remove schema), permissions (schema permissions) | |
| options | No | Action-specific options | |
| owner | No | Schema owner (for create action) | |
| schemaName | No | Schema name (required for create, drop, permissions) |
Input Schema (JSON Schema)
{
"properties": {
"action": {
"description": "Action: list (all schemas), create (new schema), drop (remove schema), permissions (schema permissions)",
"enum": [
"list",
"create",
"drop",
"permissions"
],
"type": "string"
},
"options": {
"description": "Action-specific options",
"properties": {
"cascade": {
"default": false,
"type": "boolean"
},
"ifExists": {
"default": true,
"type": "boolean"
},
"ifNotExists": {
"default": false,
"type": "boolean"
}
},
"type": "object"
},
"owner": {
"description": "Schema owner (for create action)",
"type": "string"
},
"schemaName": {
"description": "Schema name (required for create, drop, permissions)",
"type": "string"
}
},
"required": [
"action"
],
"type": "object"
}