Skip to main content

Database Access Patterns

Local Development (Docker)​

cd statux-api
docker-compose up -d

# Connect
psql -h localhost -U statux_admin -d statux
# Password: localdev123

SSH Tunnel to Production​

# Configure .env
BASTION_HOST=<bastion-ip>
RDS_HOST=<rds-endpoint>

# Open tunnel (keep terminal open)
./scripts/tunnel.sh

# In another terminal
npm run start:dev:statuspages

Direct Bastion Access​

# SSH to bastion
ssh -i ~/.ssh/statux-bastion.pem ec2-user@<bastion-ip>

# From bastion, connect to RDS
psql -h <rds-endpoint> -U statux_admin -d statux