Turn prompts into
structured code templates.

// app/billing/page.tsx
// ForgeFlow example: "SaaS billing dashboard" (written by the ForgeFlow team)
// getBillingSummary and listInvoices are small helpers you write against the schema.
import Link from "next/link";
import { getBillingSummary, listInvoices } from "@/lib/billing";

export const metadata = { title: "Billing" };

const money = (cents: number, currency: string) =>
  new Intl.NumberFormat("en-US", { style: "currency", currency }).format(cents / 100);

export default async function BillingPage() {
  const [summary, invoices] = await Promise.all([
    getBillingSummary(),
    listInvoices({ limit: 10 }),
  ]);
  const seatPct = Math.round((summary.seatsUsed / summary.seatsIncluded) * 100);

  return (
    <main className="mx-auto max-w-5xl space-y-8 p-6">
      <header className="flex items-center justify-between">
        <h1 className="text-2xl font-semibold tracking-tight">Billing</h1>
        <Link href="/billing/plans" className="rounded-lg border px-3 py-2 text-sm hover:bg-gray-50">
          Change plan
        </Link>
      </header>

      <section className="grid gap-4 sm:grid-cols-3">
        <div className="rounded-xl border bg-white p-4">
          <p className="text-sm text-gray-500">Current plan</p>
          <p className="mt-1 text-lg font-semibold">{summary.planName}</p>
        </div>
        <div className="rounded-xl border bg-white p-4">
          <p className="text-sm text-gray-500">Seats</p>
          <p className="mt-1 text-lg font-semibold">
            {summary.seatsUsed} / {summary.seatsIncluded}
          </p>
          <div className="mt-3 h-1.5 rounded-full bg-gray-100">
            <div className="h-full rounded-full bg-emerald-500" style={{ width: `${seatPct}%` }} />
          </div>
        </div>
        <div className="rounded-xl border bg-white p-4">
          <p className="text-sm text-gray-500">Next invoice</p>
          <p className="mt-1 text-lg font-semibold">
            {money(summary.nextInvoiceCents, summary.currency)}
          </p>
          <p className="text-sm text-gray-500">on {summary.nextInvoiceDate}</p>
        </div>
      </section>

      <section className="overflow-hidden rounded-xl border bg-white">
        <table className="w-full text-sm">
          <thead className="bg-gray-50 text-left text-gray-500">
            <tr>
              <th className="px-4 py-2 font-medium">Invoice</th>
              <th className="px-4 py-2 font-medium">Date</th>
              <th className="px-4 py-2 font-medium">Amount</th>
              <th className="px-4 py-2 font-medium">Status</th>
            </tr>
          </thead>
          <tbody>
            {invoices.map((inv) => (
              <tr key={inv.id} className="border-t">
                <td className="px-4 py-2">
                  <Link href={`/billing/invoices/${inv.id}`} className="font-medium hover:underline">
                    {inv.number}
                  </Link>
                </td>
                <td className="px-4 py-2 text-gray-500">{inv.issuedOn}</td>
                <td className="px-4 py-2">{money(inv.totalCents, inv.currency)}</td>
                <td className="px-4 py-2">
                  <span className={inv.status === "paid" ? "text-emerald-600" : "text-amber-600"}>
                    {inv.status}
                  </span>
                </td>
              </tr>
            ))}
          </tbody>
        </table>
      </section>
    </main>
  );
}

-- ForgeFlow example: "SaaS billing dashboard" (PostgreSQL 15+)

CREATE TABLE plans (
  id              text PRIMARY KEY,              -- e.g. 'growth'
  name            text NOT NULL,
  price_cents     integer NOT NULL CHECK (price_cents >= 0),
  currency        char(3) NOT NULL DEFAULT 'USD',
  seats_included  integer NOT NULL CHECK (seats_included > 0)
);

CREATE TABLE customers (
  id          uuid PRIMARY KEY DEFAULT gen_random_uuid(),
  name        text NOT NULL,
  email       text NOT NULL UNIQUE,
  created_at  timestamptz NOT NULL DEFAULT now()
);

CREATE TABLE subscriptions (
  id                  uuid PRIMARY KEY DEFAULT gen_random_uuid(),
  customer_id         uuid NOT NULL REFERENCES customers(id) ON DELETE CASCADE,
  plan_id             text NOT NULL REFERENCES plans(id),
  status              text NOT NULL CHECK (status IN ('trialing', 'active', 'past_due', 'canceled')),
  seats_used          integer NOT NULL DEFAULT 1 CHECK (seats_used >= 0),
  current_period_end  date NOT NULL,
  canceled_at         timestamptz,
  created_at          timestamptz NOT NULL DEFAULT now()
);

CREATE TABLE invoices (
  id               uuid PRIMARY KEY DEFAULT gen_random_uuid(),
  subscription_id  uuid NOT NULL REFERENCES subscriptions(id) ON DELETE CASCADE,
  number           text NOT NULL UNIQUE,         -- e.g. 'INV-2026-0042'
  total_cents      integer NOT NULL CHECK (total_cents >= 0),
  currency         char(3) NOT NULL DEFAULT 'USD',
  status           text NOT NULL CHECK (status IN ('draft', 'open', 'paid', 'void')),
  issued_on        date NOT NULL,
  paid_at          timestamptz
);

CREATE INDEX subscriptions_customer_idx ON subscriptions (customer_id);
CREATE INDEX invoices_subscription_issued_idx ON invoices (subscription_id, issued_on DESC);