Developers
PostgreSQL
Relational store for auth, RBAC, audit logs, and cost tracking.
PostgreSQL
Relational database for structured data requiring ACID guarantees.
Use Cases
| Table | Purpose |
|---|---|
users |
Auth credentials, roles, MFA status |
sessions |
JWT token metadata, expiry |
audit_logs |
Immutable security events |
invocations |
LLM call audit trail |
costs |
Per-tenant daily/monthly spend |
Configuration
- Engine: Amazon RDS PostgreSQL 15
- Instance: db.r6g.large (prod), db.t3.medium (dev)
- Multi-AZ: Enabled (prod)
- Backup: Daily, 7-day retention
- Encryption: AES-256 at rest, TLS in transit