Database

Data model

Each document is free-form. You define the fields. There's no fixed schema. Every document gets three system-managed fields:

• _id: auto-generated UUID, unique within the collection
• _created_at: ISO 8601 timestamp set on insert
• _updated_at: ISO 8601 timestamp set on every write

# Every document has these system fields alongside your own data:
{
    "order_id": "ORD-001",
    "status":   "pending",
    "amount":   99.50,
    "_id":         "550e8400-e29b-41d4-a716-446655440000",  # auto-generated UUID
    "_created_at": "2026-01-15T10:30:00Z",
    "_updated_at": "2026-01-15T10:30:00Z",
}

Auto-creation

You never need to create a collection explicitly. The first call to db_insert or db_upsert creates the collection.

# No setup needed - the collection "orders" is created automatically
# the first time db_insert or db_upsert writes to it
result = await db_insert("orders", {
    "order_id": "ORD-001",
    "customer": "alice@example.com",
    "amount":   99.50,
    "status":   "pending",
})

You can also create collections manually from the Storage → Database tab in the dashboard.

Dashboard

The Storage → Database tab in the project dashboard lets you:

• View all collections with document counts and storage sizes
• Browse documents with filter and sort controls
• Generate filters and sort order from plain-language requests
• Insert documents manually
• View the inferred schema: field names, types, and fill rates
• Create and delete collections