Swappable database providers, local-first db commands, the cloud project database, and the migration discipline.
PostgreSQL, MySQL, and SQLite are swappable bonds; the same handlers run on any of them. Change providers with one command:
mlcl swap @molecule/api-database-mysqlmlcl db migrate # apply migrations (runs the scaffolded migrate.ts)
mlcl db reset --force # drop/recreate + migrate (DESTRUCTIVE)
mlcl db console # psql on the project DB
mlcl db url # print DATABASE_URLLocal defaults work out of the box (SQLite, or Postgres if you have it running); credentials live in api/.env.
mlcl db info --project <id> # connection + settings
mlcl db tables --project <id> # (also: query)
mlcl db backup --project <id> # (also: backup-list / restore)api/migrations/, applied by db migrate (and automatically on deploy).db reset --force drops data. It is for local development only.