Skip to content
CIQRA
All postsEngineering

Multi-tenant isolation, done right

The CIQRA teamJun 30, 20265 min read

Multi-tenancy is a promise: your store's data is yours, and no one else's request can reach it. The hard part is keeping that promise when application code is complex and changing daily.

Enforce it where it can't be bypassed

CIQRA scopes every tenant table with PostgreSQL row-level security, keyed to the tenant resolved from the request. The database itself refuses to return another tenant's rows — even if a query in application code forgets a filter. Isolation lives below the code, not inside it.

Prove it on every change

Guarantees you don't test are just hopes. A cross-tenant leak-test suite runs as a merge gate: if a change could let one store's data reach another, the build fails and the merge is blocked. Isolation becomes something we verify continuously, not something we assume.

Defense in depth

Row-level security is the floor, not the ceiling: field-level encryption with per-tenant keys, secrets in a managed key vault, and tenant-scoped auth all stack on top. The result is trust you can point to — the default on every plan.

Start building on CIQRA

Spin up a store in minutes. Bring your own gateway or turn on CIQRA Pay — your data stays in the EU.