Databases
Every LazyFrog project has its own PostgreSQL 19 database: one for the preview your AI builds in, and one for your live site.
Each environment has its own PostgreSQL 19 database, ready from the start. Your app finds it in DATABASE_URL. Extensions available: pgvector, PostGIS, pg_trgm, citext, hstore, uuid-ossp and pg_stat_statements.
Changing the structure
Your AI adds migrations (numbered SQL files in migrations/) and applies them to the preview. Publishing applies them to the live database after trying them on a copy. Changes that would remove data need your confirmation.
Looking at the data
The portal's Database screen shows tables and rows for either environment and runs queries. Writes on the live database ask you to confirm, and a snapshot is taken first.
Live data stays live
Preview data is never copied to the live site. What the live site needs at the start (a menu, say) goes in through migrations or a confirmed one-time step.
For your AI: this page as Markdown · llms.txt