Database

The application uses PostgreSQL. Connection string is in DATABASE_URL environment variable.

To query the database directly:

export $(cat .env | xargs) && psql $DATABASE_URL -c "YOUR SQL"

Note: Table names with uppercase letters require double quotes (e.g., "Member", "Task").

Schema

-- Schema not synced. Run sync.sh in the scripts folder.

Tips

• Use LIMIT 5 when exploring data
• Check column names before writing queries
• Join tables using foreign key relationships shown in schema