Database Practice Lab
Learn how this portfolio talks to PostgreSQL. This page only ever exposes safe stats — never connection strings, passwords, or secrets.
Checking connection...
Start PostgreSQL and retry
Practice Commands
Prisma Studio
npx prisma studio
Visual database explorer — view/create/edit/delete records and inspect relationships.
Generate client
npm run db:generate
Regenerates the typed Prisma client after schema changes.
Run migrations
npm run db:migrate
Creates/applies schema migrations against PostgreSQL.
Seed database
npm run db:seed
Loads the CV-based portfolio data (safe to re-run).
Backup
./scripts/db-backup.sh
pg_dump custom-format backup into backups/.
Restore
./scripts/db-restore.sh backups/example.dump
pg_restore with confirmation — restores a dump.
SQL practice
psql -U portfolio_app -d ankush_portfolio
Interactive psql shell — exercises in docs/database/sql-practice.md.
Import/Export
psql \copy ...
CSV export/import workflow in docs/database/import-export.md.