Migrating collaborators

Export and import collaborators when moving between Pages CMS installs.

When you need this

Collaborators are stored in the database, not in .pages.yml.

If you move to a new database or a new Pages CMS install, migrate collaborators separately.

Export from the current database

npm run db:collaborators:export -- --output=collaborators.csv

Import into the new database

npm run db:collaborators:import -- --input=collaborators.csv

Optional import flags

  • --replace: remove current collaborators before import.
  • --default-invited-by-user-id=<userId>
  • --default-invited-by-email=<email>

Export from legacy SQLite or libSQL

If you are migrating from an older Pages CMS install that used SQLite or libSQL/Turso, first export collaborators with the legacy exporter script included in the Pages CMS repo:

db/scripts/export-collaborators-legacy-libsql.mjs

Run it from the Pages CMS repository root:

SQLITE_URL="libsql://..." SQLITE_AUTH_TOKEN="..." \
npx -y -p @libsql/client node db/scripts/export-collaborators-legacy-libsql.mjs --out=collaborators.csv

You can also pass credentials as flags instead of environment variables:

npx -y -p @libsql/client node db/scripts/export-collaborators-legacy-libsql.mjs \
  --url="libsql://..." \
  --token="..." \
  --out=collaborators.csv

Once done, import the resulting CSV with the normal importer.