> ## Documentation Index
> Fetch the complete documentation index at: https://bun-1dd33a4e-farm-ad2450b3-transpiler-cache-version-namespa.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.
# Use Prisma with Bun
Prisma's dynamic subcommand loading requires npm to be installed alongside Bun. This affects CLI commands such as
`prisma init` and `prisma migrate`. Generated code works with Bun using the `prisma-client` generator.
Create a directory and initialize it with `bun init`.
```bash terminal icon="terminal" theme={"theme":{"light":"github-light","dark":"dracula"}}
mkdir prisma-app
cd prisma-app
bun init
```
Then install the Prisma CLI (`prisma`), Prisma Client (`@prisma/client`), and the LibSQL adapter as dependencies.
```bash terminal icon="terminal" theme={"theme":{"light":"github-light","dark":"dracula"}}
bun add -d prisma
bun add @prisma/client @prisma/adapter-libsql
```
Use the Prisma CLI with `bunx` to initialize the schema and migration directory. This guide uses an in-memory SQLite database.
```bash terminal icon="terminal" theme={"theme":{"light":"github-light","dark":"dracula"}}
bunx --bun prisma init --datasource-provider sqlite
```
This creates a basic schema. Open `prisma/schema.prisma`, update the generator block to use the Rust-free client with the `bun` runtime, and add a `User` model.
```prisma prisma/schema.prisma icon="https://mintcdn.com/bun-1dd33a4e-farm-ad2450b3-transpiler-cache-version-namespa/pVrMBuZvntvIe2NO/icons/ecosystem/prisma.svg?fit=max&auto=format&n=pVrMBuZvntvIe2NO&q=85&s=78344fc1befa44c21130a5cb0e965d8e" theme={"theme":{"light":"github-light","dark":"dracula"}}
generator client {
provider = "prisma-client" // [!code ++]
output = "./generated" // [!code ++]
engineType = "client" // [!code ++]
runtime = "bun" // [!code ++]
}
datasource db {
provider = "sqlite"
url = env("DATABASE_URL")
}
model User { // [!code ++]
id Int @id @default(autoincrement()) // [!code ++]
email String @unique // [!code ++]
name String? // [!code ++]
} // [!code ++]
```
Generate and run the initial migration. This writes a `.sql` migration file to `prisma/migrations`, creates a new SQLite database, and runs the migration against it.
```bash terminal icon="terminal" theme={"theme":{"light":"github-light","dark":"dracula"}}
bunx --bun prisma migrate dev --name init
```
```txt theme={"theme":{"light":"github-light","dark":"dracula"}}
Environment variables loaded from .env
Prisma schema loaded from prisma/schema.prisma
Datasource "db": SQLite database "dev.db" at "file:./dev.db"
SQLite database dev.db created at file:./dev.db
Applying migration `20251014141233_init`
The following migration(s) have been created and applied from new schema changes:
prisma/migrations/
└─ 20251014141233_init/
└─ migration.sql
Your database is now in sync with your schema.
✔ Generated Prisma Client (6.17.1) to ./generated in 18ms
```
As the output indicates, Prisma re-generates the *Prisma client* whenever you run a new migration. The client provides a fully typed API for reading and writing to your database. You can also re-generate it manually with the Prisma CLI.
```sh terminal icon="terminal" theme={"theme":{"light":"github-light","dark":"dracula"}}
bunx --bun prisma generate
```
Create a new file `prisma/db.ts` that initializes the PrismaClient with the LibSQL adapter.
```ts prisma/db.ts icon="https://mintcdn.com/bun-1dd33a4e-farm-ad2450b3-transpiler-cache-version-namespa/pVrMBuZvntvIe2NO/icons/typescript.svg?fit=max&auto=format&n=pVrMBuZvntvIe2NO&q=85&s=81fcaf3ac2cead5d758f3588a492f46a" theme={"theme":{"light":"github-light","dark":"dracula"}}
import { PrismaClient } from "./generated/client";
import { PrismaLibSQL } from "@prisma/adapter-libsql";
const adapter = new PrismaLibSQL({ url: process.env.DATABASE_URL || "" });
export const prisma = new PrismaClient({ adapter });
```
Write a script that creates a new user, then counts the users in the database.
```ts index.ts icon="https://mintcdn.com/bun-1dd33a4e-farm-ad2450b3-transpiler-cache-version-namespa/pVrMBuZvntvIe2NO/icons/typescript.svg?fit=max&auto=format&n=pVrMBuZvntvIe2NO&q=85&s=81fcaf3ac2cead5d758f3588a492f46a" theme={"theme":{"light":"github-light","dark":"dracula"}}
import { prisma } from "./prisma/db";
// create a new user
await prisma.user.create({
data: {
name: "John Dough",
email: `john-${Math.random()}@example.com`,
},
});
// count the number of users
const count = await prisma.user.count();
console.log(`There are ${count} users in the database.`);
```
Run the script with `bun run`. Each run creates a new user.
```bash terminal icon="terminal" theme={"theme":{"light":"github-light","dark":"dracula"}}
bun run index.ts
```
```txg theme={"theme":{"light":"github-light","dark":"dracula"}}
Created john-0.12802932895402364@example.com
There are 1 users in the database.
```
```bash terminal icon="terminal" theme={"theme":{"light":"github-light","dark":"dracula"}}
bun run index.ts
```
```txt theme={"theme":{"light":"github-light","dark":"dracula"}}
Created john-0.8671308799782803@example.com
There are 2 users in the database.
```
```bash terminal icon="terminal" theme={"theme":{"light":"github-light","dark":"dracula"}}
bun run index.ts
```
```txt theme={"theme":{"light":"github-light","dark":"dracula"}}
Created john-0.4465968383115295@example.com
There are 3 users in the database.
```
***
Prisma is now set up with Bun. See the [Prisma docs](https://www.prisma.io/docs/orm/prisma-client) as you build out your application.