メニュー
Use before any change to src/db/schema.rs or SurrealDB schema definitions. Symptoms - adding a new field to todo/note, changing an index, adding a new table, or seeing schema-related test failures after a schema edit.
Codex または Claude でインストール この Prompt をコピーして Codex、Claude、または他のアシスタントに貼り付けると、Skill ページを確認してインストールできます。
SOC 職業分類に基づく
Deep codebase analysis — architecture health, test coverage gaps, tech debt, and actionable findings
Run pre-commit checks (fmt, clippy, test) then stage, commit, and push with a conventional message
Review staged or recent changes for correctness, style, and Rust conventions before committing
Use when SSHing into remote machines, looking up credentials, renaming Tailscale devices, or accessing services on the tailnet. Symptoms - SSH auth failures, too many authentication failures, command not found tailscale, need to find credentials for remote machines.
Use when mixing Tokio async code with synchronous blocking I/O libraries (tar, flate2, zip, csv), or when seeing "cannot block the current thread from within the async context" panics, or needing to stream async bytes into a sync reader.
Structured BAML schema edit → validate → test loop for the devloop project. Use when editing any *.baml file in crates/baml/baml_src/ — covers version parity gotchas, uvx invocation, regeneration workflow, and the analyze verify step.
| name | doob-schema-migration |
| description | Use before any change to src/db/schema.rs or SurrealDB schema definitions. Symptoms - adding a new field to todo/note, changing an index, adding a new table, or seeing schema-related test failures after a schema edit. |
doob's SurrealDB schema is defined in src/db/schema.rs and applied on every connection via define_schema(). Changes here affect the live database at ~/.claude/data/doob.db.
cp ~/.claude/data/doob.db ~/.claude/data/doob.db.bak.$(date +%Y%m%d-%H%M%S)
ls -lh ~/.claude/data/doob.db.bak.*
| Change type | Risk | Notes |
|---|---|---|
| Add optional field with default | Low | Existing records get default |
| Add required field without default | High | Existing records break |
| Add new index | Low | SurrealDB builds index on existing records |
| Remove field | High | Lost data, query breakage |
| Rename field | High | All queries must be updated |
| Add new table | None | No impact on existing tables |
// In schema.rs — add OPTIONAL field with DEFAULT
db.query("DEFINE FIELD external_refs ON TABLE todo TYPE option<array> DEFAULT []").await?;
SurrealDB applies defaults to existing records on next read — no data migration needed.
# Tests use tempfile for isolation — run normally
cargo nextest run --all-features
# Verify specific schema test
cargo nextest run -- db
# Run against backed-up copy
DOOB_DB_PATH=~/.claude/data/doob.db.bak.<timestamp> doob todo list
# Restore from backup
cp ~/.claude/data/doob.db.bak.<timestamp> ~/.claude/data/doob.db
| Mistake | Fix |
|---|---|
| Editing schema without backup | Always backup first — schema errors can corrupt records |
| Adding required field to existing table | Always use TYPE option<T> with DEFAULT |
| Forgetting to update model struct | Schema and src/models/*.rs must stay in sync |
Running cargo test (not nextest) | Use cargo nextest run — parallel tests need isolation |