Real Estate Core

Database Setup

PostgreSQL CLI (psql) Setup

To use psql directly from the terminal without typing the full path:

1. Add PostgreSQL binaries to your PATH:

   echo 'export PATH="/Library/PostgreSQL/17/bin:$PATH"' >> ~/.zshrc
   source ~/.zshrc

   This makes psql available in all new terminal sessions.

2. Connect to the database:

   psql 'postgresql://USERNAME:PASSWORD@localhost:5432/avm_platform'

   ⚠️ If your password contains special characters (!, @, #), they must be URL-encoded. Example: ! → %21

   psql 'postgresql://avm_admin:Temp12345%21@localhost:5432/avm_platform'

3. Verify tables:

   \dt

   Expected: alembic_version, listing, property, source

Troubleshooting

• If psql isn't found: confirm echo $PATH includes /Library/PostgreSQL/17/bin
• If connection fails: double-check password encoding in the URI
• For GUI (DBeaver): use the same credentials

Run locally

uvicorn avm_platform.api.main:app --reload