# TanStack Start (/docs/guides/next/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 Next in a TanStack Start app with create-prisma, from scaffold to rendered data.

Location: Guides > Next > Frameworks > TanStack Start

## Introduction [#introduction]

This guide shows you how to use Prisma Next 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, and see your data.

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 Next wired in:

  

#### bun

```bash
bunx create-prisma@next --template tanstack-start --provider postgres
```

#### pnpm

```bash
pnpm dlx create-prisma@next --template tanstack-start --provider postgres
```

#### yarn

```bash
yarn dlx create-prisma@next --template tanstack-start --provider postgres
```

#### npm

```bash
npx create-prisma@next --template tanstack-start --provider postgres
```

Pick Prisma Postgres at the database prompt to have a database created for you, or paste your own `DATABASE_URL`.

## Prerequisites [#prerequisites]

* [Node.js](https://nodejs.org) v20.19 or later
* A PostgreSQL connection string, or nothing at all: the scaffold can create the database for you

## 1. Scaffold and enter the project [#1-scaffold-and-enter-the-project]

  

#### bun

```bash
bunx create-prisma@next --template tanstack-start --provider postgres
cd my-app
```

#### pnpm

```bash
pnpm dlx create-prisma@next --template tanstack-start --provider postgres
cd my-app
```

#### yarn

```bash
yarn dlx create-prisma@next --template tanstack-start --provider postgres
cd my-app
```

#### npm

```bash
npx create-prisma@next --template tanstack-start --provider postgres
cd my-app
```

The scaffold writes your connection string to `.env`, generates the TanStack Start app with Prisma Next wired in, installs dependencies, and emits the contract your queries are type-checked against.

## 2. Initialize and seed the database [#2-initialize-and-seed-the-database]

  

#### bun

```bash
bun run db:init
bun run db:seed
```

#### pnpm

```bash
pnpm run db:init
pnpm run db:seed
```

#### yarn

```bash
yarn db:init
yarn db:seed
```

#### npm

```bash
npm run db:init
npm run db:seed
```

```text no-copy
"summary": "Applied 5 operation(s) across 1 space(s), database signed"
Seeded 3 users.
```

`db:init` applies your schema (`src/prisma/contract.prisma`) to the database and signs it; the seed gives the first page something to show.

## 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.

## 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 Next client behind it

Model access is namespace-qualified on PostgreSQL: `db.orm.public.User`. The [Prisma Next overview](https://www.prisma.io/docs/orm/next) 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/next/fundamentals/reading-data): filtering, sorting, pagination, and writes.
* [Read the Prisma Next overview](https://www.prisma.io/docs/orm/next) for the concepts behind contracts and typed queries.

## Related pages

- [`Astro`](https://www.prisma.io/docs/guides/next/frameworks/astro): Set up Prisma Next in a Astro app with create-prisma, from scaffold to rendered data.
- [`Elysia`](https://www.prisma.io/docs/guides/next/frameworks/elysia): Build an Elysia API on Prisma Next with the elysia template.
- [`Hono`](https://www.prisma.io/docs/guides/next/frameworks/hono): Build a Hono API on Prisma Next with the hono template, then add your own routes.
- [`NestJS`](https://www.prisma.io/docs/guides/next/frameworks/nestjs): Set up Prisma Next in a NestJS app with create-prisma, from scaffold to rendered data.
- [`Next.js`](https://www.prisma.io/docs/guides/next/frameworks/nextjs): Set up Prisma Next in a Next.js app with create-prisma, from scaffold to rendered data.