This project includes a DevContainer configuration for a consistent development environment with PostgreSQL.
- Open the project in VS Code
- Install the "Dev Containers" extension if not already installed
- When prompted, click "Reopen in Container" or use Command Palette: "Dev Containers: Reopen in Container"
- Wait for the container to build (first time takes a few minutes)
- The database and development environment will be automatically set up
If you prefer to run the containers manually:
cd .devcontainer
docker-compose up -d
docker-compose exec app bash- Node.js 20 development environment
- PostgreSQL 17 database running as a separate container
- Claude Code for AI-powered development assistance
- Prisma CLI and database tools
- PostgreSQL client tools via devcontainer features
- Test database configuration
- VS Code extensions for TypeScript, Prisma, and PostgreSQL
The PostgreSQL database is automatically configured with:
- Host:
db(from within containers) orlocalhost:5432(from host) - Database:
case - User:
case - Password:
case_password
To view and edit your database visually:
npm run prisma:studioThen open http://localhost:5555 in your browser.
The devcontainer is configured with a test database. Run tests with:
# Run all tests
npm test
# Run tests in watch mode
npm run test:watch
# Run tests with coverage
npm run test:coverageThe devcontainer automatically uses .env.devcontainer settings. Your Slack credentials still need to be added:
- Copy your Slack app credentials into
.env:SLACK_BOT_TOKENSLACK_SIGNING_SECRETSLACK_APP_TOKEN
If you encounter database connection issues:
# Check if PostgreSQL is running
docker-compose ps
# View PostgreSQL logs
docker-compose logs db
# Restart the database
docker-compose restart dbTo completely reset your development database:
# Drop all tables and re-run migrations
npx prisma migrate reset- app: Main development container with Node.js 20
- db: PostgreSQL 17 database