codex-log-guard

97 / 100 · Low risk

Fine to try. Some of what it can do is expected: a coding skill usually runs build and test commands.

By majiayu000/spellbook (GitHub) · coding · 290 stars · scanned at commit 238e076

Diagnose excessive Codex local SQLite diagnostic log writes with read-only evidence by default. Use when a user mentions logs_2.sqlite, logs_2.sqlite-wal, block_log_inserts, SSD/TBW wear, or explicitly asks to protect, clean up, verify, or restore Codex diagnostic logging.

Works with any agent that supports SKILL.md skills.

What this skill can do

Runs commands on your computer

This is disclosed by the author in the skill's SKILL.md or README. Expected for a coding skill.

Found in 9 places.

skills/codex-log-guard/SKILL.md, line 86for db in ~/.codex/logs_2.sqlite ~/.codex/sqlite/logs_2.sqlite; do
skills/codex-log-guard/SKILL.md, line 96: "${CODEX_LOG_DB:?set CODEX_LOG_DB to the verified active candidate}"
skills/codex-log-guard/SKILL.md, line 110sqlite3 "$db" ".tables"

Show 6 more

skills/codex-log-guard/SKILL.md, line 118for i in 1 2 3; do
skills/codex-log-guard/SKILL.md, line 129sqlite3 "$db" "SELECT level, COUNT(*) AS n, ROUND(SUM(estimated_bytes)/1024.0/1024.0, 1) AS estimated_mib FROM logs GROUP BY level ORDER BY n DESC;"
skills/codex-log-guard/SKILL.md, line 136lsof ~/.codex/logs_2.sqlite ~/.codex/logs_2.sqlite-wal ~/.codex/logs_2.sqlite-shm \
skills/codex-log-guard/SKILL.md, line 143sqlite3 "$db" "PRAGMA busy_timeout=10000; CREATE TRIGGER IF NOT EXISTS block_log_inserts BEFORE INSERT ON logs BEGIN SELECT RAISE(IGNORE); END;"
skills/codex-log-guard/SKILL.md, line 149backup="$db.bak.$(date +%Y%m%d-%H%M%S)"
skills/codex-log-guard/SKILL.md, line 160sqlite3 "$db" "DROP TRIGGER IF EXISTS block_log_inserts;"

Install

Paste this into your terminal. It downloads exactly the version we scanned, not whatever is newest.

if [ -e ~/.agents/skills/'codex-log-guard' ] || [ -L ~/.agents/skills/'codex-log-guard' ]; then echo 'A skill folder named codex-log-guard already exists — not replacing it' >&2; false; else d=$(mktemp -d) && git clone --quiet --filter=blob:none --no-checkout 'https://github.com/majiayu000/spellbook' "$d" && git -C "$d" checkout --quiet '238e07625aeca5bcf0d6f7cb3e2d07f94c717194' -- 'skills/codex-log-guard' && mkdir -p ~/.agents/skills && cp -R "$d"/'skills/codex-log-guard' ~/.agents/skills/'codex-log-guard' && rm -rf "$d"; fi

Codex reads ~/.agents/skills directly. For Claude Code, Cursor, Copilot, Gemini CLI, Antigravity or OpenCode, also link it. For Claude Code: ln -s ~/.agents/skills/'codex-log-guard' ~/.claude/skills/'codex-log-guard' (other agents: ~/.cursor/skills, ~/.copilot/skills, ~/.gemini/skills, ~/.gemini/config/skills, ~/.config/opencode/skills). Or install through the finder skill, which does both.

Badge for your README

The badge for majiayu000/spellbook shows the score of its lowest-scoring skill.

SkillTrust badge for majiayu000/spellbook

[![SkillTrust](https://zalavijaysinh.github.io/skilltrust/badges/majiayu000/spellbook.svg)](https://zalavijaysinh.github.io/skilltrust/repos/majiayu000/spellbook/)

Score history

Date	Version	Score
2026-11-07	`238e076`	100