Letterbook Docs
Connect PostgreSQL
Use PostgreSQL data to answer account, subscription, and usage questions.
Last updated June 17, 2026
What this guide covers
Connect PostgreSQL with least-privilege access so Letterbook can look up support-safe customer data.
Setup steps
- Create a read-only database role
- Restrict access to support-safe tables or views
- Add network access for Letterbook
- Map customer identifiers
- Test a customer lookup
Configuration details
- Connection string format
- SSL requirements
- IP allowlist requirements
- Recommended views for sensitive schemas
- How to rotate credentials