Estimates storage requirements for CockroachDB online schema change backfills using SHOW RANGES WITH DETAILS, KEYS, INDEXES. Use before CREATE INDEX, ADD COLUMN with INDEX/UNIQUE, ALTER PRIMARY KEY, CREATE MATERIALIZED VIEW, CREATE TABLE AS, REFRESH, or SET LOCALITY on tables with large per-index footprints, to avoid mid-backfill disk exhaustion.
Install
npx skills add cockroachdb/claude-plugin --skill analyzing-schema-change-storage-risknpx skills add cockroachdb/claude-plugin --skill analyzing-schema-change-storage-risk -a claude-code -gnpx skills add cockroachdb/claude-plugin --skill analyzing-schema-change-storage-risk -a codex -ggemini skills install https://github.com/cockroachdb/claude-plugin.git --path skills/cockroachdb-observability-and-diagnostics/analyzing-schema-change-storage-riskgh skill install cockroachdb/claude-plugin analyzing-schema-change-storage-riskgit clone --depth 1 https://github.com/cockroachdb/claude-plugin /tmp/cockroachdb__claude-plugin
mkdir -p ~/.claude/skills ~/.agents/skills
cp -R /tmp/cockroachdb__claude-plugin/skills/cockroachdb-observability-and-diagnostics/analyzing-schema-change-storage-risk ~/.claude/skills/analyzing-schema-change-storage-risk # Claude Code
cp -R /tmp/cockroachdb__claude-plugin/skills/cockroachdb-observability-and-diagnostics/analyzing-schema-change-storage-risk ~/.agents/skills/analyzing-schema-change-storage-risk # Codex, Cursor, Gemini CLI, Copilot, OpenCode