--- name: bazinga-db-core description: Session lifecycle and system operations. Use when creating sessions, saving state, getting dashboard data, or running system queries. version: 2.0.0 allowed-tools: [Bash, Read] --- # BAZINGA-DB Core Skill You are the bazinga-db-core skill. You manage session lifecycle, state snapshots, and system-level database operations. ## When to Invoke This Skill **Invoke when:** - Creating or retrieving orchestration sessions - Saving\/restoring orchestrator or PM state - Getting dashboard snapshots for status reporting - Running custom SELECT queries - Checking database integrity or recovering **Do NOT invoke when:** - Managing task groups or plans → Use `bazinga-db-workflow` - Logging interactions or reasoning → Use `bazinga-db-agents` - Managing context packages → Use `bazinga-db-context` ## Script Location **Path:** `.claude\/skills\/bazinga-db\/scripts\/bazinga_db.py` All commands use this script with `--quiet` flag: ```bash python3 .claude\/skills\/bazinga-db\/scripts\/bazinga_db.py --quiet [args...] ``` ## Commands ### create-session ```bash python3 .claude\/skills\/bazinga-db\/scripts\/bazinga_db.py --quiet create-session \ "" "" "" ``` Creates a new orchestration session. **Parameters:** - `session_id`: Unique identifier (e.g., `bazinga_abc123`) - `mode`: `simple` or `parallel` - `user_request`: Original user request text **Returns:** `{"session_id": "...", "status": "active", "mode": "..."}` ### get-session ```bash python3 .claude\/skills\/bazinga-db\/scripts\/bazinga_db.py --quiet get-session "" ``` **Returns:** Full session object with all fields. ### list-sessions ```bash python3 .claude\/skills\/bazinga-db\/scripts\/bazinga_db.py --quiet list-sessions [limit] ``` **Parameters:** - `limit`: Optional, defaults to 10 **Returns:** Array of recent sessions ordered by created_at DESC. ### update-session-status ```bash python3 .claude\/skills\/bazinga-db\/scripts\/bazinga_db.py --quiet update-session-status \ "" "" ``` **Valid status values:** `active`, `paused`, `completed`, `failed`, `cancelled` ### save-state ```bash python3 .claude\/skills\/bazinga-db\/scripts\/bazinga_db.py --quiet save-state \ "" "" '' [--group-id ] ``` Saves state snapshot with UPSERT semantics (insert or update). **Parameters:** - `session_id`: Session identifier - `state_type`: `orchestrator`, `pm`, `group_status`, or `investigation` - `json_state`: JSON object with state data - `--group-id`: Optional group isolation key (default: `global`) - Use `global` for session-level state (orchestrator, pm) - Use task group ID for group-specific state (investigation) **Example with group_id:** ```bash python3 ...\/bazinga_db.py --quiet save-state \ "bazinga_abc123" "investigation" '{"status": "in_progress"}' --group-id "CALC" ``` **Note:** Uses UPSERT - safe to call multiple times for same (session_id, state_type, group_id). ### get-state ```bash python3 .claude\/skills\/bazinga-db\/scripts\/bazinga_db.py --quiet get-state \ "" "" [--group-id ] ``` **Parameters:** - `--group-id`: Optional group isolation key (default: `global`) **Returns:** Latest state snapshot for the specified type and group. ### dashboard-snapshot ```bash python3 .claude\/skills\/bazinga-db\/scripts\/bazinga_db.py --quiet dashboard-snapshot "" ``` **Returns:** Complete dashboard data including: - Session details - Task groups with status - Success criteria - Recent orchestration logs - Reasoning timeline ### query ```bash python3 .claude\/skills\/bazinga-db\/scripts\/bazinga_db.py --quiet query "" ``` Execute custom SELECT query (read-only). **Example:** ```bash python3 ...\/bazinga_db.py --quiet query "SELECT COUNT(*) FROM sessions WHERE status='completed'" ``` ### integrity-check ```bash python3 .claude\/skills\/bazinga-db\/scripts\/bazinga_db.py --quiet integrity-check ``` Runs SQLite integrity check. Returns `{"status": "ok"}` or error details. ### recover-db ```bash python3 .claude\/skills\/bazinga-db\/scripts\/bazinga_db.py --quiet recover-db ``` Attempts to recover corrupted database from WAL. ### detect-paths ```bash python3 .claude\/skills\/bazinga-db\/scripts\/bazinga_db.py --quiet detect-paths ``` Shows auto-detected paths for database and project root. ## Output Format Return ONLY raw JSON output. No formatting, markdown, or commentary. ## Error Handling - Missing session: Returns `{"error": "Session not found: "}` - Invalid status: Returns `{"error": "Invalid status: "}` - Database locked: Retry after 100ms (automatic) ## References - Full schema: `.claude\/skills\/bazinga-db\/references\/schema.md` - All commands: `.claude\/skills\/bazinga-db\/references\/command_examples.md` - CLI help: `python3 ...\/bazinga_db.py help`