auditing-cis-benchmark

Audits self-hosted CockroachDB clusters against CIS Benchmark Level 1 controls.

2|1|Updated Mar 11, 2026
One-click install
npx skills add https://github.com/cockroachdb/cursor-plugin --skill auditing-cis-benchmark-cockroachdb
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: auditing-cis-benchmark
Source: https://github.com/cockroachdb/cursor-plugin/tree/main/skills/cockroachdb-security-and-governance/auditing-cis-benchmark
Command: npx skills add https://github.com/cockroachdb/cursor-plugin --skill auditing-cis-benchmark-cockroachdb

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve? Manually verifying a self-hosted CockroachDB cluster against the CIS CockroachDB Benchmark is slow and error-prone, requiring dozens of shell and SQL checks across every node. This Skill automates the assessment of all 30 Level 1 controls and produces a structured PASS/FAIL/MANUAL compliance report. ## Core Features & Use Cases - Two Audit Depths: Run a quick scan with one-liner shell/SQL checks per control, or a full audit following the official multi-step CIS procedures for evidence collection. - Six Security Domains: Covers installation and patches, system hardening and topology, logging and monitoring, user access and authorization, data protection, and CockroachDB settings. - Structured Compliance Report: Generates a markdown report with PASS/FAIL/MANUAL/N/A findings, CIS Controls v7/v8 mappings, and a severity-ordered remediation summary. - Use Case: Before a SOC 2 or PCI DSS audit, run the quick scan across all cluster nodes to identify failing controls like disabled auth logging or missing HBA rules, then run the full audit on failures to gather evidence for auditors. ## Quick Start Audit my self-hosted CockroachDB cluster against the CIS Benchmark and generate a compliance report.

Frequently Asked Questions about auditing-cis-benchmark

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I audit CockroachDB against the CIS Benchmark?

Run this Skill with shell access to cluster nodes and SQL admin or VIEWACTIVITY privilege. It checks all 30 CIS Level 1 controls using read-only shell commands and SQL queries, then produces a structured PASS/FAIL/MANUAL report.

What is the difference between quick scan and full audit?

A quick scan runs one-liner shell or SQL commands per control for rapid pass/fail triage, while a full audit follows the official multi-step CIS procedures for evidence collection. You can combine both by scanning first and fully auditing the failures.

Does the CIS benchmark audit work on CockroachDB Cloud?

No, this Skill targets self-hosted CockroachDB deployments only. Cloud clusters have managed controls that supersede many CIS self-hosted checks, so use the auditing-cloud-cluster-security skill for Cloud clusters instead.

Does the CIS audit modify my CockroachDB cluster?

No, all operations are read-only using SHOW and SELECT SQL statements plus read-only shell tools like ps, ls, and openssl. The single exception is control 4.2, which temporarily sets allow_unsafe_internals for password hash inspection and resets it immediately.

What access do I need to run a CockroachDB CIS audit?

You need SSH or shell access to cluster nodes for OS-level checks, SQL access with admin or VIEWACTIVITY privilege for cluster settings, and access to systemd service files and the certificate directory. Tools required include the cockroach CLI, systemctl, and openssl.