steampipe plugin install theapsgroup/keycloak

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_client
where
protocol = 'openid-connect';

List all Public clients

select
*
from
keycloak_client
where
public = true;

Get a specific client by friendly identifier

select
*
from
keycloak_client
where
client_id = 'my-client';

Schema for keycloak_client

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
admin_urltextAdmin/Callback URL of the client application
base_urltextBase URL of the client application
client_idtextFriendly name identifier for the client
consent_requiredbooleanIndicates if consent is required for the client
default_client_scopesjsonbClient scopes automatically sent with all requests from the client
default_rolesjsonbRoles automatically applied to users of the client
descriptiontextLong description applied to the client
enabledbooleanIndicates if the client is enabled
idtextUnique identifier for the client
nametextDisplay name of the client
origintext
protocoltextSSO Protocol used by the client (openid-connect, saml, etc)
public_clientbooleanIndicates if the client is a public client
web_originsjsonbAllowed web origins