bd help --doc sql.
Execute a raw SQL query against the underlying database (SQLite or Dolt).
Useful for debugging, maintenance, and working around bugs in higher-level commands.
Examples:
bd sql ‘SELECT COUNT(*) FROM issues’
bd sql ‘SELECT id, title FROM issues WHERE status = “open” LIMIT 5’
bd sql ‘DELETE FROM dirty_issues WHERE issue_id = “bd-abc123”’
bd sql —csv ‘SELECT id, title, status FROM issues’
The query is passed directly to the database. SELECT queries return results as a
table (or JSON/CSV with —json/—csv). Non-SELECT queries (INSERT, UPDATE, DELETE)
report the number of rows affected.
WARNING: Direct database access bypasses the storage layer. Use with caution.
CLI Reference
bd sql
Execute raw SQL against the beads database
Generated from
Flags: