bazinga-db-core

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:

python3 .claude/skills/bazinga-db/scripts/bazinga_db.py --quiet <command> [args...]

Commands

create-session

python3 .claude/skills/bazinga-db/scripts/bazinga_db.py --quiet create-session \
  "<session_id>" "<mode>" "<user_request>"

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

python3 .claude/skills/bazinga-db/scripts/bazinga_db.py --quiet get-session "<session_id>"

Returns: Full session object with all fields.

list-sessions

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

python3 .claude/skills/bazinga-db/scripts/bazinga_db.py --quiet update-session-status \
  "<session_id>" "<status>"

Valid status values: active, paused, completed, failed, cancelled

save-state

python3 .claude/skills/bazinga-db/scripts/bazinga_db.py --quiet save-state \
  "<session_id>" "<state_type>" '<json_state>' [--group-id <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:

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

python3 .claude/skills/bazinga-db/scripts/bazinga_db.py --quiet get-state \
  "<session_id>" "<state_type>" [--group-id <id>]

Parameters:

• --group-id: Optional group isolation key (default: global)

Returns: Latest state snapshot for the specified type and group.

dashboard-snapshot

python3 .claude/skills/bazinga-db/scripts/bazinga_db.py --quiet dashboard-snapshot "<session_id>"

Returns: Complete dashboard data including:

• Session details
• Task groups with status
• Success criteria
• Recent orchestration logs
• Reasoning timeline

query

python3 .claude/skills/bazinga-db/scripts/bazinga_db.py --quiet query "<sql_select>"

Execute custom SELECT query (read-only).

Example:

python3 .../bazinga_db.py --quiet query "SELECT COUNT(*) FROM sessions WHERE status='completed'"

integrity-check

python3 .claude/skills/bazinga-db/scripts/bazinga_db.py --quiet integrity-check

Runs SQLite integrity check. Returns {"status": "ok"} or error details.

recover-db

python3 .claude/skills/bazinga-db/scripts/bazinga_db.py --quiet recover-db

Attempts to recover corrupted database from WAL.

detect-paths

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: <id>"}
• Invalid status: Returns {"error": "Invalid status: <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