Backend Cuecue

Hono + TypeScript SaaS backend for Cloudflare Workers.

It keeps the reusable foundation:

• Cloudflare D1 user/session/order storage
• Google OAuth login and Google One Tap
• JWT session cookies with D1 session revocation
• Current-user settings
• Stripe Checkout subscriptions
• Stripe subscription webhook
• OpenAPI docs and Scalar UI
• CORS, logging, and shared response helpers

Development

pnpm install
cp .env.example .dev.vars
pnpm dev

Wrangler runs the Worker on http://localhost:8787 by default.

The D1 binding is configured in wrangler.jsonc:

• Binding name: DB
• Database name: vibesdk-db
• Database id: 5efcae1d-ad5a-4559-9169-db1906768a53
• Migrations directory: migrations

Because the D1 binding is marked as remote, pnpm dev uses the shared remote D1 database. Use pnpm dev:local when you want Wrangler local storage instead, then apply local migrations with pnpm db:migrate:local.

Useful D1 commands:

pnpm db:list
pnpm db:info
pnpm db:migrations:list:remote
pnpm db:migrate:remote

Useful routes:

• GET /api/health
• GET /api/auth/google
• GET /api/auth/callback/google
• POST /api/auth/google/one-tap
• POST /api/auth/logout
• GET /api/auth/me
• GET /api/auth/profile
• GET /api/auth/providers
• GET /api/auth/sessions
• DELETE /api/auth/sessions/:sessionId
• GET /api/settings/user/me
• PATCH /api/settings/user/me
• POST /api/order-management/checkout
• POST /api/order-management/cancel
• GET /api/order-management
• POST /api/webhook
• GET /api/doc
• GET /api/reference

Required Setup

Use the shared vibesdk-db D1 database, create a Google Cloud OAuth Web client, and create a Stripe account.

Google OAuth redirect URI:

${API_URL}/api/auth/callback/google

Stripe webhook endpoint:

${API_URL}/api/webhook

Subscribe the Stripe webhook to:

• checkout.session.completed
• customer.subscription.updated
• customer.subscription.deleted

Database

This project reuses the users, sessions, and oauth_states tables already present in the vibesdk D1 database. Apply migrations/0005_backend_cuecue_orders.sql when the shared database does not have orders yet:

pnpm db:migrate:remote

The order migration creates:

CREATE TABLE IF NOT EXISTS `orders` (
  `id` text PRIMARY KEY NOT NULL,
  `user_id` text NOT NULL,
  order_no text unique not null,
  ...
);