Database

The aura-db service exposes a generic CRUD on top of a PostgreSQL 16: each project has its own database, hosted on your organization's PostgreSQL cluster (a cluster entirely dedicated to a single project on the enterprise offer). Each SDK call is translated into native SQL via a thin layer that respects the RLS policies injected into the session.

You can also bypass the SDK and point Prisma, Drizzle, Kysely or psql directly to the connection string — we expose the standard port 5432 with PostgreSQL wire protocol.

Under the hood, the SDK serializes your .from().select()… calls into an HTTP request to aura-db which delegates to a PostgREST sidecar. PostgREST translates to SQL and opens a pooled connection via PgBouncer with the search_path of the injected project.

SDK        → HTTPS    GET /v1/db/sensors?select=id,name
Gateway    → aura-db  Vérification de session & Routage
aura-db    → PgBouncer → PostgreSQL 16

# Connection with search_path project
SET LOCAL search_path = project_a7f3_, public;
SET LOCAL request.jwt.claims = '{ "sub": "u_9k2", "tenant": "t_4c" }';
SELECT id, name, temperature FROM sensors WHERE active = true LIMIT 50;

Schema-per-project

Partitioning applied by PostgreSQL: no tenant_id column, one connection role per project, rights never opened to PUBLIC.

§ foundation

Versioned migrations

Versioned SQL, atomic rollback, zero-downtime. TypeScript types regenerate with each migration.

§ migration

Codegen TypeScript

Automatic generation of types for tables, views, enums and RPC functions during each migration.

§ typing

Native EPIRB

Testable declarative policies. The SDK injects the claim tenant into each connection.

§ security

Premium extensions

pgvector, PostGIS, pg_cron, TimescaleDB, PGMQ, pg_partman. Fixed versions, audits.

§ extensions

Branch previews

An ephemeral database by PR, with cloned seed data and unique URL — roadmap, not yet delivered.

§ roadmap

The four basic operations share the same .from(table)surface. Returned types are inferred from your schema — open your IDE, autocomplete works on columns, joins and returns.

// List the last 50 active sensors
const { data, error } = await aura
  .from('sensors')
  .select('id, name, temperature, location!inner(city)')
  .eq('active', true)
  .order('captured_at', { ascending: false })
  .limit(50)

Activated in one click from the Studio. Fixed versions, coordinated updates, shared security audit.

pgvector 0.7

PostGIS 3.5

pg_cron 1.6

TimescaleDB 2.17

PGMQ 1.4

pg_partman 5.1

pg_stat_statements

pgcrypto

citext

uuid-ossp

hstore

ltree

pg_trgm

an accent