Nile Db

Nile Database is Postgres with multi-tenancy built into the platform — rather than bolting tenant isolation onto a single Postgres instance, Nile provides virtual databases per tenant, tenant-aware row-level security, and placement control (which region each tenant's data lives in). For agents in SaaS backends: provision a new tenant with one API call, run tenant-scoped queries using the nile.tenantId session variable, and manage tenant lifecycle (suspend, delete) programmatically. Standard Postgres connection string means existing Postgres tooling works. New service (launched 2024); monitor stability as it matures. Confidence is docs-derived.

Two access patterns: (1) REST API (thenile.dev/v1): POST /workspaces/{workspace}/databases/{db}/tenants creates a new tenant. GET /workspaces/{workspace}/databases/{db}/tenants lists all tenants. DELETE /workspaces/{workspace}/databases/{db}/tenants/{id} removes a tenant. (2) Postgres connection: standard libpq connection string; set SET nile.tenantId = '{tenant_uuid}' to scope queries to a tenant. All tables with tenant_id column automatically isolated per tenant. Management operations (tenant CRUD, placement) via REST API; data operations via Postgres.

REST API: Bearer token auth (Authorization: Bearer {token}). Tokens from Nile Console → Settings → Credentials. Postgres connection: standard libpq credentials (host, database, user, password) from Nile Console → Connection String. HTTPS enforced for REST API; TLS for Postgres connections. No OAuth2. Workspace-scoped API tokens. Row-level security enforced by nile.tenantId session variable for data isolation.

REST API: standard HTTP status codes with JSON error bodies. 401 for invalid token, 404 for missing tenant, 409 for duplicate tenant. Postgres: standard psql error codes. Tenant isolation: if nile.tenantId is not set, queries run against all tenants (admin context). Nile is serverless — no connection pool management needed. Nile service uptime at status.thenile.dev. Being a newer service, review changelog for stability changes. Standard Postgres drivers (pg, psycopg2, etc.) work without modification.

thenile.dev/docs provides getting-started guide, REST API reference, Postgres integration guide, and multi-tenancy concept documentation. Getting started: create Nile account (free tier), create a database, provision first tenant via API or console, connect via psql in under 10 minutes. Node.js/Python/Go connection examples. Active development team; Discord community for support and feedback. Open beta stage — features being actively added.