Database Environments

Syncing Production Data

Manual process:

1. Identify differences between dev and prod data
2. Write SQL UPDATE/INSERT statements
3. Execute in the Production Database shell
4. Verify data consistency after sync

Environment Variables

• DATABASE_URL — Connection string (auto-set by Replit)
• PGHOST, PGPORT, PGUSER, PGPASSWORD, PGDATABASE — Individual connection params

Storage Interface

All database operations go through server/storage.ts which implements IStorage. Routes in server/routes.ts call storage methods — never raw SQL.

Safety Rules

• Always use Drizzle ORM for migrations (never raw DDL)
• Use execute_sql tool for debugging only
• Never execute destructive SQL (DROP, DELETE, UPDATE) without explicit approval
• Use transactions for multi-table operations