] mg login --url [--email ] [--password

] mg projects mg projects create --name --slug mg env list --project mg env create --project --name [--production] mg env delete --project --name --yes Schema & keys mg collections list --project --env mg collections create --project --env --name [--columns "title:text,done:boolean!,code:text^"] (! = NOT NULL, ^ = UNIQUE) [--owner-column ] [--permission-column ] mg collections delete --project --env --name --yes mg keys list --project --env mg keys create --project --env --type [--name ] [--functions "fnA,fnB"] (required for --type function) mg keys revoke --project --env --id --yes Functions & types mg functions list --project --env mg functions push --project --env --file [--name ] mg functions delete --project --env --name --yes mg types --project --env [--out ] ``` - Deletes require `--yes`. Production environments/collections are protected server-side. - Config lives at `~/.manggaleh/config.json` (override with `MANGGALEH_CONFIG`). - `mg functions push` upserts by name. `mg types` emits one `interface` per collection plus a `Collections` map. --- ## 3. SDK (`@manggaleh/sdk`) Framework-agnostic (browser or Node 18+; needs global `fetch` + `WebSocket`). ```bash npm install @manggaleh/sdk ``` ### Create one client per project + environment ```ts import { createClient } from "@manggaleh/sdk"; export const client = createClient({ baseUrl: "https://api.manggaleh.com", // API origin (no trailing slash needed) tenant: "acme", // project slug env: "dev", // "dev" | "staging" | "prod" (default "prod") apiKey: "mgpk_xxx", // publishable for browser, service for server // storage: tokenStorage, // persist the session across reloads (see Gotchas) }); ``` ### End-user auth ```ts const { user } = await client.auth.signUp({ email, password, name, /* code? */ }); await client.auth.signIn({ email, password }); await client.auth.signOut(); const session = await client.auth.getSession(); // SessionResult | null ``` The session token is captured & attached automatically. Auth is **per environment**. ### Data API (CRUD) ```ts interface Todo { id: string; title: string; done: boolean; created_at: string } const todos = client.data.from("todos"); const created = await todos.insert({ title: "Buy milk", done: false }); // returns full row const one = await todos.get(created.id); // null (not error) when missing const updated = await todos.update(created.id, { done: true }); // partial patch await todos.remove(created.id); // -> void const rows = await todos.list(); // one page (default 50, server max 200) ``` ### Query: filter / sort / paginate / embed ```ts const open = await todos.list({ filters: { done: false, title: "ilike.%milk%", priority: "gte.3" }, // plain value = eq order: "created_at.desc", // add ".desc" for descending limit: 50, // capped at 200 }); // Cursor pagination + optional total const p1 = await todos.page({ limit: 20, count: true }); // { data, nextCursor, count } if (p1.nextCursor) await todos.page({ limit: 20, cursor: p1.nextCursor }); // Projection + embed one-level FK relations await client.data.from("orders").list({ select: ["id", "total", "customer_id"], // id always included embed: ["customer(name,phone)"], // FK value replaced by the related row }); ``` **Filter operators:** plain value = `eq`; `gt`/`gte`/`lt`/`lte`; `like`/`ilike` (`ilike.%x%`); `in.a,b,c` / `nin.x,y`; `is.null` / `is.notnull`. Filtering & sorting run on the server over the whole dataset. ### Transactions (ACID — all or nothing) ```ts const results = await client.tx([ { op: "update", collection: "accounts", id: a, patch: { balance: 75 } }, { op: "update", collection: "accounts", id: b, patch: { balance: 25 } }, { op: "insert", collection: "ledger", values: { from: a, to: b, amount: 25 } }, // ops: "insert" | "update" | "delete" | "get" ]); // results[i].data (row) or results[i].deleted (for delete) ``` A tx is a *fixed list* — you can't read-then-branch mid-transaction. For that, use a Function. ### Storage (files) ```ts const obj = await client.storage.upload(file, { name: "receipt.pdf" }); // file: Blob/File const list = await client.storage.list(); const blob = await client.storage.download(obj.id); await client.storage.remove(obj.id); ``` Owner/ABAC-scoped by RLS — safe from the browser with a publishable key. (`permissions` tags on upload only apply with a service key.) ### Functions (call server-side logic) ```ts const { top } = await client.functions.invoke("topProducts", { n: 10 }); ``` - From the **browser**: publishable key **+ signed-in user** → runs as that user (RLS applies). - From a **server**: service key → admin (bypasses RLS). - A **function-scoped key** (`mgfk_`) may only invoke its allowlisted functions. ### Realtime ```ts const unsub = client.realtime.subscribe("todos", async (e) => { // e = { type: "change", schema, collection, op, id } — NO row data! if (e.op === "delete") { removeFromUI(e.id); return; } const row = await todos.get(String(e.id)); // refetch (also runs through RLS) if (row) upsertInUI(row); }); // later: unsub(); ``` Auto-reconnects. `e.id` may be a number → `String(e.id)` before `get`. ### Live data + optimistic updates (`.live()`) Don't want to hand-write the subscribe→refetch→merge loop above? `from(c).live()` returns an opt-in store that does it for you **and** applies mutations optimistically (instant UI, automatic rollback on failure). `subscribe`/`getSnapshot` match React's built-in `useSyncExternalStore` — no extra dependency; Zustand is an optional wrapper. ```ts const todos = client.data.from("todos").live({ order: "created_at.desc" }); // React: const list = useSyncExternalStore(todos.subscribe, todos.getSnapshot); useEffect(() => () => todos.close(), []); // stop realtime on unmount await todos.insert({ title }); // appears instantly → swapped for the server row await todos.update(id, { done: true }); // toggles instantly → reverts if the server rejects await todos.remove(id); // disappears instantly → comes back on failure ``` `live()` is additive: it reuses `list()`/`get()`/realtime under the hood and changes nothing about the existing APIs. Also exported: `createLiveCollection`, `LiveCollection`, `LiveOptions`. ### Email (server-side, service key required) ```ts const admin = createClient({ baseUrl, tenant, env, apiKey: process.env.MG_SERVICE_KEY }); await admin.notifications.email.send({ to: "customer@example.com", subject: "Receipt", html: "

Thanks!