🚀 PromptShip

src/
├── proxy.ts                       # Subdomain routing (replaces middleware.ts in Next.js 16)
├── app/
│   ├── layout.tsx                 # Root layout
│   │
│   ├── (marketing)/               # promptship.dev — public marketing pages
│   │   ├── layout.tsx             # Marketing layout (header + footer)
│   │   ├── page.tsx               # Landing page (/)
│   │   ├── pricing/page.tsx       # Pricing (/pricing)
│   │   └── blog/                  # Blog (/blog/*)
│   │       ├── page.tsx
│   │       └── [slug]/page.tsx
│   │
│   ├── (auth)/                    # app.promptship.dev/login, /signup, /verify
│   │   ├── layout.tsx             # Centered auth layout
│   │   ├── login/page.tsx
│   │   ├── signup/page.tsx
│   │   └── verify/page.tsx
│   │
│   ├── (app)/                     # app.promptship.dev/* — authenticated user portal
│   │   ├── layout.tsx             # App layout with sidebar
│   │   ├── dashboard/page.tsx     # Dashboard (/dashboard)
│   │   ├── prompts/               # Prompt library (/prompts/*)
│   │   │   ├── page.tsx
│   │   │   └── [category]/page.tsx
│   │   ├── generate/page.tsx      # AI Generator (/generate)
│   │   ├── learn/                 # Learning hub (/learn/*)
│   │   │   ├── page.tsx
│   │   │   └── [moduleId]/[lessonId]/page.tsx
│   │   ├── history/page.tsx       # Generation history
│   │   └── settings/page.tsx      # User settings
│   │
│   ├── (admin)/                   # admin.promptship.dev — proxy rewrites / → /admin
│   │   ├── layout.tsx             # Admin layout
│   │   └── admin/                 # Internal path prefix (hidden from admin subdomain URLs)
│   │       ├── page.tsx           # Admin dashboard (admin.promptship.dev/)
│   │       ├── prompts/page.tsx   # Prompt management (admin.promptship.dev/prompts)
│   │       ├── users/page.tsx     # User management (admin.promptship.dev/users)
│   │       └── analytics/page.tsx # Analytics (admin.promptship.dev/analytics)
│   │
│   ├── (docs)/                    # promptship.dev/docs/*
│   │   ├── docs/page.tsx
│   │   └── docs/[...slug]/page.tsx
│   │
│   └── api/                       # API routes (all subdomains)
│       ├── auth/[...all]/route.ts # Better Auth
│       ├── generate/route.ts      # AI generation
│       ├── prompts/route.ts       # Prompts CRUD
│       └── webhooks/
│           ├── stripe/route.ts
│           └── razorpay/route.ts
│
└── config/
    ├── site.ts                    # Subdomain URLs (appUrl, adminUrl, marketingUrl)
    └── navigation.ts              # Per-portal navigation configs

-- =============================================
-- USERS & AUTHENTICATION
-- =============================================

CREATE TYPE user_tier AS ENUM ('free', 'starter', 'pro', 'team');
CREATE TYPE user_role AS ENUM ('user', 'admin');

CREATE TABLE users (
    id                  UUID PRIMARY KEY DEFAULT gen_random_uuid(),
    email               VARCHAR(255) UNIQUE NOT NULL,
    name                VARCHAR(255),
    avatar_url          TEXT,
    tier                user_tier DEFAULT 'free',
    role                user_role DEFAULT 'user',
    credits             INTEGER DEFAULT 0,
    default_framework   VARCHAR(20) DEFAULT 'react',
    preferred_currency  VARCHAR(3) DEFAULT 'USD',
    onboarding_completed BOOLEAN DEFAULT false,
    email_verified      BOOLEAN DEFAULT false,
    created_at          TIMESTAMPTZ DEFAULT NOW(),
    updated_at          TIMESTAMPTZ DEFAULT NOW()
);

CREATE TABLE sessions (
    id                  UUID PRIMARY KEY DEFAULT gen_random_uuid(),
    user_id             UUID REFERENCES users(id) ON DELETE CASCADE,
    token               VARCHAR(255) UNIQUE NOT NULL,
    expires_at          TIMESTAMPTZ NOT NULL,
    ip_address          INET,
    user_agent          TEXT,
    created_at          TIMESTAMPTZ DEFAULT NOW()
);

CREATE TABLE magic_links (
    id                  UUID PRIMARY KEY DEFAULT gen_random_uuid(),
    email               VARCHAR(255) NOT NULL,
    token               VARCHAR(255) UNIQUE NOT NULL,
    expires_at          TIMESTAMPTZ NOT NULL,
    used_at             TIMESTAMPTZ,
    created_at          TIMESTAMPTZ DEFAULT NOW()
);

-- =============================================
-- SUBSCRIPTIONS & PAYMENTS
-- =============================================

CREATE TYPE subscription_status AS ENUM ('active', 'canceled', 'past_due', 'paused', 'trialing');
CREATE TYPE payment_provider AS ENUM ('stripe', 'razorpay');

CREATE TABLE subscriptions (
    id                      UUID PRIMARY KEY DEFAULT gen_random_uuid(),
    user_id                 UUID REFERENCES users(id) ON DELETE CASCADE,
    plan                    VARCHAR(50) NOT NULL,  -- starter, pro_monthly, pro_yearly, team
    status                  subscription_status DEFAULT 'active',
    provider                payment_provider NOT NULL,
    provider_subscription_id VARCHAR(255),
    provider_customer_id    VARCHAR(255),
    current_period_start    TIMESTAMPTZ,
    current_period_end      TIMESTAMPTZ,
    cancel_at_period_end    BOOLEAN DEFAULT false,
    created_at              TIMESTAMPTZ DEFAULT NOW(),
    updated_at              TIMESTAMPTZ DEFAULT NOW()
);

CREATE TABLE payments (
    id                      UUID PRIMARY KEY DEFAULT gen_random_uuid(),
    user_id                 UUID REFERENCES users(id) ON DELETE SET NULL,
    subscription_id         UUID REFERENCES subscriptions(id),
    provider                payment_provider NOT NULL,
    provider_payment_id     VARCHAR(255),
    amount                  INTEGER NOT NULL,  -- in smallest currency unit (paise/cents)
    currency                VARCHAR(3) NOT NULL,
    status                  VARCHAR(50) NOT NULL,
    created_at              TIMESTAMPTZ DEFAULT NOW()
);

-- =============================================
-- PROMPTS & CATEGORIES
-- =============================================

CREATE TABLE categories (
    id                  UUID PRIMARY KEY DEFAULT gen_random_uuid(),
    name                VARCHAR(100) NOT NULL,
    slug                VARCHAR(100) UNIQUE NOT NULL,
    description         TEXT,
    icon                VARCHAR(50),
    display_order       INTEGER DEFAULT 0,
    created_at          TIMESTAMPTZ DEFAULT NOW()
);

CREATE TABLE prompts (
    id                  UUID PRIMARY KEY DEFAULT gen_random_uuid(),
    category_id         UUID REFERENCES categories(id),
    title               VARCHAR(255) NOT NULL,
    slug                VARCHAR(255) UNIQUE NOT NULL,
    description         TEXT,
    prompt_text         TEXT NOT NULL,
    tier                user_tier DEFAULT 'free',
    frameworks          VARCHAR(20)[] DEFAULT '{react}',
    preview_image_url   TEXT,
    usage_count         INTEGER DEFAULT 0,
    copy_count          INTEGER DEFAULT 0,
    favorite_count      INTEGER DEFAULT 0,
    is_featured         BOOLEAN DEFAULT false,
    is_published        BOOLEAN DEFAULT true,
    created_at          TIMESTAMPTZ DEFAULT NOW(),
    updated_at          TIMESTAMPTZ DEFAULT NOW()
);

CREATE TABLE prompt_copies (
    id                  UUID PRIMARY KEY DEFAULT gen_random_uuid(),
    user_id             UUID REFERENCES users(id) ON DELETE CASCADE,
    prompt_id           UUID REFERENCES prompts(id) ON DELETE CASCADE,
    created_at          TIMESTAMPTZ DEFAULT NOW()
);

CREATE TABLE favorites (
    id                  UUID PRIMARY KEY DEFAULT gen_random_uuid(),
    user_id             UUID REFERENCES users(id) ON DELETE CASCADE,
    prompt_id           UUID REFERENCES prompts(id) ON DELETE CASCADE,
    created_at          TIMESTAMPTZ DEFAULT NOW(),
    UNIQUE(user_id, prompt_id)
);

-- =============================================
-- AI GENERATIONS
-- =============================================

CREATE TABLE generations (
    id                  UUID PRIMARY KEY DEFAULT gen_random_uuid(),
    user_id             UUID REFERENCES users(id) ON DELETE CASCADE,
    prompt_id           UUID REFERENCES prompts(id) ON DELETE SET NULL,
    framework           VARCHAR(20) NOT NULL,
    template_type       VARCHAR(50),
    options             JSONB DEFAULT '{}',
    input_prompt        TEXT NOT NULL,
    output_code         TEXT NOT NULL,
    ai_provider         VARCHAR(20) DEFAULT 'claude',
    ai_model            VARCHAR(50),
    tokens_input        INTEGER,
    tokens_output       INTEGER,
    latency_ms          INTEGER,
    cost_usd            DECIMAL(10, 6),
    created_at          TIMESTAMPTZ DEFAULT NOW()
);

-- =============================================
-- LEARNING HUB
-- =============================================

CREATE TABLE course_modules (
    id                  UUID PRIMARY KEY DEFAULT gen_random_uuid(),
    title               VARCHAR(255) NOT NULL,
    slug                VARCHAR(255) UNIQUE NOT NULL,
    description         TEXT,
    display_order       INTEGER DEFAULT 0,
    is_published        BOOLEAN DEFAULT false,
    created_at          TIMESTAMPTZ DEFAULT NOW()
);

CREATE TABLE lessons (
    id                  UUID PRIMARY KEY DEFAULT gen_random_uuid(),
    module_id           UUID REFERENCES course_modules(id) ON DELETE CASCADE,
    title               VARCHAR(255) NOT NULL,
    slug                VARCHAR(255) NOT NULL,
    description         TEXT,
    video_url           TEXT,  -- Mux playback ID
    video_duration_sec  INTEGER,
    display_order       INTEGER DEFAULT 0,
    is_free_preview     BOOLEAN DEFAULT false,
    is_published        BOOLEAN DEFAULT false,
    created_at          TIMESTAMPTZ DEFAULT NOW()
);

CREATE TABLE lesson_progress (
    id                  UUID PRIMARY KEY DEFAULT gen_random_uuid(),
    user_id             UUID REFERENCES users(id) ON DELETE CASCADE,
    lesson_id           UUID REFERENCES lessons(id) ON DELETE CASCADE,
    watch_time_sec      INTEGER DEFAULT 0,
    is_completed        BOOLEAN DEFAULT false,
    completed_at        TIMESTAMPTZ,
    last_position_sec   INTEGER DEFAULT 0,
    updated_at          TIMESTAMPTZ DEFAULT NOW(),
    UNIQUE(user_id, lesson_id)
);

-- =============================================
-- INDEXES
-- =============================================

CREATE INDEX idx_users_email ON users(email);
CREATE INDEX idx_users_tier ON users(tier);
CREATE INDEX idx_sessions_token ON sessions(token);
CREATE INDEX idx_sessions_user ON sessions(user_id);
CREATE INDEX idx_subscriptions_user ON subscriptions(user_id);
CREATE INDEX idx_subscriptions_provider ON subscriptions(provider, provider_subscription_id);
CREATE INDEX idx_prompts_category ON prompts(category_id);
CREATE INDEX idx_prompts_tier ON prompts(tier);
CREATE INDEX idx_prompts_published ON prompts(is_published);
CREATE INDEX idx_generations_user_date ON generations(user_id, created_at DESC);
CREATE INDEX idx_prompt_copies_user_date ON prompt_copies(user_id, created_at);
CREATE INDEX idx_favorites_user ON favorites(user_id);
CREATE INDEX idx_lesson_progress_user ON lesson_progress(user_id);

-- Full-text search on prompts
CREATE INDEX idx_prompts_search ON prompts 
    USING GIN(to_tsvector('english', title || ' ' || COALESCE(description, '')));

// Prompt Template Structure

interface PromptTemplate {
  id: string;
  name: string;
  category: PromptCategory;
  basePrompt: string;
  frameworkInstructions: Record<Framework, string>;
  styleVariants: Record<Style, string>;
  optionModifiers: OptionModifier[];
}

// Complete Prompt Assembly
function buildPrompt(
  template: PromptTemplate,
  options: GeneratorOptions
): string {
  return `
${SYSTEM_PROMPT}

${template.frameworkInstructions[options.framework]}

${template.basePrompt}

${template.styleVariants[options.style]}

## Specifications:
- Primary Color: ${options.primaryColor}
- Dark Mode: ${options.darkMode ? 'Yes' : 'No'}
- Animation Level: ${options.animationLevel}
- Border Radius: ${options.borderRadius}px

${options.customInstructions ? `## Additional Requirements:\n${options.customInstructions}` : ''}

## Output Requirements:
- Output ONLY the code, no explanations
- Code must be complete and copy-paste ready
- Include all necessary imports
`.trim();
}

// lib/ai/generate.ts

import Anthropic from '@anthropic-ai/sdk';
import OpenAI from 'openai';

const anthropic = new Anthropic();
const openai = new OpenAI();

interface GenerationResult {
  code: string;
  provider: 'claude' | 'openai';
  tokensInput: number;
  tokensOutput: number;
  latencyMs: number;
  costUsd: number;
}

export async function generateCode(
  prompt: string,
  framework: Framework
): Promise<GenerationResult> {
  const startTime = Date.now();
  
  try {
    // Try Claude first
    const response = await anthropic.messages.create({
      model: 'claude-3-5-sonnet-20241022',
      max_tokens: 4096,
      messages: [{ role: 'user', content: prompt }],
    });
    
    const code = extractCode(response.content[0].text, framework);
    const latencyMs = Date.now() - startTime;
    
    return {
      code,
      provider: 'claude',
      tokensInput: response.usage.input_tokens,
      tokensOutput: response.usage.output_tokens,
      latencyMs,
      costUsd: calculateCost('claude', response.usage),
    };
  } catch (error) {
    // Fallback to OpenAI
    console.error('Claude failed, falling back to OpenAI:', error);
    
    const response = await openai.chat.completions.create({
      model: 'gpt-4-turbo',
      max_tokens: 4096,
      messages: [{ role: 'user', content: prompt }],
    });
    
    const code = extractCode(response.choices[0].message.content!, framework);
    const latencyMs = Date.now() - startTime;
    
    return {
      code,
      provider: 'openai',
      tokensInput: response.usage!.prompt_tokens,
      tokensOutput: response.usage!.completion_tokens,
      latencyMs,
      costUsd: calculateCost('openai', response.usage!),
    };
  }
}

// middleware.ts - Edge Rate Limiting

import { Ratelimit } from '@upstash/ratelimit';
import { Redis } from '@upstash/redis';

const ratelimit = new Ratelimit({
  redis: Redis.fromEnv(),
  limiter: Ratelimit.slidingWindow(10, '10 s'), // 10 requests per 10 seconds
});

const aiRatelimit = new Ratelimit({
  redis: Redis.fromEnv(),
  limiter: Ratelimit.slidingWindow(5, '60 s'), // 5 AI calls per minute
});

export async function middleware(request: NextRequest) {
  const ip = request.ip ?? '127.0.0.1';
  
  // Different limits for different endpoints
  if (request.nextUrl.pathname.startsWith('/api/generate')) {
    const { success, remaining } = await aiRatelimit.limit(ip);
    
    if (!success) {
      return new Response('Too many requests', { status: 429 });
    }
  }
  
  return NextResponse.next();
}

promptship/
├── .github/
│   └── workflows/
│       ├── ci.yml           # Lint, type-check, test on PR
│       ├── preview.yml      # Deploy preview on PR
│       └── production.yml   # Deploy to production on main
├── src/
│   ├── app/                 # Next.js App Router
│   ├── components/          # React components
│   ├── lib/                 # Utilities, services
│   ├── db/                  # Drizzle schema, migrations
│   └── styles/              # Global styles
├── public/                  # Static assets
├── scripts/                 # Build, seed scripts
├── tests/                   # Test files
├── drizzle.config.ts        # Drizzle ORM config
├── next.config.js
├── tailwind.config.js
├── tsconfig.json
└── package.json

# .env.example

# Database
DATABASE_URL="postgresql://..."
DIRECT_URL="postgresql://..."

# Auth
BETTER_AUTH_SECRET="..."
BETTER_AUTH_URL="https://promptship.dev"

# AI Providers
ANTHROPIC_API_KEY="sk-ant-..."
OPENAI_API_KEY="sk-..."

# Payments
STRIPE_SECRET_KEY="sk_live_..."
STRIPE_WEBHOOK_SECRET="whsec_..."
RAZORPAY_KEY_ID="rzp_live_..."
RAZORPAY_KEY_SECRET="..."
RAZORPAY_WEBHOOK_SECRET="..."

# Redis
UPSTASH_REDIS_REST_URL="..."
UPSTASH_REDIS_REST_TOKEN="..."

# Email
RESEND_API_KEY="re_..."

# Video
MUX_TOKEN_ID="..."
MUX_TOKEN_SECRET="..."

# Analytics
NEXT_PUBLIC_POSTHOG_KEY="..."
SENTRY_DSN="..."

// Security Headers (next.config.js)

const securityHeaders = [
  {
    key: 'X-DNS-Prefetch-Control',
    value: 'on'
  },
  {
    key: 'Strict-Transport-Security',
    value: 'max-age=63072000; includeSubDomains; preload'
  },
  {
    key: 'X-Frame-Options',
    value: 'SAMEORIGIN'
  },
  {
    key: 'X-Content-Type-Options',
    value: 'nosniff'
  },
  {
    key: 'Referrer-Policy',
    value: 'origin-when-cross-origin'
  },
  {
    key: 'Content-Security-Policy',
    value: ContentSecurityPolicy.replace(/\s{2,}/g, ' ').trim()
  }
];

// POST /api/generate

// Request
{
  "templateId": "hero-cinematic",
  "framework": "react",
  "options": {
    "style": "glassmorphism",
    "primaryColor": "#6366F1",
    "darkMode": true,
    "animationLevel": "dynamic",
    "borderRadius": 16
  },
  "customInstructions": "Add a newsletter signup form"
}

// Response (200 OK)
{
  "success": true,
  "data": {
    "id": "gen_abc123",
    "code": "import React from 'react';\n\nexport default function Hero() {\n  ...",
    "framework": "react",
    "tokensUsed": 1247,
    "creditsRemaining": 84
  }
}

// Response (402 - No Credits)
{
  "success": false,
  "error": {
    "code": "INSUFFICIENT_CREDITS",
    "message": "You have 0 credits remaining. Upgrade to continue.",
    "upgradeUrl": "/pricing"
  }
}