x-tenant-id: <your-tenant-uuid>

// Nile SDK handles authentication automatically
const tenantNile = nile.getInstance({
  tenantId: 'tenant-uuid',
  userId: 'user-uuid',
  api: {
    token: cookies.get('nile.session-token')?.value,
  },
});

curl -X GET "https://api.domain/games/wheel/profiles" \
  -H "x-tenant-id: 00000000-0000-0000-0000-000000000000" \
  -H "Authorization: Bearer your-api-key"

-- All tables have tenant_id foreign key
CREATE TABLE profiles (
  id_profile UUID PRIMARY KEY,
  tenant_id UUID NOT NULL REFERENCES tenants(id),
  ...
);

const db = await getTenantDb('tenant-uuid');
const profiles = await db.query('SELECT * FROM profiles');
// Automatically scoped to tenant - no WHERE clause needed!

# Via psql
psql <connection-string>
INSERT INTO tenants (id, name) VALUES ('your-uuid', 'Your Company');

# Via Nile SDK
const tenant = await nile.api.tenants.createTenant({
  name: 'Your Company',
});

const tenants = await nile.db.query(
  'SELECT id, name FROM tenants ORDER BY name'
);

postgres://<user>:<password>@<host>/<database>

postgres://0199f19f-2258-7fbd-8cbe-cfb258318f2d:[email protected]/sendsational

DATABASE_NILEDB_USER="0199f19f-2258-7fbd-8cbe-cfb258318f2d"
DATABASE_NILEDB_PASSWORD="c419a214-33ba-4086-9830-c34f91feea0d"
DATABASE_NILEDB_API_URL="https://us-west-2.api.thenile.dev/v2/databases/<db-id>"
DATABASE_NILEDB_POSTGRES_URL="postgres://us-west-2.db.thenile.dev/sendsational"

const nile = await NileServer({
  user: '0199f19f-2258-7fbd-8cbe-cfb258318f2d',
});

const nile = await NileServer({
  // Reads from DATABASE_NILEDB_* env variables
});

const nile = await NileServer({
  secureCookies: process.env.VERCEL === '1', // HTTPS only in prod
});

// Verify user has access to tenant
const hasAccess = await nile.api.tenants.getUserTenants(userId);
if (!hasAccess.find(t => t.id === tenantId)) {
  throw new Error('Unauthorized');
}

import NileServer from '@niledatabase/server';

// 1. Initialize Nile
const nile = await NileServer({
  debug: true,
  secureCookies: process.env.VERCEL === '1',
});

// 2. Get user from session
const user = await nile.api.users.me();

// 3. Get user's tenants
const tenants = await nile.api.users.getUserTenants(user.id);

// 4. Select tenant (or from cookie)
const selectedTenant = tenants[0].id;

// 5. Create tenant-scoped instance
const tenantNile = nile.getInstance({
  tenantId: selectedTenant,
  userId: user.id,
  api: {
    token: cookies.get('nile.session-token')?.value,
  },
});

// 6. Query tenant data
const profiles = await tenantNile.db.query('SELECT * FROM profiles');

DEFAULT_TENANT_ID="00000000-0000-0000-0000-000000000000"

INSERT INTO tenants (id, name) VALUES 
  ('00000000-0000-0000-0000-000000000000', 'Test Tenant');

SELECT * FROM tenants WHERE id = 'your-tenant-uuid';

echo $DATABASE_NILEDB_USER
echo $DATABASE_NILEDB_PASSWORD

psql <your-connection-string>