permissions

Instructions

Database permissions management: users, roles, grants, privileges

Input Schema

Name	Required	Description
`attributes`	No	User/role attributes
`database`	No	Database name for grants
`grantOption`	No	Grant with GRANT OPTION
`operation`	Yes	Permission operation to perform
`password`	No	Password for user creation/modification
`privileges`	No	Privileges to grant/revoke
`rolename`	No	Role name for role operations
`schema`	No	Schema name for grants
`table`	No	Table name for grants
`username`	No	Username for user operations

Input Schema (JSON Schema)

{
  "properties": {
    "attributes": {
      "description": "User/role attributes",
      "properties": {
        "bypassrls": {
          "description": "Bypass row level security",
          "type": "boolean"
        },
        "createdb": {
          "description": "Create database privilege",
          "type": "boolean"
        },
        "createrole": {
          "description": "Create role privilege",
          "type": "boolean"
        },
        "inherit": {
          "description": "Inherit privileges",
          "type": "boolean"
        },
        "login": {
          "description": "Login privilege",
          "type": "boolean"
        },
        "replication": {
          "description": "Replication privilege",
          "type": "boolean"
        },
        "superuser": {
          "description": "Superuser privilege",
          "type": "boolean"
        }
      },
      "type": "object"
    },
    "database": {
      "description": "Database name for grants",
      "type": "string"
    },
    "grantOption": {
      "default": false,
      "description": "Grant with GRANT OPTION",
      "type": "boolean"
    },
    "operation": {
      "description": "Permission operation to perform",
      "enum": [
        "list_users",
        "list_roles",
        "list_grants",
        "list_privileges",
        "create_user",
        "create_role",
        "drop_user",
        "drop_role",
        "grant_role",
        "revoke_role",
        "grant_privilege",
        "revoke_privilege",
        "alter_user",
        "alter_role",
        "check_permissions",
        "grant_all_privileges"
      ],
      "type": "string"
    },
    "password": {
      "description": "Password for user creation/modification",
      "type": "string"
    },
    "privileges": {
      "description": "Privileges to grant/revoke",
      "items": {
        "enum": [
          "SELECT",
          "INSERT",
          "UPDATE",
          "DELETE",
          "TRUNCATE",
          "REFERENCES",
          "TRIGGER",
          "CREATE",
          "CONNECT",
          "TEMPORARY",
          "EXECUTE",
          "USAGE",
          "ALL"
        ],
        "type": "string"
      },
      "type": "array"
    },
    "rolename": {
      "description": "Role name for role operations",
      "type": "string"
    },
    "schema": {
      "description": "Schema name for grants",
      "type": "string"
    },
    "table": {
      "description": "Table name for grants",
      "type": "string"
    },
    "username": {
      "description": "Username 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