🌐
Prisma
prisma.io › home › prisma client › prisma client
Prisma Client overview | Prisma Documentation
Prisma Client is Prisma ORM's generated query builder. It is tailored to your schema, fully typed, and designed to make common database work feel like ordinary application code.
🌐
npm
npmjs.com › package › @prisma › client
prisma/client
1 week ago - Prisma Client JS is an auto-generated query builder that enables type-safe database access and reduces boilerplate. You can use it as an alternative to traditional ORMs such as Sequelize, TypeORM or SQL query builders like knex.js.
      » npm install @prisma/client
    
Published   Jul 20, 2026
Version   7.9.0
🌐
Prisma
prisma.io › client
Prisma Client | Type-Safe Query Builder for Node.js and TypeScript
Generate a type-safe database client from your Prisma schema to query PostgreSQL, MySQL, SQLite, SQL Server, MongoDB, and CockroachDB with confidence.
🌐
GitHub
github.com › prisma › prisma
GitHub - prisma/prisma: Next-generation ORM for Node.js & TypeScript | PostgreSQL, MySQL, MariaDB, SQL Server, SQLite, MongoDB and CockroachDB · GitHub
Prisma ORM is a next-generation ORM that consists of these tools: Prisma Client: Auto-generated and type-safe query builder for Node.js & TypeScript
Author   prisma
🌐
Prisma
prisma.io › home › what is prisma orm? › what is prisma orm? › what is prisma orm? › what is prisma orm? › what is prisma orm?
What is Prisma ORM? (Overview) | Prisma Documentation
Prisma ORM is an open-source next-generation ORM. It consists of the following parts: Prisma Client: Auto-generated and type-safe query builder for Node.js & TypeScript
🌐
Prisma
prisma.io › home › what are client extensions › what are client extensions › what are client extensions
Prisma Client extensions | Prisma Documentation
For example, you might create an extension that uses the model and client component types. When you use a Prisma Client extension, you create an extended client. An extended client is a lightweight variant of the standard Prisma Client that is wrapped by one or more extensions.
🌐
Prisma Client Python
prisma-client-py.readthedocs.io
Prisma Client Python
Prisma Client Python is a next-generation ORM built on top of Prisma that has been designed from the ground up for ease of use and correctness. Prisma is a TypeScript ORM with zero-cost type safety for your database, although don't worry, Prisma Client Python interfaces with Prisma using Rust, ...
🌐
Prisma
v1.prisma.io › docs › 1.34 › understand-prisma › prisma-basics-datamodel-client-and-server-fgz4
Prisma 1.34 - Prisma Basics: Datamodel, Prisma Client & Server
For traditional ORMs, such a set of write operations requires you to manually control a database transaction. Prisma client handles the transaction for you. The operations exposed by your Prisma client are strongly typed.
Find elsewhere
🌐
Prisma
prisma.io
Prisma | Agent Infrastructure for TypeScript
Prisma ORM gives TypeScript developers a schema-first workflow with a generated client, autocomplete, and compile-time guarantees.
🌐
GitHub
github.com › prisma › prisma-client-js
GitHub - prisma/prisma-client-js: Type-safe database client for TypeScript & Node.js (ORM replacement) · GitHub
January 14, 2021 - Prisma Client JS is an auto-generated query builder that enables type-safe database access and reduces boilerplate. You can use it as an alternative to traditional ORMs such as Sequelize, TypeORM or SQL query builders like knex.js.
Starred by 1.5K users
Forked by 63 users
Languages   TypeScript
🌐
Built In
builtin.com › articles › prisma
What Is Prisma? A Guide. | Built In
June 10, 2025 - Prisma Client is a type-safe database client that is generated based on your Prisma Schema. This means that every query you make using Prisma Client is validated by the schema, ensuring that you’re always working with valid data.
🌐
Peerlist
peerlist.io › scroll › post › ACTHDNEMKD8JQ9MPAF7MP9RAMGQ67M
what is prisma client and why we use it
February 23, 2025 - Prisma Client is an auto-generated, type-safe database client for Node.js and TypeScript applications. It is part of the Prisma ORM (Object-Relational Mapping) tool, which simplifies database access by providing an intuitive API for querying ...
🌐
Prisma
prisma.io › blog › prisma-client-preview-ahph4o1umail
Prisma Client in Preview: Simplified & Type-safe Database Access
September 11, 2018 - The Prisma client is an auto-generated library that can be used as an alternative to Prisma bindings to access data in your applications. It is available in JavaScript, TypeScript, Flow and Go.
Top answer
1 of 10
103

An alternate method (my preferrence) to get the "full" type, or the model with all of its possible relations, is to use the GetPayload version of your model type. The type is a generic that can receive the same object you pass to your query.

import { PrismaClient, Prisma } from "@prisma/client";

const prisma = new PrismaClient();

type UserWithCars = Prisma.UserGetPayload<{
  include: {
    cars: true;
  }
}>

const usersWithCars = await prisma.user.findMany({
  include: {
    cars: true,
  }
});

As your query grows more complex, you may want to abstract it and ensure that it is strongly typed.

import { Prisma, PrismaClient } from "@prisma/client";

const prisma = new PrismaClient();

const userInclude = Prisma.validator<Prisma.UserInclude>()({
  cars: true,
});

type UserWithCars = Prisma.UserGetPayload<{
  include: typeof userInclude;
}>;

const usersWithCars = await prisma.user.findMany({
  include: userInclude,
});

2 of 10
20

You can use the Prisma Validator API along with some typescript features to generate types for your query.

For the findMany example you mentioned

import { Prisma } from '@prisma/client'

// 1. Define a User type that includes the "cars" relation. 
const userWithCars = Prisma.validator<Prisma.UserArgs>()({
    include: { cars: true },
})

// 2: This type will include many users and all their cars
type UserWithCars = Prisma.UserGetPayload<typeof userWithCars>[]

If you simply want to automatically infer the return type of a prisma query wrapped in a function, you can use PromiseReturnType.

For example:

import { Prisma } from '@prisma/client'

async function getUsersWithCars() {
  const users = await prisma.user.findMany({ include: { cars: true } });
  return users;
}

type UsersWithCars = Prisma.PromiseReturnType<typeof getUsersWithCars>

You can read more about this in the Operating against partial structures of your model types concept guide in the Prisma docs.

🌐
PyPI
pypi.org › project › prisma-client
prisma-client · PyPI
August 26, 2021 - Prisma Client Python is an unofficial implementation of Prisma which is a next-generation ORM that comes bundled with tools, such as Prisma Migrate, which make working with databases as easy as possible.
      » pip install prisma-client
    
Published   Oct 15, 2021
Version   0.2.1
🌐
Prisma
prisma.io › home › prisma client api reference › prisma client api reference › prisma client api reference › prisma client api reference
Prisma Client API | Prisma Documentation
Available for MongoDB only in Prisma 3.10.0 and later. Composite type methods allow you to create, update and delete composite types. Use set to overwrite the value of a composite type.
🌐
Medium
medium.com › @saveriomazza › introduction-to-prisma-client-python-90a252151a4f
Introduction to Prisma Client Python | by Saverio Mazza | Medium
March 25, 2024 - Prisma Client Python is a modern ORM (Object-Relational Mapping) tool designed to provide Python developers with a more intuitive way to interact with databases. It’s built on top of Prisma, a TypeScript ORM known for its zero-cost type safety ...
🌐
Medium
medium.com › @truongtronghai › orm-prisma-client-models-and-types-e88aee533bf5
ORM Prisma client, models and types | by Truong Trong Hai | Medium
September 19, 2024 - This imports the User and Post types directly from the @prisma/client package. ... You can now use these types to ensure type safety in your functions, state, and other parts of your code.
🌐
PyPI
pypi.org › project › prisma
prisma · PyPI
Prisma is a TypeScript ORM with zero-cost type safety for your database, although don't worry, Prisma Client Python interfaces with Prisma using Rust, you don't need Node or TypeScript.
      » pip install prisma
    
Published   Aug 16, 2024
Version   0.15.0