List roles
list_rolesList database roles and their attributes, excluding system roles unless requested. Returns name, permissions, login, replication, and membership details.
Instructions
List the database roles and their attributes, excluding PostgreSQL's own roles unless include_system is true. Returns a list of objects with name, superuser, create_role, create_db, can_login, replication, bypass_rls, connection_limit, member_of.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| database | No | Optional: target a configured secondary (read-only) database by name; omit for the primary. Call list_databases to see the configured ids. | |
| include_system | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |