Table: keycloak_client
Obtaining client information from the Keycloak realm.
Examples
List all clients
select *from keycloak_client;
List all OIDC clients
select *from keycloak_clientwhere protocol = 'openid-connect';
List all Public clients
select *from keycloak_clientwhere public = true;
Get a specific client by friendly identifier
select *from keycloak_clientwhere client_id = 'my-client';
Schema for keycloak_client
Name | Type | Operators | Description |
---|---|---|---|
_ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. | |
admin_url | text | Admin/Callback URL of the client application | |
base_url | text | Base URL of the client application | |
client_id | text | Friendly name identifier for the client | |
consent_required | boolean | Indicates if consent is required for the client | |
default_client_scopes | jsonb | Client scopes automatically sent with all requests from the client | |
default_roles | jsonb | Roles automatically applied to users of the client | |
description | text | Long description applied to the client | |
enabled | boolean | Indicates if the client is enabled | |
id | text | Unique identifier for the client | |
name | text | Display name of the client | |
origin | text | ||
protocol | text | SSO Protocol used by the client (openid-connect, saml, etc) | |
public_client | boolean | Indicates if the client is a public client | |
web_origins | jsonb | Allowed web origins |