Security as theprimary surface
SOFI is a governance product first, a query engine second. Every control listed here is enforced in the request path — not added later by a separate tool. Read the controls, then talk to us about the gaps.
Four surfaces, one consistent line
Identity, data, infrastructure, compliance — each with explicit controls instead of marketing.
Identity
JWT (HS256, 15min access + 7d refresh, rotation, blacklist) + API keys (sgk_ prefix, scoped). Optional SSO via SAML / OIDC on Pro and Enterprise.
Data
AES-256-GCM encryption for datasource credentials with key rotation. PII masking runs in the query path. Zero-copy by default — your data never leaves your sources.
Infrastructure
PostgreSQL Row-Level Security on every tenant table. Docker no-new-privileges + read-only filesystem. Nginx WAF blocks scanners, .env / .git, and SQL injection patterns.
Compliance
LGPD-aligned controls today (DPIA, RoPA, DSR exports). SOC2 Type 2 and ISO 27001 on the 2026 roadmap. Custom security review available on Enterprise.
The actual line items
Every control we ship today, grouped by surface. No 'available on roadmap' hidden inside.
Identity
- Token rotationrotate-on-refresh + Redis blacklist on logout
- Account lockout5 failed logins → 15-minute lockout
- Rate limiting/register 5/h · /login 10/min
- API keyssgk_ prefix · per-scope · revocable · audited
- RBAC rolesadmin · data_steward · analyst · viewer
- SSOSAML, OIDC (Okta, Azure AD, Google) on Pro+
Data
- Source credentialsAES-256-GCM encrypted at rest with rotation
- PII maskingPer-column · per-role · runs in query pipeline
- Soft-deletedeleted_at · audited · no hard DELETE
- Audit retention30d (Starter) · 12mo (Pro) · custom (Enterprise)
- LineageColumn-level · queryable · DSR-ready
- CacheOpt-in per view · per-tenant · PII-aware
Infrastructure
- Tenant isolationPostgreSQL RLS on every tenant_id table
- Container hardeningno-new-privileges + read-only fs
- Reverse proxy WAFNginx blocks .env/.git, SQLi patterns, scanners
- TLSLet's Encrypt + auto-renewal · TLS 1.2+
- CSP + Permissions-PolicyStrict default · per-route overrides
- Production hygiene/docs and /metrics restricted in prod
Three places SOFI runs
Pick the perimeter. The product surface is identical across deployments.
Managed cloud
Multi-tenant SOFI cloud, RLS-isolated. Fastest to start. Available on Starter and Pro.
Private VPC
Single-tenant SOFI in your AWS / GCP / Azure account. Available on Enterprise.
On-prem / air-gapped
Terraform + helm install in your data center. No outbound calls. Enterprise only.
What's shipped, what's coming
Every control we hold today and the dates we expect for the rest.
What CISOs and DPOs ask first
Plain answers. If your security team needs something not listed, ask — we usually answer in a day.
By default, nowhere on SOFI — virtualization is zero-copy. Cache (opt-in per view) lives in Redis next to the SOFI service in your chosen region. On Enterprise you pick the region; on Pro/Starter we run in São Paulo (sa-east-1).
// security review on demand
Send your security questionnaire — we answer in a week.
Enterprise plans include a custom security review and architect-led rollout. Most teams clear procurement in 14 days.