Switch between SQLite and PostgreSQL
3 min · 3 steps
Your scaffolded app starts on SQLite. Switch to PostgreSQL once you're ready to deploy.
The Database tab's Setup card surfaces the active provider + a switch button. Switching kicks off a migration: Avery rewrites the datasource block in `prisma/schema.prisma`, dumps your local SQLite data, and offers to seed PostgreSQL with it. Enums declared in your fragments come back when you switch up to PostgreSQL — the schema-composer downgrades them to String columns for SQLite automatically.
Steps
- Open the Database tab → Setup sub-tab.
The card lists the active provider + connection string template.
- Click 'Switch to PostgreSQL'.
Avery prompts for a connection URL (or autopopulates one from a local Postgres install if it finds one).
- Confirm the seed.
Avery dumps SQLite, imports into PostgreSQL, and re-runs `prisma migrate dev` to lock in the schema.
Live recipes need the desktop
This article is a static preview. The in-app Help sidecar inside Avery NXR can fire each step against your live project — install the desktop to use it interactively.