#!/usr/bin/env bash
set -euo pipefail
for db in /opt/struktur/hermes-carlo/data/kanban.db /opt/struktur/hermes-carlo/data/kanban.db.backup_pre_kanban_xfer_20260605_175846 /opt/struktur/hermes-carlo/data/kanban.db.backup_pre_strategic_status_fix_20260606_082503 /opt/struktur/hermes-carlo/data/kanban.db.replaced_pre_workspace_xfer_20260605_181621; do
  echo "==== $db"
  sqlite3 -readonly "$db" '.tables' 2>/dev/null || true
  sqlite3 -readonly "$db" "select name,sql from sqlite_master where type='table' and name like '%task%';" 2>/dev/null || true
  sqlite3 -readonly "$db" "select status,count(*) from tasks group by status order by status;" 2>/dev/null || true
done