# TanStack Start (/docs/guides/frameworks/tanstack-start) > For the complete Prisma documentation index, see [llms.txt](https://www.prisma.io/docs/llms.txt). A markdown version of any docs page is available by appending `.md` to its URL. Set up Prisma 8 in a TanStack Start app with create-prisma, from scaffold to rendered data, and deploy it to Prisma Compute. Location: Guides > Frameworks > TanStack Start ## Introduction [#introduction] This guide shows you how to use Prisma 8 in a TanStack Start app. You scaffold a project where a server function queries your database and a route loader feeds it to the page, initialize the schema, see your data, and deploy the app to [Prisma Compute](https://www.prisma.io/docs/compute). Every command below was run end to end against a live [Prisma Postgres](https://www.prisma.io/docs/postgres) database. ## Quick start [#quick-start] One command scaffolds the project with Prisma 8 wired in: #### bun ```bash bunx create-prisma@latest create my-app --template tanstack-start --provider postgres ``` #### pnpm ```bash pnpm dlx create-prisma@latest create my-app --template tanstack-start --provider postgres ``` #### yarn ```bash yarn dlx create-prisma@latest create my-app --template tanstack-start --provider postgres ``` #### npm ```bash npx create-prisma@latest create my-app --template tanstack-start --provider postgres ``` Answer the prompts, then export `DATABASE_URL` in your shell before running the database scripts. If you do not have a database yet, `npx create-db@latest` prints a Prisma Postgres connection string. ## Prerequisites [#prerequisites] * [Node.js](https://nodejs.org) 24 or later * A PostgreSQL connection string, or nothing at all: `npx create-db@latest` can create a Prisma Postgres database for you ## Use with your agent [#use-with-your-agent] To delegate this guide to your coding agent, copy the prompt below and hand it over: ```text Create a new TanStack Start app with Prisma 8, seed it, and deploy it to Prisma Compute. 1. Scaffold: `npx create-prisma@latest create my-app --template tanstack-start --provider postgres --yes`. Then run `npx prisma@latest init` in `my-app` so the Prisma agent skills are installed and stay current, and use them. Get a database connection string: use the one I give you, or create a Prisma Postgres database with `npx create-db@latest` and show me the claim URL it prints. Export it as `DATABASE_URL` in the shell; the generated scripts read the environment variable, not `.env`. 2. In `my-app`, run `npm run db:init` with `DATABASE_URL` exported. Sample users are seeded automatically on the app's first query; there is no separate seed script. 3. Start `npm run dev` in the background, wait until it reports ready, verify http://localhost:3000 renders the three seeded users, then stop the dev server. 4. Deploy: check `npx prisma@latest auth whoami`; if I am not signed in, stop and ask me to run `npx prisma@latest auth login`. Then run `npm run build` followed by `npx prisma@latest deploy module.ts` and verify the live URL renders the seeded users. The deployed app provisions and seeds its own Prisma Postgres database; do not pass the local DATABASE_URL. If the deploy fails with `HostedStateBootstrapError`, a project with the module's name exists in my workspace but its hosted state cannot be verified; re-run the deploy with `--name `. ``` ## 1. Scaffold and enter the project [#1-scaffold-and-enter-the-project] #### bun ```bash bunx create-prisma@latest create my-app --template tanstack-start --provider postgres cd my-app ``` #### pnpm ```bash pnpm dlx create-prisma@latest create my-app --template tanstack-start --provider postgres cd my-app ``` #### yarn ```bash yarn dlx create-prisma@latest create my-app --template tanstack-start --provider postgres cd my-app ``` #### npm ```bash npx create-prisma@latest create my-app --template tanstack-start --provider postgres cd my-app ``` The scaffold generates the TanStack Start app with Prisma 8 wired in, installs dependencies, and emits the contract your queries are type-checked against. Next, set the database connection for the local steps. Use your own PostgreSQL connection string, or create a Prisma Postgres database with `npx create-db@latest`; it prints a connection string and a claim URL you can open to keep the database. Export the variable in the shell you work in; the generated scripts read the environment variable, not `.env`: ```bash export DATABASE_URL="" ``` ## 2. Initialize the database [#2-initialize-the-database] #### bun ```bash bun run db:init ``` #### pnpm ```bash pnpm run db:init ``` #### yarn ```bash yarn db:init ``` #### npm ```bash npm run db:init ``` ```text no-copy "summary": "Applied 5 operation(s) across 1 space(s), database signed" ``` If `db:init` stops with `Connection terminated unexpectedly`, a database you just created is still starting; wait a few seconds and run it again. The command is safe to repeat and reports `Applied 0 operation(s)` when there is nothing left to do. `db:init` applies your schema (`src/prisma/contract.prisma`) to the database and signs it. Sample users are seeded automatically the first time the app queries the database. ## 3. Run and verify [#3-run-and-verify] #### bun ```bash bun run dev ``` #### pnpm ```bash pnpm run dev ``` #### yarn ```bash yarn dev ``` #### npm ```bash npm run dev ``` Open [http://localhost:3000](http://localhost:3000). The page lists the seeded users, provided by the route loader's server function. ## 4. Deploy to Prisma Compute [#4-deploy-to-prisma-compute] TanStack Start is supported on [Prisma Compute](https://www.prisma.io/docs/compute). The scaffold builds with Nitro (the `nitro()` Vite plugin ships in `vite.config.ts`) and declares the app for [Prisma Composer](https://www.prisma.io/docs/composer) in `module.ts` and `service.ts`, pointing at Nitro's `.output` directory. Deploying is building and handing that declaration to the CLI. Sign in once (it opens a browser): #### bun ```bash bunx prisma@latest auth login ``` #### pnpm ```bash pnpm dlx prisma@latest auth login ``` #### yarn ```bash yarn dlx prisma@latest auth login ``` #### npm ```bash npx prisma@latest auth login ``` Then build and deploy from the project directory: #### bun ```bash bun run build bunx prisma@latest deploy module.ts ``` #### pnpm ```bash pnpm run build pnpm dlx prisma@latest deploy module.ts ``` #### yarn ```bash yarn build yarn dlx prisma@latest deploy module.ts ``` #### npm ```bash npm run build npx prisma@latest deploy module.ts ``` ```text no-copy my-app ├─ database postgres-database db_abc123 └─ app compute-service cps_abc123 https://xyz.ewr.prisma.build ``` Open the live URL: the page renders the seeded users. The deploy creates a project named after your module in your workspace, and re-running the deploy reuses it: the CLI finds the hosted state it stored on the first run and converges the project to your module. If a project with that name exists but the CLI cannot identify or verify its stored state (one left behind by a different checkout, for example), the deploy stops with `HostedStateBootstrapError`; deploy under another name with `--name `, or rename the module in `module.ts`. The deploy also provisions its own Prisma Postgres database on the platform, declared in `module.ts`; the `DATABASE_URL` from your local steps is not involved, and the deployed database seeds on the app's first query. For previews per Git branch and deploy-on-push, see [Deploy your first app](https://www.prisma.io/docs/prisma-compute/deploy). ## Where things live [#where-things-live] * `src/routes/index.tsx`: the route: a `createServerFn` queries users, the loader passes them to the page * `src/prisma/users.ts`: the query helper the server function calls * `src/prisma/db.ts`: the Prisma 8 client behind it Model access is namespace-qualified on PostgreSQL: `db.orm.public.User`. The [Prisma 8 overview](https://www.prisma.io/docs/orm) covers the contract-first model behind it. ## Next steps [#next-steps] * Change the schema in `src/prisma/contract.prisma`, then run `npm run contract:emit` and `npm run db:update`. * [Learn the fundamentals](https://www.prisma.io/docs/orm/fundamentals/reading-data): filtering, sorting, pagination, and writes. * [Read the Prisma 8 overview](https://www.prisma.io/docs/orm) for the concepts behind contracts and typed queries. ## Related pages - [`Astro`](https://www.prisma.io/docs/guides/frameworks/astro): Set up Prisma 8 in an Astro app with create-prisma, from scaffold to rendered data, and deploy it to Prisma Compute. - [`Elysia`](https://www.prisma.io/docs/guides/frameworks/elysia): Build an Elysia API on Prisma 8 with the elysia template and deploy it to Prisma Compute. - [`Hono`](https://www.prisma.io/docs/guides/frameworks/hono): Build a Hono API on Prisma 8 with the hono template, add your own routes, and deploy it to Prisma Compute. - [`NestJS`](https://www.prisma.io/docs/guides/frameworks/nestjs): Set up Prisma 8 in a NestJS app with create-prisma, from scaffold to seeded API to a live deploy on Prisma Compute. - [`Next.js`](https://www.prisma.io/docs/guides/frameworks/nextjs): Set up Prisma 8 in a Next.js app with create-prisma, from scaffold to rendered data, and deploy it to Prisma Compute.