prisma

What it is and what it does

Prisma Client Python is a code-generated ORM that reads a declarative schema file and produces a fully type-hinted database client. Unlike traditional ORMs where you write queries in Python, Prisma generates the client from your schema, enabling IDE autocompletion and compile-time type checking. It supports both async and sync workflows, atomic updates, relational queries, and batching, with backends for PostgreSQL, MySQL, SQLite, CockroachDB, and experimental support for MongoDB and SQL Server.

The package is built on Rust-based Prisma internals but requires no Node.js or TypeScript knowledge—you define your models in a simple schema language and run `prisma db push` to sync and generate. However, the repository is now archived and abandoned, with the last commit in April 2025 and no ongoing maintenance. This means no new features, no active bug fixes, and potential incompatibility with future Python or database versions.

Use it for

• Building REST or GraphQL APIs where type safety and IDE autocompletion for database queries reduce errors and development time.
• Projects requiring both async and sync database access patterns without switching ORMs or writing dual code paths.
• Applications needing schema-driven migrations and type-safe relational queries across PostgreSQL, MySQL, or SQLite.
• Teams using Pylance or Pyright where Prisma's autocompletion support provides a significant developer experience advantage.
• Prototyping or maintaining existing Prisma Python projects, though new projects should consider actively maintained alternatives.

Worth the install?

AI-flagged interpretation of the facts on this page. Verify before relying on it.

Install

prisma on PyPI

Before you install

Low install friction with a pure-Python wheel and ten runtime dependencies. However, the repository is archived and marked abandoned as of the fact sheet date, with the last commit in April 2025 and no active maintenance—a significant concern for a database tool where schema compatibility and bug fixes matter.

Requires a Prisma schema file (schema.prisma) in your project root defining data models and database connection; the repository is archived and no longer maintained.

License in practice

Licensed under Apache 2.0 (permissive), which allows commercial and private use without restriction, though you should verify compatibility with your project's license stack.

Quickstart

pip install prisma

# Create schema.prisma with your models, then:
prisma db push

# In your code:
import asyncio
from prisma import Prisma

async def main():
    db = Prisma()
    await db.connect()
    user = await db.user.create(data={'name': 'Alice', 'email': 'alice@example.com'})
    await db.disconnect()

asyncio.run(main())

Package facts

Evidence: prisma-0.15.0-py3-none-any.whl

Tags

More Python Modules packages

See also prisma-sase · tortoise-orm · sqlalchemy-cockroachdb · ormar · sqlalchemy-jdbcapi · sqlmodel · databases · pysqlsync · pony · marshmallow-sqlalchemy