migrate-pg-to-sqlite

Overview ¶

Command migrate-pg-to-sqlite copies a legacy `hanzo_cloud` PostgreSQL database into per-(org, user) SQLite files served by the Hanzo cloud orchestrator (HIP-0106).

The migrator is introspective: it reads information_schema for the table set and columns, then routes each row to its destination file based on org_id / user_id columns (or canonical fallbacks). Rows with neither column land under /<root>/_global/_org/cloud.sqlite so the operator can triage rather than silently dropping them.

Usage:

migrate-pg-to-sqlite \
    --src 'postgres://cloud:pass@postgres.hanzo.svc:5432/hanzo_cloud?sslmode=disable' \
    --dst /data

Per ~/work/hanzo/CLAUDE_PG_TO_SQLITE_MIGRATION.md (service #4 — cloud).