OpenParable
Skip to content
← Back to skills

DB Browser

Apps & Automation
db-browser

DB Browser is an Agent Skill for apps & automation published in the sonichi/sutando repository on GitHub: a SKILL.md instruction file an AI agent can load to do this task.

Install DB Browser for SQLite (if not already installed) and open a .sqlite file in it. macOS only.

View on GitHub ↗
QUICK START

How to use this skill

Bring this guide into your coding agent with a prompt tailored to the tool you use.

  1. Open your project in Codex.
  2. Copy and paste the prompt below.
  3. Review files and risks before approving any action.
Prompt to paste
Inspect the Agent Skill at https://github.com/sonichi/sutando/blob/HEAD/skills/db-browser/SKILL.md and all supporting files. Report provenance, permissions, scripts, dependencies, and security risks. Propose an exact installation into .agents/skills/db-browser, but wait for my approval before writing files or running scripts.

Copying this prompt does not install or run the skill. Review third-party files before use.

DB Browser

Install DB Browser for SQLite via Homebrew if it isn't already installed, then open a given .sqlite file in it. Macos only — uses brew --cask + open -a.

Usage: /db-browser <path-to.sqlite>

ARGUMENTS: $ARGUMENTS

Steps

  1. Resolve the path argument. If empty, default to $(bash scripts/sutando-config.sh workspace)/data/conversation.sqlite (the M0 helper — reads sutando.config.local.json, defaulting to <repo>/workspace/data/conversation.sqlite; $SUTANDO_WORKSPACE no longer honored as of v0.8 / #1440). Bail with an error if the file doesn't exist.
  2. Check whether DB Browser for SQLite is installed: mdfind "kMDItemKind == 'Application'" 2>/dev/null | grep -qi 'DB Browser for SQLite' (or [ -d /Applications/DB\ Browser\ for\ SQLite.app ]). If installed, skip step 3.
  3. Install via Homebrew: brew install --cask db-browser-for-sqlite. Requires brew. If brew is missing, stop and ask the user to install brew first.
  4. If DB Browser is already running on a DIFFERENT db file (its cached snapshot of THAT db won't auto-refresh when you switch files), quit it first: osascript -e 'tell application "DB Browser for SQLite" to quit'; sleep 2. Skip if not running.
  5. Open the file: open -a "DB Browser for SQLite" "<resolved-path>". Sleep ~2s so the window is up before reporting back.
  6. Confirm: print the resolved path + verify DB Browser has the file open via lsof -c "DB Browser" 2>/dev/null | grep "<resolved-path>".

Notes

  • DB Browser caches the schema + first page of data at open time. If the on-disk db file changes underneath (e.g. a migration drops tables, a writer adds rows), the open DB Browser window keeps showing the stale view until you re-open it. That's why step 4 quits first when re-opening — same-file re-open is also a valid refresh trigger.
  • WAL flush: if the db is in WAL mode and recent writes haven't merged into the main file, the .sqlite-wal sidecar holds them. DB Browser reads both — no checkpoint needed. (Run sqlite3 <db> 'PRAGMA wal_checkpoint(TRUNCATE);' only if you want a single-file dump.)
  • This skill does NOT screenshot, query, or modify the db. Just install + open. Anything else (screenshot for a PR, run a SQL via Execute SQL, export CSV) is the operator's job in the GUI.