One command.Full stack. Running.

import { d } from '@vertz/db';

const users = d.table('users', {
  id:    d.uuid().primary({ generate: 'uuid' }),
  name:  d.text(),
  email: d.email().unique(),
});

const todos = d.table('todos', {
  id:     d.uuid().primary({ generate: 'uuid' }),
  title:  d.text(),
  done:   d.boolean().default(false),
  userId: d.uuid(),
});

export const todosModel = d.model(todos, {
  user: d.ref.one(() => users, 'userId'),
});

import { entity } from '@vertz/server';
import { todosModel } from './schema';

export const todos = entity('todos', {
  model: todosModel,
  access: {
    list:   (ctx) => ctx.authenticated(),
    create: (ctx) => ctx.authenticated(),
    update: (ctx, row) => ctx.userId === row.userId,
    delete: (ctx, row) => ctx.userId === row.userId,
  },
  before: {
    create: (data, ctx) => ({ ...data, userId: ctx.userId }),
  },
});
// GET  /api/todos     — auto-generated
// POST /api/todos     — auto-generated
// GET  /api/openapi   — auto-generated

import { query, form } from '@vertz/ui';
import { api } from './generated/client';

export function TodoList() {
  const todos = query(api.todos.list());
  const todoForm = form(api.todos.create, {
    onSuccess: () => todos.refetch(),
  });

  return (
    <form onSubmit={todoForm.onSubmit}>
      <input name="title" placeholder="What needs to be done?" />
      <button type="submit">Add</button>
      {todos.data.map((t) => (
        <li key={t.id}>{t.title}</li>
      ))}
    </form>
  );
}