What is configuring-sso-and-scim?

A guide for connecting CockroachDB to an organization’s identity system. Single sign-on, or SSO, lets users sign in through that system, while SCIM automatically creates and updates user accounts.

Use it to configure sign-in for the Cloud Console, DB Console, or SQL connections, connect LDAP or Active Directory for self-hosted deployments, and automate account provisioning with SCIM.

It replaces separate database logins and manual account administration with centralized access control and user provisioning.

configuring-sso-and-scim — Skill by cockroachlabs/cockroachdb-skills

Install

Getting it into your agent

One page per mod, every tool's command on it. A separate URL per tool would split the same page into five that compete with each other.

Any agent

npx skills add cockroachlabs/cockroachdb-skills --skill configuring-sso-and-scim

Clone the repo

git clone --depth 1 https://github.com/cockroachlabs/cockroachdb-skills

Made for: Claude Code, Codex.

Wrote this? Show the measurements

A badge with what this costs and how it scanned, read live from this page, so it follows the numbers instead of freezing them. Markdown for a README, HTML for a documentation site or a project page.

README.md

[![agentmods](https://agentmods.dev/badge/skills/cockroachlabs/cockroachdb-skills/configuring-sso-and-scim/github.svg)](https://agentmods.dev/skills/cockroachlabs/cockroachdb-skills/configuring-sso-and-scim)

Your own site

<a href="https://agentmods.dev/skills/cockroachlabs/cockroachdb-skills/configuring-sso-and-scim"><img src="https://agentmods.dev/badge/skills/cockroachlabs/cockroachdb-skills/configuring-sso-and-scim/github.svg" alt="Measured on agentmods" height="20"></a>

Or the 80×15 button, for a site that already has a row of RSS and ATOM ones. Only the verdict fits; the numbers stay here.

Your own site · 80×15

<a href="https://agentmods.dev/skills/cockroachlabs/cockroachdb-skills/configuring-sso-and-scim"><img src="https://agentmods.dev/badge/skills/cockroachlabs/cockroachdb-skills/configuring-sso-and-scim.svg" alt="Reviewed on agentmods" width="80" height="20"></a>

Per session 91 Skills are progressive disclosure: only the name and description are preloaded; the body loads when the skill is used.

When invoked 5,917 The whole file, excluding the scripts and references it only reads on demand.

Security scan A 0 findings. A grade says what 26 rules found in the file — not that it is safe.

Origin original No closer match found in the catalogue.

Token cost

What it costs to keep this loaded

Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.

Model	Per session	Once invoked
Fable 5.1	$0.00091	$0.05917
Opus 5.5	$0.00036	$0.02367
Sonnet 5.5	$0.00018	$0.01183
Haiku 4.5	$0.00009	$0.00592

Measured 2mo ago against content hash d343f2a9e8a2, method: parsed. Prices are Anthropic first-party input rates as of 2026-10-07, from the pricing page.

Security

Grade A, and why

configuring-sso-and-scim scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured 2mo ago.

A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.

Nothing flagged

None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.

Origin

Copies of this mod

2 near-identical copies found in the catalogue:

configuring-sso-and-scim — 100% identical, 0 lines differ
configuring-sso-and-scim — 100% identical, 0 lines differ

skills/cockroachdb-security-and-governance/configuring-sso-and-scim/SKILL.md · 562 lines

How it starts

The opening of the file, as written. The whole thing — 562 lines — stays where its author put it; the contents beside it link to each section on GitHub.

Configuring SSO and SCIM

Configures Single Sign-On (SSO) and SCIM 2.0 provisioning for CockroachDB across four distinct layers:

Cloud Console SSO — SAML or OIDC for the CockroachDB Cloud web console
DB Console SSO — OIDC for the DB Console web UI (Advanced/Enterprise only)
SQL/Cluster SSO — JWT-based or LDAP/AD authentication for SQL client connections
SCIM 2.0 — Automated user provisioning on the Cloud Console

Prerequisites

Console SSO/SCIM: Organization Admin + ccloud CLI
DB Console/SQL SSO: Cluster admin role + Advanced or Enterprise plan (DB Console SSO not on Standard/Basic)
LDAP/AD: Self-hosted only (not available on CockroachDB Cloud)
SCIM 2.0: Enterprise plan required

Configuration Decisions

Before proceeding, determine which layers the user needs. Ask which of the following apply, then follow only the relevant Parts below.

Decision 1 — Cloud Console SSO:

SAML: Best for enterprise IdPs with existing SAML infrastructure (Okta, Azure AD, PingOne)
OIDC: Simpler setup, supports Google Workspace and modern IdPs natively
Skip: Not needed

Decision 2 — DB Console SSO:

Enable (OIDC): SSO for the DB Console web UI. Requires Advanced or Enterprise plan — not available on Standard or Basic
Skip: Not needed or plan does not support it

Decision 3 — SQL/Cluster SSO method:

JWT-based: Cloud-native approach using JWT tokens for SQL client connections. Works on both CockroachDB Cloud and self-hosted clusters
LDAP/AD: Direct directory authentication against Active Directory or OpenLDAP. Self-hosted only (not available on CockroachDB Cloud)
Skip: Not needed

Decision 4 — SCIM 2.0 provisioning:

Enable: Automates user lifecycle (create/update/deactivate) between IdP and Cloud Console. Requires Enterprise plan
Skip: Manage Cloud Console users manually

Steps

Part 1: Cloud Console SSO

Cloud Console SSO enables SAML or OIDC authentication for the CockroachDB Cloud web console.

Read the full file on GitHub · 562 lines

Files

What ships with it

1 file beside SKILL.md in the same directory: the scripts, references and assets a skill reads on demand. Not counted in the per-session cost; read them before you install if any of them is executable.

references/configuration-steps.md 13 KB

Changes

What this file has done since we first saw it

Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.

2mo ago First seen · 562 lines · 91 tokens per session scan A d343f2a9e8a2

Subscribe to this mod's changes

configuring-sso-and-scim is a skill published in the GitHub repository cockroachlabs/cockroachdb-skills (23 stars, last pushed 3mo ago), licensed Apache-2.0. It adds 91 tokens to every session and 5,917 once invoked, about $0.0004 per session on Opus 5.5. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-08-30.

Backend and APIs Security

configuring-sso-and-scim next to 6 skills from other repositories
Mod	Type	Stars	Last push	Licence	Scan	Tokens	Works with
configuring-sso-and-scimcockroachlabs/cockroachdb-skills	Skill	23	3mo ago	Apache-2.0	A	91	Claude Code, Codex
mem0-oss-to-platformmem0ai/mem0	Skill	68k	2d ago	Apache-2.0	A	217	Claude Code, Codex
azure-mgmt-botservice-dotnetmicrosoft/skills	Skill	3.2k	yesterday	MIT	A	78	Claude Code
fastapi-router-pymicrosoft/skills	Skill	3.2k	yesterday	MIT	A	46	Claude Code
dev-runtimelangwatch/langwatch	Skill	5.0k	yesterday	Apache-2.0	A	172	Claude Code
api-designericrisco/rsc-harness	Skill	503	2d ago	MIT	A	105	Claude Code, Codex
migrate-segw-to-raparc-mcp/arc-1	Skill	252	yesterday	MIT	A	106	Claude Code