odoo-stream

Stream a remote Odoo DB + filestore into local dev

Pulls a remote nellika.sh / tcff Odoo deployment's database and filestore directly into the LOCAL dev environment at ~/odoo by streaming over SSH — pg_dump | pg_restore and tar | tar, with no intermediate dump files on disk. The DB and filestore transfers run in parallel.

The skill entry point is a thin wrapper script:

__STREAM_SH__ <remote_ssh_host> [options]

It forwards to the single shared implementation — the engine's stream verb in manage_odoo.sh (stream_remote_odoo), the same code the odoo CLI and the MCP server use. So these are equivalent:

__STREAM_SH__ nellika_production_odoo --neutralize     # this skill (prompts unless --yes)
node __ODOO_CLI__ stream nellika_production_odoo --neutralize   # the odoo CLI
# MCP:  odoo_project  action=stream  remoteHost=nellika_production_odoo  neutralize=true

What it does

1. Discovers the remote (read-only): one ssh sources the remote ~/scripts/odoo.env to read odoo_db and data_dir (and PGUSER/PGPASSWORD, so pg_dump authenticates there). Override with --remote-db / --remote-data-dir.
2. Reads the ACTIVE local project from ~/odoo/odoo.conf (db_name, db_user, db_host, db_port, filestore).
3. Stops local Odoo, then runs two streams in parallel:
   • DB: terminate connections → dropdb/createdb -O <user> → create unaccent+pg_trgm (IMMUTABLE) → ssh … pg_dump -Fc | pv | pg_restore.
   • Filestore: ssh … tar -zc | pv | tar -zx, then rename $odoo_db → <db_name>.
4. Optionally neutralize (reuses odoo-bin neutralize), then start Odoo.

Prerequisites

• Local Postgres major version must be >= the remote's. Remote production is PG17, so the local cluster must be PG17. The script uses the Postgres.app 17 client tools at /Applications/Postgres.app/Contents/Versions/17/bin (pg_restore, createdb, dropdb, psql) when present, else falls back to PATH.
• pv (progress bar) is optional — falls back to a plain pipe.
• SSH access configured in ~/.ssh/config.d/. Hosts follow the pattern <deployment>_<env>_odoo, e.g. nellika_production_odoo, nellika_staging_odoo, nellika_test_odoo, tcff_production_odoo, …
• The remote must have ~/scripts/odoo.env exporting odoo_db, data_dir, PGUSER, PGPASSWORD.