Database

import { Naive } from "@usenaive-sdk/server";
const naive = new Naive({ apiKey: process.env.NAIVE_API_KEY! });

// 1. Your own project — the account's default user
await naive.database.query("select now()");

// 2. A specific end-user's project (multi-tenant SaaS)
const alice = await naive.users.create({ external_id: "alice" });
await naive.apps.create({ name: "Alice Workspace", type: "fullstack" }); // default user
await naive.forUser(alice.id).apps.create({ name: "Alice App", type: "fullstack" });
await naive.forUser(alice.id).database.query("select count(*) from profiles");

// Arbitrary SQL — SELECT, INSERT/UPDATE/DELETE, and DDL
await naive.database.query("create table notes (id serial primary key, body text)");
const rows = await naive.database.query("select * from notes order by id desc limit 10");

// Target a specific app when the user has several
await naive.database.query("select 1", { appId: "app-uuid" });

// List tables with row counts
const { tables } = await naive.database.tables();

const notes = naive.database.from("notes");
await notes.insert({ body: "hello" });
await notes.select("id,body", "order=id.desc&limit=5");
await notes.update({ body: "edited" }, "id=eq.1");
await notes.delete("id=eq.1");

await naive.database.migrate(
  "alter table notes add column created_at timestamptz default now()",
);

# SQL
curl -X POST https://api.usenaive.ai/v1/apps/<app-id>/db/query \
  -H "Authorization: Bearer nv_sk_live_..." -H "Content-Type: application/json" \
  -d '{"sql": "select now()"}'

# REST
curl "https://api.usenaive.ai/v1/apps/<app-id>/db/rest/notes?select=*" \
  -H "Authorization: Bearer nv_sk_live_..."