An auto-generated, fully type-safe database client for Python built on Prisma, supporting async and sync usage.
Prisma Client Python is an auto-generated, fully type-safe database client for Python that provides an intuitive ORM layer on top of Prisma's query engine. It solves the problem of error-prone database interactions by offering static type checking and autocompletion for queries, supporting both async and sync patterns. The tool generates client code from a Prisma schema, ensuring that database operations align with the defined data models.
Python backend developers building REST APIs, GraphQL APIs, or any application requiring robust and type-safe database access. It is particularly useful for teams prioritizing code correctness and developer experience in data-intensive projects.
Developers choose Prisma Client Python for its seamless integration with Prisma's ecosystem, offering full type safety without sacrificing performance. Its unique autocompletion support and support for complex relational queries reduce boilerplate and errors, making it a productive alternative to traditional Python ORMs.
Prisma Client Python is an auto-generated and fully type-safe database client designed for ease of use
Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.
Provides statically typed queries that catch errors before runtime, as emphasized in the README with examples of type-safe database operations, enhancing code reliability.
Offers flexible client configuration for both asynchronous and synchronous applications, allowing developers to choose based on project needs without sacrificing features.
Enables IDE autocompletion for query arguments via TypedDicts, improving developer productivity, though it's limited to supported editors like VSCode with Pylance.
Supports relational queries, atomic updates, and batching operations natively, allowing for sophisticated database interactions without manual SQL.
Seamlessly handles database schema migrations alongside client generation, ensuring consistency between code and database structure as described in the documentation.
The project has been discontinued with no future updates or bug fixes, as explicitly warned in the README, making it risky for any new development.
MongoDB and SQL Server support is labeled as experimental in the README, indicating it may be unstable or incomplete for production use.
Admits in the README that performance has not been worked on and there is room for improvement, which could impact high-throughput applications.
Auto-completion does not work effectively in PyCharm due to unresolved issues with TypedDicts, reducing usability for developers relying on that IDE.