Databases with Prisma

Prisma ORM

Prisma is the most popular ORM for TypeScript. It generates a fully-typed client from your schema, making database queries safe and autocompleted.

Schema Definition

Define your models in schema.prisma using a declarative syntax. Prisma Migrate generates and runs SQL migrations.

Querying

Prisma Client provides chainable methods: findMany, findUnique, create, update, delete. All return typed results matching your schema.

const users = await prisma.user.findMany({ where: { active: true } })

Connection Pooling

In serverless environments like Vercel, use Prisma Accelerate or a connection pooler like PgBouncer to avoid exhausting database connections.