// the find
RobertCraigie/prisma-client-py
Prisma Client Python is an auto-generated and fully type-safe database client designed for ease of use
A Python wrapper around Prisma's Rust query engine that gives you type-safe database access with full async/sync support and Pydantic model integration. It targets Python developers who want the TypeScript Prisma experience without writing TypeScript. The project is now abandoned — the maintainer posted an end-of-maintenance notice in early 2025.
The TypedDict-based query API is genuinely well-designed: IDE autocompletion works out of the box with Pyright and the types catch real mistakes at write time, not runtime. Both async and sync clients are first-class, which is unusual — most Python ORMs bolt on async as an afterthought. The test suite is thorough and database-matrix-tested across Postgres, MySQL, SQLite, and CockroachDB with snapshot tests. The Pydantic model output means query results drop straight into FastAPI responses without any transformation layer.
The project is dead — the README has a prominent warning and the maintainer explicitly said in issue #1073 they will not be maintaining it. Adopting this in 2025 means you own the dependency. The architecture is genuinely weird: generating Python client code via a Node.js binary that calls a Rust query engine is a three-layer dependency chain with non-obvious failure modes, and the Node download on first run surprises everyone. Pinned to Prisma 5.19.0 with no path forward. MongoDB support is still marked experimental after years of development.