sqlite-db-generatorlisted

Design and build a local SQLite database — brainstorm entities, define schemas, write records, query data, and expose a standard interface other skills can consume. Use this skill whenever the user wants to persist structured data locally, think through a data model, create or update a SQLite schema, insert or update records, run queries, bulk import/export data, or build a lightweight local store for an agent or CLI tool. Also trigger when the user edits schema.sql and wants the skill and db to reflect those changes. Trigger phrases: "create a sqlite db", "set up a local database", "store this in sqlite", "help me design a schema", "what tables do I need", "save records to a db", "query my local db", "update the schema", "add a table", "sync the schema", "export my data", "import records".
alycd/agent-skills · ★ 0 · API & Backend · score 56

Install: claude install-skill alycd/agent-skills

# SQLite Store Skill A skill for designing and building a local SQLite database. Always start with the brainstorming phase — rushing to tables before understanding the domain produces schemas that need to be rewritten. The **`schema.sql` file is the single source of truth** once design is done. After any schema change, run the sync command to keep the db and this skill in sync. Other skills can consume this db via the standard `context` and `schema` commands — no Markdown parsing required. --- ## File Layout ### Local scope (default) — DB belongs to a specific project ``` <project>/ ├── schema.sql ← source of truth; edit this to change the db ├── migrations/ ← versioned .sql files for post-deploy changes │ └── 001_initial.sql ├── scripts/ │ ├── init_db.py ← bootstrap + sync; run after every schema change │ └── db_cli.py ← template; init_db.py bakes DB_PATH and copies it ├── db/ │ └── <name>.db ← DB lives here (add to .gitignore) └── .claude/skills/<name>-db/ ├── SKILL.md ← auto-generated agent skill (schema + commands) └── db_cli.py ← baked copy with absolute DB_PATH ``` ### Global scope — personal DB usable from any project Everything lives together in one folder; **nothing is written to the current project directory**. ``` ~/db/<name>/ ├── <name>.db ← the database ├──