sqlite-explorer

Installation
SKILL.md

SQLite DB Exploration

Rules of engagement

  • Default to read-only exploration (SELECT, schema queries).
  • Only run write queries (INSERT/UPDATE/DELETE/DDL) when explicitly asked or clearly required.
  • Always start by listing tables and inspecting schema before writing complex queries.
  • Prefer parameterized queries when constructing SQL from user-provided values (if applicable).

Use Bun script: sqlite-explorer.ts

You find a sqlite-explorer.ts script (which must be executed using Bun!) in ${SKILL_DIR}/scripts/sqlite-explorer.ts that implements this skill. It accepts command-line arguments to specify the database path, query, and mode (read-only vs write).

Usage

  • List tables: bun ${SKILL_DIR}/scripts/sqlite-explorer.ts ./path/to/db.sqlite --tables
Installs
1
GitHub Stars
40
First Seen
2 days ago
sqlite-explorer — academind/codex-course-resources