Web App Platform Overview
The Web Application platform produces a blueprint for dynamic, full-stack web apps with a frontend, backend API, database, auth, infra, and tests. It has the most agents and artifacts of any Scriptonia platform.- Agents: ProductManager, FrontendDev, BackendDev, DevOpsEngineer, ToolManager
- Execution: ~75 s
- Cost: Same as other platforms (unified $SOL/ USD)
Features Included
| Area | What’s in the blueprint |
|---|---|
| Product | PRD, PLAN, HUMAN_REVIEW, PROJECT_RULES |
| Frontend | Next.js App Router, components, state (Zustand / Redux), LLM prompt to generate frontend code |
| Backend | Express (or FastAPI / NestJS), services, auth; OpenAPI spec |
| Database | PostgreSQL, Prisma schema, migrations, ORM models |
| Auth | NextAuth.js or Clerk in specs and infra |
| Infra | Terraform, CI/CD, monitoring, secrets |
| Testing | Unit tests, API tests |
| Repo / CI | github_push.yaml |
Architecture
- Frontend — Next.js App Router, TypeScript, Tailwind, Zustand / Redux; component and state specs; prompt to generate the UI
- Backend — Node / Express (or FastAPI / NestJS), service layer, auth; OpenAPI for the API
- DB — PostgreSQL and Prisma: schema, migrations, ORM
- Infra — Terraform, CI/CD (e.g. GitHub Actions), monitoring, secrets
- Testing — Structure for unit and API tests
Database Setup
Schema and ORM
- db/schema.md — Tables, relations, indexes
- db/orm_models.md — Prisma models
- db/migrations.md — How to create and run Prisma migrations
Steps after you have runnable code
-
Install Prisma (if not in the generated app)
-
Apply the schema — Turn
db/schema.mdandorm_models.mdintoprisma/schema.prisma, then: -
Connect the app
- Set
DATABASE_URL - Use
PrismaClientin the backend
- Set
-
Seeding (optional)
- Add
seedinpackage.json - Run
npx prisma db seed
- Add
Hosted Postgres
- Vercel Postgres, Supabase, Neon, Railway, AWS RDS
- Use the provider’s connection string as
DATABASE_URL - infra/secrets_management.md describes where to store secrets
Deployment Options
Vercel (frontend + serverless API)
- Deploy Next.js app with API Routes or Route Handlers
- External backend deployed separately if needed
- Hosted Postgres via Vercel or another provider
- CI/CD via infra/ci_cd.md and meta/github_push.yaml
Docker + cloud (AWS, GCP, etc.)
- infra/terraform.md — VPC, RDS, ECS / Fargate / GKE
- Dockerfile — Backend (and optionally frontend)
- infra/ci_cd.md — Build, push, deploy
- infra/secrets_management.md — Inject secrets
Hybrid (Vercel frontend + external backend)
- Frontend on Vercel
- Backend on AWS Fargate, Lambda, or Cloud Run
- Hosted Postgres
- API contract in backend/apis/openapi.md
Auth in deployment
- NextAuth.js
NEXTAUTH_URLNEXTAUTH_SECRET- OAuth client IDs / secrets
- Clerk
NEXT_PUBLIC_CLERK_*CLERK_SECRET_KEY
- infra/secrets_management.md — Where auth secrets live