skills.rest
cockroachdb
cockroachdbOFFICIAL
Explore all skills by this author →
WebsiteGitHub

managing-cluster-settings

Identify non-default CockroachDB cluster settings and apply tier-based modification rules.

3|3|Updated Mar 11, 2026
Search Tags:#audit#configuration#risk-management#cockroachdb#cluster-settings#sql-setup#tier-access
One-click install
npx skills add https://github.com/cockroachdb/claude-plugin --skill managing-cluster-settings
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: managing-cluster-settings
Source: https://github.com/cockroachdb/claude-plugin/tree/main/skills/operations-and-lifecycle/managing-cluster-settings
Command: npx skills add https://github.com/cockroachdb/claude-plugin --skill managing-cluster-settings

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

Reviews, audits, and modifies CockroachDB cluster settings. Self-Hosted has full control over all settings and start flags. Advanced/BYOC can modify most SQL-level settings but infrastructure settings are managed by CRL. Standard has limited settings access — session variables are the primary tuning mechanism. Basic has minimal settings — use session variables and Cloud Console. Use when auditing configuration, tuning performance, or troubleshooting settings-related issues.

Core Features & Use Cases

  • Tier-aware auditing and modification of cluster settings across Self-Hosted, Advanced/BYOC, Standard, and Basic.
  • Guidance for applying changes safely with tier-specific constraints and recommended-production settings from references.
  • Use cases include auditing configuration after upgrades, tuning performance, diagnosing incidents, and license/infrastructure management.

Quick Start

Audit your CockroachDB cluster settings across tiers and apply compliant changes using the guided workflow.

Frequently Asked Questions about managing-cluster-settings

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

FAQPage Schema
How do I audit CockroachDB cluster settings across different deployment tiers?▼

Audit CockroachDB cluster settings by running SHOW ALL CLUSTER SETTINGS to identify non-default configurations. Apply tier-specific modification rules for Self-Hosted, Advanced/BYOC, Standard, and Basic deployments to ensure compliant, risk-aware outcomes.

What CockroachDB cluster settings can I modify in Standard and Basic tiers?▼

Standard and Basic tiers restrict cluster setting modifications, making session variables the primary tuning mechanism. Basic offers minimal settings access via Cloud Console, while Standard provides limited settings access compared to Self-Hosted or Advanced/BYOC tiers.

How do I safely tune CockroachDB cluster settings after an upgrade?▼

Safely tune CockroachDB cluster settings after upgrades by reviewing non-default configurations with SHOW ALL CLUSTER SETTINGS, checking tier-specific modification allowances, and applying recommended production settings from references to preserve upgrade integrity.

What's the difference between cluster settings and session variables in CockroachDB Cloud?▼

Cluster settings are persistent configuration parameters, while session variables are temporary tuning mechanisms scoped to a connection. Standard and Basic CockroachDB Cloud tiers limit cluster setting access, making session variables the primary method for performance tuning.

Can I change infrastructure settings in CockroachDB Advanced or BYOC deployments?▼

Advanced and BYOC deployments allow modification of most SQL-level cluster settings, but infrastructure settings remain managed by CRL. Self-Hosted deployments provide full control over all settings and start flags.

Why are some CockroachDB cluster settings not applying in my deployment?▼

Cluster settings may not apply due to tier-specific constraints in CockroachDB Cloud. Standard and Basic tiers restrict modifications, requiring session variables instead. Use zone configurations and tier-aware rules to guide controlled changes and diagnose incidents.

Related Skills

Explore More Software Engineering Skills→
cockroachdbcockroachdb
3

reviewing-cluster-health

Diagnose CockroachDB cluster health with read-only crdb_internal queries.

Official
Advanced
tusosostusosos

supabase-postgres-best-practices

Identify and apply Postgres performance best practices for queries and schema design.

Community
Advanced
cockroachlabscockroachlabs
18

analyzing-range-distribution

Diagnose range distribution and fragmentation in CockroachDB using SHOW RANGES queries.

Official
Advanced
cockroachdbcockroachdb
3

managing-cluster-capacity

Automates CockroachDB cluster capacity planning and execution across deployment tiers.

Official
Advanced