Productivity

Todo App

Personal tasks with priorities (low/medium/high), due dates, done toggle. Each user sees only their own todos.

authowner-scopedenums

One-click setup

Spin up this backend in one click.

We create the project, apply the schema, and drop you in the dashboard. If you’re not signed in yet, you’ll sign up first — the template applies the moment you land. Free.

Project name

What you get

Email/password signup and login on the users table
Each user only sees their own todos (owner_field: user_id)
Priority enum (low/medium/high) and optional due date
Endpoints live the moment the schema applies

Schema

Copy and apply with PUT /v1/schema or set_schema via MCP. MoonDB auto-creates 2 tables: users, todos.

todo.schema.json

{
  "tables": {
    "users": {
      "auth_table": true,
      "columns": {
        "display_name": "string"
      }
    },
    "todos": {
      "columns": {
        "title": "string required max_length 200",
        "done": "bool default false",
        "due_date": "date",
        "priority": {
          "type": "enum",
          "values": [
            "low",
            "medium",
            "high"
          ],
          "default": "medium"
        },
        "user_id": "ref users required"
      },
      "owner_field": "user_id",
      "access": {
        "read": "owner",
        "create": "authenticated",
        "update": "owner",
        "delete": "owner"
      }
    }
  }
}

Auto-generated endpoints

The moment the schema applies, this REST surface is live (replace {project_id} with the id returned by POST /v1/projects):

live endpoints

GET    /api/users                  list/filter/sort/paginate
GET    /api/users/{id}             read one
POST   /api/users                  create
PATCH  /api/users/{id}             partial update
DELETE /api/users/{id}             delete
POST   /api/users/bulk             atomic bulk insert
POST   /auth/signup                 (from this auth_table)
POST   /auth/login                  (from this auth_table)
GET    /auth/me                     Bearer {token}

GET    /api/todos                  list/filter/sort/paginate
GET    /api/todos/{id}             read one
POST   /api/todos                  create
PATCH  /api/todos/{id}             partial update
DELETE /api/todos/{id}             delete
POST   /api/todos/bulk             atomic bulk insert

Plus auto-generated /v1/openapi.json (OpenAPI 3.0.3) and /v1/llm-context (machine-readable agent reference) for any client generator or coding agent.

Prefer to wire it up by hand instead of the one-click button up top? The options below apply the same schema manually — pick whichever fits your workflow.

Apply via REST

terminal

# 1. create the project
curl -X POST https://api.moondb.ai/v1/projects \
  -H "X-API-Key: mk_..." \
  -H "Content-Type: application/json" \
  -d '{"name":"todo"}'

# 2. apply the template schema
curl -X PUT https://api.moondb.ai/p/{project_id}/v1/schema \
  -H "X-Admin-Key: sk_..." \
  -H "Content-Type: application/json" \
  -d @todo.schema.json

Apply via MCP

If your agent has the MoonDB MCP server installed (see install), one tool call applies the template:

tools/call set_schema

# call set_schema via MCP (Cursor, Claude Code, Windsurf)
{ "jsonrpc": "2.0", "id": 1, "method": "tools/call",
  "params": { "name": "set_schema", "arguments": {
    "project_id": "...",
    "schema": {
        "tables": {
            "users": {
                "auth_table": true,
                "columns": {
                    "display_name": "string"
                }
            },
            "todos": {
                "columns": {
                    "title": "string required max_length 200",
                    "done": "bool default false",
                    "due_date": "date",
                    "priority": {
                        "type": "enum",
                        "values": [
                            "low",
                            "medium",
                            "high"
                        ],
                        "default": "medium"
                    },
                    "user_id": "ref users required"
                },
                "owner_field": "user_id",
                "access": {
                    "read": "owner",
                    "create": "authenticated",
                    "update": "owner",
                    "delete": "owner"
                }
            }
        }
    }
  } } }

Prompt your agent

Or just paste this one-liner into Cursor / Claude Code / Lovable after the MoonDB prompt is in .cursorrules / CLAUDE.md:

prompt

Apply the MoonDB "Todo App" template — users (auth_table) + todos with title, done, due_date, priority enum, owner-scoped.

Extending the template

Send the full updated schema (with your additions) to PUT /v1/schema — MoonDB diffs against the current version and auto-migrates. Destructive changes (dropping columns, narrowing enums, renaming) require "confirm_destructive": true in the body. Read more about schema updates →

Ship this in 30 seconds

Get an API key

Related templates

Content