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

Prisma Client Python is a type-safe ORM that generates a fully typed database client from a schema file, supporting both synchronous and asynchronous access to PostgreSQL, MySQL, SQLite, CockroachDB, and experimental MongoDB and SQL Server.

Yes-with-conditions. Prisma Client Python is well-designed and offers genuine advantages in type safety and autocompletion if your team uses Pylance/Pyright. However, the repository is archived and abandoned—install only if you are maintaining an existing project or willing to fork and maintain it yourself. For new projects, strongly consider an actively maintained alternative like SQLAlchemy or Tortoise ORM to avoid future compatibility and security risks.

Install

prisma on PyPI

pip install prisma

uv add prisma

poetry add prisma

Installing prisma

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.

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())

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.

Verify before relying

• Whether the abandoned status affects real-world stability or if the package remains functional for existing projects.
• Current compatibility with modern Python 3.12+ and recent database driver versions.
• Whether security patches or critical bug fixes are still being backported or if the codebase is truly frozen.

Package facts

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

Keywords: orm, mysql, typing, prisma, sqlite, database, postgresql

Tags

More Python Modules packages