Audits optimizer table statistics for staleness, missing coverage, and data quality issues using SHOW STATISTICS. Use when diagnosing poor query performance, unexpected plan changes, or after bulk data changes to identify stale statistics requiring refresh via CREATE STATISTICS.
Install
npx skills add cockroachdb/claude-plugin --skill auditing-table-statisticsnpx skills add cockroachdb/claude-plugin --skill auditing-table-statistics -a claude-code -gnpx skills add cockroachdb/claude-plugin --skill auditing-table-statistics -a codex -ggemini skills install https://github.com/cockroachdb/claude-plugin.git --path skills/cockroachdb-observability-and-diagnostics/auditing-table-statisticsgh skill install cockroachdb/claude-plugin auditing-table-statisticsgit 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/auditing-table-statistics ~/.claude/skills/auditing-table-statistics # Claude Code
cp -R /tmp/cockroachdb__claude-plugin/skills/cockroachdb-observability-and-diagnostics/auditing-table-statistics ~/.agents/skills/auditing-table-statistics # Codex, Cursor, Gemini CLI, Copilot, OpenCode