Skip to main content

Examples

Blog Application

Posts with Categories

# Create category model
brizzle model category name:string slug:string:unique

# Create posts with full CRUD UI
brizzle scaffold post title:string slug:string:unique body:text published:boolean categoryId:references:category

# Create comments
brizzle scaffold comment content:text authorName:string postId:references:post

Tags (Many-to-Many)

# Tags
brizzle model tag name:string:unique

# Join table
brizzle model postTag postId:references:post tagId:references:tag

E-Commerce

Products and Orders

# Products
brizzle scaffold product name:string description:text? price:decimal sku:string:unique inStock:boolean

# Orders
brizzle scaffold order status:enum:pending,paid,shipped,delivered total:decimal customerEmail:string

# Order items (resource - no UI needed)
brizzle resource orderItem orderId:references:order productId:references:product quantity:integer price:decimal

User Management

Users with Sessions

# Users
brizzle scaffold user email:string:unique name:string role:enum:admin,user passwordHash:string

# Sessions (backend only)
brizzle resource session token:uuid:unique userId:references:user expiresAt:datetime --uuid

API-First Application

External Webhooks

# Webhooks API
brizzle api webhook url:string secret:string:unique events:json active:boolean

# Webhook deliveries (for logging)
brizzle resource webhookDelivery webhookId:references:webhook payload:json responseCode:integer? responseBody:text? deliveredAt:datetime?

Content Management

Pages with Metadata

# Pages
brizzle scaffold page title:string slug:string:unique content:text metaTitle:string? metaDescription:text? publishedAt:datetime?

# Media library
brizzle scaffold media filename:string url:string mimeType:string size:integer alt:text?

Audit Logging

# Audit logs (no UI, just for querying)
brizzle resource auditLog action:enum:create,update,delete entityType:string entityId:integer userId:references:user changes:json ipAddress:string? userAgent:text?

Full Example: Task Manager

# Users
brizzle scaffold user email:string:unique name:string avatarUrl:string?

# Projects
brizzle scaffold project name:string description:text? ownerId:references:user

# Tasks
brizzle scaffold task title:string description:text? status:enum:todo,in_progress,done priority:enum:low,medium,high dueDate:date? projectId:references:project assigneeId:references:user?

# Comments on tasks
brizzle scaffold taskComment content:text taskId:references:task authorId:references:user

# Project members (join table)
brizzle resource projectMember projectId:references:project userId:references:user role:enum:viewer,editor,admin

After running these commands:

  1. Push the schema to your database:

    pnpm db:push
  2. Start the dev server:

    pnpm dev
  3. Visit the generated pages:

    • /users - User management
    • /projects - Project management
    • /tasks - Task management
    • /task-comments - Task comments