RDS PostgreSQL

Instances

Identifier	Engine	Class	Storage	Purpose
aiqlick-postgres	PostgreSQL 16.6	db.t4g.small	50GB	Production
aiqlick-postgres-dev	PostgreSQL 16.10	db.t4g.micro	20GB	Development

Endpoints

# Production
aiqlick-postgres.cx86go6iuul4.eu-north-1.rds.amazonaws.com:5432

# Development
aiqlick-postgres-dev.cx86go6iuul4.eu-north-1.rds.amazonaws.com:5432

Shared Database

Both backend and background-tasks connect to the same RDS instance per environment:

• Backend uses Prisma ORM (135 models in prisma/schema.prisma)
• Background Tasks uses raw AsyncPG queries

caution

Schema changes must only be made in aiqlick-backend/prisma/schema.prisma. Never modify the database schema from background-tasks.

Extensions

• pgvector — Vector similarity search for AI matching (1024-dim Titan embeddings)

Backups

• Automated RDS snapshots
• Manual backups to s3://aiqlick-postgres-backups/

Useful Commands

# Check RDS status
aws rds describe-db-instances --profile Administrator-842697652860 --region eu-north-1 \
  --query 'DBInstances[].{ID:DBInstanceIdentifier,Status:DBInstanceStatus,Class:DBInstanceClass}' \
  --output table