Postgres,
没有 家务活。
A dedicated Postgres database per project, schema-isolated, with native RLS, versioned migrations, and auto-generated TypeScript types. No proprietary abstractions, zero lock-in.
import { aura } from '@/lib/aurabase'export async function GET() {const { data, error } = await aura.from('devices').select('id, name, temperature, last_seen').eq('tenant_id', tenantId).order('last_seen', { ascending: false }).limit(50)// Server-enforced RLS — tenantId is in the JWTreturn Response.json({ data })}
从第一分钟开始你得到的一切
Schema-per-project
Strict logical isolation: each project gets a dedicated Postgres schema. No shared row-level tenant, no intermediary proxy.
Versioned migrations
Version-controlled SQL, atomic rollbacks, zero-downtime online DDL. TypeScript types regenerate automatically on every migration.
TypeScript codegen
Comprehensive end-to-end types for your tables, views, functions, and relations. Full inference on joins and filters.
Row-Level Security
Declarative, testable policies. The SDK injects the tenant claim into every request — impossible to bypass from the client side.
Premium extensions
pgvector, PostGIS, pg_cron, TimescaleDB, PGMQ, and pg_partman enabled in one click. Pinned versions, available security audits.
Branch previews (roadmap)
One ephemeral database per pull request, cloned seed data, unique preview URL — roadmap feature, coming soon.
一个项目,四个独立的模式
每个项目都会收到四个 Postgres 子模式:一个用于您的应用程序表,三个用于平台原语,位于您组织的 PostgreSQL 集群上的专用数据库中。隔离由 PostgreSQL 强制执行:每个项目都有自己的连接角色,并且模式权限仅授予它。在企业计划中,项目还可以接收自己的完全专用的集群。
project_{uuid}userYour business tables∞project_{uuid}_authsystemusers, sessions, oauth_accounts, mfa_factors, refresh_tokens14project_{uuid}_storagesystembuckets, objects, rls_policies, upload_sessions6project_{uuid}_platformsystemfunctions, jobs, cron_jobs, api_keys, webhooks9在生产中、实际负载下测量
Aurabase · Supabase · Firebase
常见问题
Is this real Postgres, or a proprietary layer?+
pg_dump 为您提供完整的数据库,包括扩展,无需锁定。How does schema-per-project isolation work?+
项目_ (你的桌子), ..._auth, ..._存储, ..._平台。网关注入 搜索路径 每个连接中的查询实际上不能跨越另一个项目的边界。Can I use my ORMs (Prisma, Drizzle, Kysely)?+
What about performance under heavy production loads?+
How do I migrate from Supabase or Firebase?+
光环导入——来自supabase 导入您的架构、RLS 策略和存储桶。来自 Firebase:我们的 CLI 将 Firestore 集合映射到 JSONB Postgres 表并将安全规则重写为策略。一般项目预计需要 1-2 小时。