Rust SQLite CLI Architecture

Use this skill when designing or reviewing a Rust command-line application that stores durable local state in SQLite. The output is an implementation-ready architecture plan, not a pile of generic database advice. It should identify where data lives, how schema changes land, which commands own transactions, how tests prove safety, and how users recover when something goes wrong.

Critical Constraints