admin

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
`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"
}

Postgres MCP Server

Instructions

Input Schema

Input Schema (JSON Schema)

Other Tools from Postgres MCP Server

Related Tools

MCP directory API