Database schemas

Ionize uses five PostgreSQL databases. Four are owned by Ory (Kratos and Hydra, per-domain); one (ionize) is owned by the Ionize SDK.

Databases

ionize tables

The SDK-owned tables, each documented on its own page:

• ciam_settings — Key-value settings vault for the CIAM domain. Encrypted values use the v2: prefix.
• iam_settings — Same schema as ciam_settings, but for the IAM domain.
• locations — Login location history per session.
• login_attempts — Recent login attempts, used by the brute-force protection logic.
• lockouts — Active and historical brute-force lockouts.
• security_audit — Audit log of security-relevant events.

Connection

All connections use sslmode=verify-full in production. See Deploy — Database SSL verify-full.