sql2ai/render.yaml at main · dbbuilder-org/sql2ai · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
# Render Blueprint for SQL2.AI
# https://render.com/docs/blueprint-spec

services:
  # ===========================================
  # API Backend (FastAPI)
  # ===========================================
  - type: web
    name: sql2ai-api
    runtime: docker
    dockerfilePath: ./apps/api/Dockerfile
    dockerContext: .
    branch: main
    plan: starter
    healthCheckPath: /health
    envVars:
      - key: SQL2AI_ENVIRONMENT
        value: production
      - key: SQL2AI_DEBUG
        value: "false"
      - key: SQL2AI_DATABASE_URL
        fromDatabase:
          name: sql2ai-db
          property: connectionString
      - key: SQL2AI_SECRET_KEY
        generateValue: true
      - key: SQL2AI_CLERK_SECRET_KEY
        sync: false
      - key: SQL2AI_CLERK_PUBLISHABLE_KEY
        sync: false
      - key: SQL2AI_STRIPE_SECRET_KEY
        sync: false
      - key: SQL2AI_STRIPE_WEBHOOK_SECRET
        sync: false
      - key: SQL2AI_OPENAI_API_KEY
        sync: false
      - key: SQL2AI_ANTHROPIC_API_KEY
        sync: false
      - key: SQL2AI_SENTRY_DSN
        sync: false
      - key: SQL2AI_CORS_ORIGINS
        value: '["https://app.sql2.ai","https://sql2.ai","http://localhost:3000"]'
    buildFilter:
      paths:
        - apps/api/**
        - libs/shared/**
    # Custom domain: api.sql2.ai

  # ===========================================
  # Dashboard App (Next.js)
  # ===========================================
  - type: web
    name: sql2ai-app
    runtime: node
    buildCommand: npm ci --include=dev && ./node_modules/.bin/nx build @sql2ai/app --configuration=production
    startCommand: npm run start --workspace=@sql2ai/app
    branch: main
    plan: starter
    healthCheckPath: /
    envVars:
      - key: NODE_ENV
        value: production
      - key: NEXT_PUBLIC_API_URL
        value: https://api.sql2.ai
      - key: NEXT_PUBLIC_CLERK_PUBLISHABLE_KEY
        sync: false
      - key: CLERK_SECRET_KEY
        sync: false
      - key: NEXT_PUBLIC_SENTRY_DSN
        sync: false
    buildFilter:
      paths:
        - apps/app/**
        - libs/**
        - package.json
        - nx.json
    # Custom domain: app.sql2.ai

# ===========================================
# PostgreSQL Database
# ===========================================
databases:
  - name: sql2ai-db
    plan: basic-256mb
    region: oregon
    ipAllowList: []  # Allow all connections

# ===========================================
# Note: Static site (sql2ai-site) is deployed separately
# via Render dashboard - already live at sql2.ai
# ===========================================