The db-api skill exposes the repository's SQLite database to agents via a lightweight CLI (scripts/db.sh) and a small Python wrapper (scripts/skills/db-api.py). Use this skill for safe, read-first operations and limited CRUD tasks when a full service layer is not available.
Ensure sqlite3 is installed and scripts/lib/sql.sh DB_PATH points to the expected DB file (default: run/v-daemon.db).
If WAL cannot be enabled, move the DB to a WAL-capable filesystem (avoid certain CIFS mounts).
PRAGMA settings like foreign_keys must be applied per-connection; scripts/lib/sql.sh sets sensible defaults per run.
Check run/system.log and logs/sql-agent.log for initialization and errors.
Notes
Do not run untrusted SQL via the query endpoint; treat it as an administrative capability.
For complex or high-frequency DB work, implement a dedicated service layer rather than giving agents direct SQL access.
See docs/db-api.md and docs/db-api-spec.md for full reference and examples.
Converted and distributed by TomeVault — claim your Tome and manage your conversions.
1---2name: p3ngu1nzz-v-daemon-db-api3description: db-api skill4---56# db-api skill78The db-api skill exposes the repository's SQLite database to agents via a lightweight CLI (scripts/db.sh) and a small Python wrapper (scripts/skills/db-api.py). Use this skill for safe, read-first operations and limited CRUD tasks when a full service layer is not available.910## Usage1112- scripts/skills/db-api.py list-tables13- scripts/skills/db-api.py status14- scripts/skills/db-api.py show-table todos15- scripts/skills/db-api.py view todos [limit|'all'] [format] # formats: pretty (default), raw, csv16- scripts/skills/db-api.py view todos all pretty17- scripts/skills/db-api.py view todos 10 csv18- scripts/skills/db-api.py query "SELECT count(*) FROM todos;"1920## Output formats and status fields2122- view: supports three output formats:23 - pretty: sqlite3 -header -column (human-friendly table with column headers)24 - raw: pipe-delimited values without headers (good for scripting)25 - csv: header + CSV output26- status: prints the following fields to aid agents and operators:27 - DB_PATH, size, last_modified, last_access28 - tables: list of table names29 - table_row_counts: per-table counts30 - table_count: total number of tables31 - PRAGMA values: journal_mode, foreign_keys, busy_timeout32 - connected_processes: lsof output if available3334## Troubleshooting3536- Ensure sqlite3 is installed and scripts/lib/sql.sh DB_PATH points to the expected DB file (default: run/v-daemon.db).37- If WAL cannot be enabled, move the DB to a WAL-capable filesystem (avoid certain CIFS mounts).38- PRAGMA settings like foreign_keys must be applied per-connection; scripts/lib/sql.sh sets sensible defaults per run.39- Check run/system.log and logs/sql-agent.log for initialization and errors.4041## Notes4243- Do not run untrusted SQL via the `query` endpoint; treat it as an administrative capability.44- For complex or high-frequency DB work, implement a dedicated service layer rather than giving agents direct SQL access.45- See docs/db-api.md and docs/db-api-spec.md for full reference and examples.4647---48> Converted and distributed by [TomeVault](https://tomevault.io/claim/p3ngu1nzz) — claim your Tome and manage your conversions.49<!-- tomevault:4.0:skill_md:2026-04-14 -->
Run npx skillmds@latest add tomevault-io/p3ngu1nzz-v-daemon-db-api in your terminal (requires Node.js), paste this page's agent-chat prompt into Claude, Cursor, or any MCP-connected agent, or download the SKILL.md file and copy it into your agent's skills directory.
db-api skill It is listed under Integrations & APIs on SkillMD.
This skill has not completed SkillMD's automated safety review yet. Independent scanners report: SkillSpector: PASS, Skill Scanner: PASS. SkillMD never runs a skill's scripts for you; review the SKILL.md before installing.
This skill is tagged as working with Claude Code, Claude.ai, OpenAI Codex. SKILL.md is an open format, so most agents that read a skills directory can load it too.
Yes. Installing skills from SkillMD is free, and the skill stays under its author's original license.
tomevault-io (@tomevault-io) published this skill. Their other Agent Skills are listed on their SkillMD profile.
tomevault-io