admin
Manage PostgreSQL database administration tasks including user permissions, database maintenance, and system operations through structured commands.
Instructions
Database administration: users, permissions, database info, maintenance operations
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| operation | Yes | Admin operation to perform | |
| options | No | Operation options | |
| password | No | Password (required for create_user) | |
| permissions | No | Permissions to grant/revoke | |
| tableName | No | Table name (for permission operations) | |
| username | No | Username (required for user operations) |
Input Schema (JSON Schema)
{
"properties": {
"operation": {
"description": "Admin operation to perform",
"enum": [
"database_info",
"list_users",
"create_user",
"drop_user",
"grant_permissions",
"revoke_permissions",
"vacuum",
"analyze",
"reindex_database"
],
"type": "string"
},
"options": {
"description": "Operation options",
"properties": {
"analyze": {
"default": false,
"type": "boolean"
},
"full": {
"default": false,
"type": "boolean"
},
"verbose": {
"default": false,
"type": "boolean"
}
},
"type": "object"
},
"password": {
"description": "Password (required for create_user)",
"type": "string"
},
"permissions": {
"description": "Permissions to grant/revoke",
"items": {
"type": "string"
},
"type": "array"
},
"tableName": {
"description": "Table name (for permission operations)",
"type": "string"
},
"username": {
"description": "Username (required for user operations)",
"type": "string"
}
},
"required": [
"operation"
],
"type": "object"
}