Quickstart: Build a Todo App

Build a working CRUD app with Allyourbase in a few minutes.

1. Start AYB

# Install
curl -fsSLo /tmp/ayb-install.sh https://install.allyourbase.io/install.sh
sh /tmp/ayb-install.sh

# Start with managed PostgreSQL (zero config)
ayb start

AYB starts in detached mode and is available at http://127.0.0.1:8090.

If this is your first run and admin.password is unset, startup prints a generated admin password and a reset hint:

To reset: ayb admin reset-password

Optional readiness check:

curl http://127.0.0.1:8090/health

2. Create a todos table

Open another terminal and create the table:

ayb sql "CREATE TABLE todos (
  id SERIAL PRIMARY KEY,
  title TEXT NOT NULL,
  completed BOOLEAN DEFAULT false,
  created_at TIMESTAMPTZ DEFAULT now()
)"

Or create it via the admin dashboard at http://127.0.0.1:8090/admin.

3. Set up the project

mkdir todo-app && cd todo-app
npm init -y
npm install @allyourbase/js

4. Write the app

Create index.mjs:

import { AYBClient } from "@allyourbase/js";

const ayb = new AYBClient("http://127.0.0.1:8090");

// Create todos
await ayb.records.create("todos", { title: "Buy groceries" });
await ayb.records.create("todos", { title: "Write docs", completed: true });
await ayb.records.create("todos", { title: "Ship v1" });

// List all todos
const { items: all } = await ayb.records.list("todos", {
  sort: "-created_at",
});
console.log("All todos:", all);

// Filter: only incomplete
const { items: pending } = await ayb.records.list("todos", {
  filter: "completed=false",
});
console.log("Pending:", pending);

// Update: mark one as done
const todo = pending[0];
await ayb.records.update("todos", String(todo.id), { completed: true });
console.log(`Marked "${todo.title}" as done`);

// Delete
await ayb.records.delete("todos", String(todo.id));
console.log(`Deleted "${todo.title}"`);

// Final state
const { items: final } = await ayb.records.list("todos");
console.log("Remaining:", final);

5. Run it

node index.mjs

Output:

All todos: [ { id: 3, title: 'Ship v1', ... }, { id: 2, title: 'Write docs', ... }, { id: 1, title: 'Buy groceries', ... } ]
Pending: [ { id: 3, title: 'Ship v1', completed: false }, { id: 1, title: 'Buy groceries', completed: false } ]
Marked "Ship v1" as done
Deleted "Ship v1"
Remaining: [ { id: 2, title: 'Write docs', ... }, { id: 1, title: 'Buy groceries', ... } ]

6. Add realtime

Subscribe to changes from another process:

import { AYBClient } from "@allyourbase/js";

const ayb = new AYBClient("http://127.0.0.1:8090");

const unsubscribe = ayb.realtime.subscribe(["todos"], (event) => {
  console.log(`[${event.action}]`, event.record);
});

console.log("Listening for todo changes... (Ctrl-C to stop)");
// Keep the process alive
await new Promise(() => {});

Now create/update/delete todos in another terminal or via the admin dashboard and watch the events stream in.

Next steps

• Authentication — Add user auth and per-user todos with RLS
• File Storage — Attach files to your records
• Deployment — Deploy to production with Docker or bare metal