AI agents/LLMs: Fetch /llms.txt first to access the documentation index. Remove the trailing slash and append .md to any URL to access lighter, easier-to-parse Markdown pages instead of HTML (this page is accessible at https://docs.singlestore.com/cloud/reference/sql-reference/security-management-commands/show-groups-for-role.md).

SHOW GROUPS FOR ROLE role_specification

role_specification:
  role
  [
    ROLE 'role_name'
  ]

SHOW GROUPS FOR ROLE 'role_name_0';

+------------------------------+
| Groups with role role_name_0 |
+------------------------------+
| group_0                      |
+------------------------------+
1 row in set (0.00 sec)