An open-source starter kit using TiDB Cloud, Vercel, Kysely, and GitHub. Think of this as a minimal, self-hostable cousin of Lovable.dev that you fully own and control.

Describe an app and this agent provisions GitHub + TiDB Cloud + Vercel, codes with Codex (gpt-5.1-codex) and Claude Code (claude-sonnet-4.5), tests, deploys, and streams the whole session. The code is public at https://github.com/pingcap/full-stack-app-builder-ai-agent.

• Generate complete web apps from a prompt (Next.js 16 + shadcn/Tailwind).
• Provision TiDB Cloud clusters/branches per project and per instruction.
• Track versions so code, schema, and credentials stay aligned.
• Run and preview apps instantly via Vercel sandboxes and previews.
• Keep conversational context between generations for iterative refinement.
• Scale down idle environments with TiDB Cloud serverless.

• Server actions (src/actions/*) orchestrate GitHub, TiDB Cloud, and Vercel resources.
• Sandboxes (src/sandboxes/*) launch per-task runtimes, run npm run dev, and report via src/app/hooks/v1/sandboxes/[sandboxId]/route.ts.
• Session UI (src/app/(customer)/s/[slug]) streams logs, checkpoints, and deploy links.
• Auth & protection (src/proxy.ts, src/lib/auth*) gate /projects, /settings, and API v1 routes.

1. Prompt – “Build a todo app.”
2. Plan – Model drafts an execution plan.
3. Provision – Create TiDB cluster/branch, Vercel sandbox, GitHub repo/branch, and env vars.
4. Generate – Codex/Claude Code writes app code, Kysely schema, and migrations.
5. Migrate – Run typed migrations against the TiDB branch.
6. Deploy – Commit to GitHub and trigger a Vercel preview.
7. Iterate – Follow-up prompts (e.g., “Add a username field”) spawn new TiDB branches and code revisions, keeping everything reversible.

• Checkpointed versions – Git branches map to TiDB branches for perfect code–data sync.
• Type-safe migrations – Kysely migrations keep schema evolution safe and reversible.
• Scale-to-zero – TiDB Cloud serverless + Vercel sandboxes support many isolated environments without idle cost.

// TiDB Cloud branch creation (simplified)
import fetch from "node-fetch";

async function createBranch(clusterId, displayName, publicKey, privateKey) {
  const res = await fetch(
    `https://serverless.tidbapi.com/v1beta1/clusters/${clusterId}/branches`,
    {
      method: "POST",
      headers: {
        "Content-Type": "application/json",
        Authorization:
          "Basic " + Buffer.from(`${publicKey}:${privateKey}`).toString("base64"),
      },
      body: JSON.stringify({ displayName }),
    },
  );
  if (!res.ok) throw new Error(await res.text());
  return (await res.json()).branchId;
}

• Node.js 18.18+ (Next.js 16 requirement) and npm.
• TiDB Serverless account with API keys, organization/project IDs, region, and database endpoint.
• GitHub account with access to install the required template and push commits via Personal Access Token.
• Vercel team token with Blob Storage enabled.
• OpenAI (or CRS) API key to drive Codex sessions.
• Required environment variables:
  • DATABASE_URL
  • OPENAI_API_KEY
  • TIDB_CLOUD_REGION, TIDB_CLOUD_DATABASE_ENDPOINT

npm install

# Bootstrap TiDB schema (creates the schema + tables and regenerates typed bindings)
npm run migrate:init       # one-time schema creation
npm run migrate:up         # run pending migrations

# Create your first local operator seeded with GitHub + password credentials
node scripts/setup-local-user.js
# (Use scripts/gen-password.js if you only need to hash a password with BCRYPT_SALT)

# Launch the workspace
npm run dev

Visit http://localhost:3000/login, authenticate with the user you just created, and start creating projects or sessions.