This is not directly supported by Prisma. There is an open feature request that you could +1 here.
Best workaround for now would be to writes scripts that use the CLI commands.
Answer from Austin Crim on Stack OverflowPrisma Client Python
prisma-client-py.readthedocs.io › en › stable › getting_started › advanced
Advanced Usage - Prisma Client Python
# apply migrations prisma migrate dev --name "add comment model" # generate prisma generate
Prisma
prisma.io › home › getting started with prisma migrate › getting started with prisma migrate › getting started with prisma migrate
Getting started with Prisma Migrate | Prisma Documentation
Learn how to migrate your schema in a development environment using Prisma Migrate.
GitHub
github.com › RobertCraigie › prisma-client-py
GitHub - RobertCraigie/prisma-client-py: Prisma Client Python is an auto-generated and fully type-safe database client designed for ease of use · GitHub
However, the arguably best feature that Prisma Client Python provides is autocompletion support (see the GIF above). This makes writing database queries easier than ever! Core features: Prisma Migrate · Full type safety · With / without async · Recursive and pseudo-recursive types ·
Starred by 2.1K users
Forked by 94 users
Languages Python 92.7% | Jinja 6.8%
Prisma Client Python
prisma-client-py.readthedocs.io
Prisma Client Python
However, the arguably best feature that Prisma Client Python provides is autocompletion support (see the GIF above). This makes writing database queries easier than ever! Core features: Prisma Migrate · Full type safety · With / without async · Recursive and pseudo-recursive types ·
Prisma
prisma.io › home › overview of prisma migrate › overview of prisma migrate
Prisma Migrate: Database, Schema, SQL Migration Tool | Prisma Documentation
Prisma Migrate is a database migration tool available via the Prisma CLI that integrates with Prisma schema for data modeling.
Prisma Client Python
prisma-client-py.readthedocs.io › en › stable › getting_started › quickstart
Quick Start - Prisma Client Python
To get this up and running in your database, we use the Prisma migration tool db push to create and migrate our database:
Medium
lewoudar.medium.com › alternatives-to-sqlalchemy-for-your-project-prisma-case-9df8ce037578
Alternatives to SQLAlchemy for your project — Prisma case | by Kevin Tewouda | Medium
December 27, 2022 - prisma migrate deploy: Apply a migration file on a production environment. prisma py version: Show debugging information about the python client, Prisma version supported, binaries, etc...
Medium
medium.com › @saveriomazza › introduction-to-prisma-client-python-90a252151a4f
Introduction to Prisma Client Python | by Saverio Mazza | Medium
March 25, 2024 - Additionally, Prisma Client Python offers unparalleled autocompletion support, making the process of writing database queries significantly easier and more efficient. Prisma Migrate: Simplifies database migrations....
DEV Community
dev.to › mihaiandrei97 › a-beginners-guide-to-building-a-flask-api-with-prisma-1g6i
A beginners guide to building a Flask API with Prisma - DEV Community
July 1, 2022 - Now, let's create the database with Prisma. You can do it by creating a migration using: ... and providing a name for the migration, for example, init. After that, you will have a sqlite database inside the root folder. Now, on the python side.
Reddit
reddit.com › r/fastapi › prisma vs alembic for managing database schema and migrations
r/FastAPI on Reddit: Prisma vs Alembic for managing database schema and migrations
April 25, 2023 -
I’ve been experimenting with building a large fastapi project for a client and recently started using prisma cli for managing my database migrations.
Prisma python has bindings to the rust based cli by prisma.io and the cli has been growing rapidly in the typescript community.
Do you think this is an easier solution to adopting sqlAlchemy and alembic for managing db and migrations with fastapi?
If you need more context someone has already produced a short tutorial on prisma python.
https://lewoudar.medium.com/alternatives-to-sqlalchemy-for-your-project-prisma-case-9df8ce037578
Note: Prisma python client is a small project supported by prisma.io but Prisma cli has been around for quite a while and loved by the typescript community.
Top answer 1 of 2
4
Prisma is great for sure! My two cents are simple. It depends of which ORM you are using. If you are with SQLALCHEMY, no brainer for alembic and that is because it's mature, widely adopted, massive community and more importantly, built by the same author of SQLAlchemy and that is guaranteed support. Prisma on the other hand, like you said, it's still recent and I'm not 100% confident how would work with SQLAlchemy here. If you are into other ORMs, then why not? :) I built one based on SQLAlchemy core and brings native migrations as well and that is on the top of alembic. https://saffier.tarsild.io - it's framework agnostic and works really well with FastAPI In the end it comes down to which one you feel more confident and comfortable.
2 of 2
1
I don't see how this is better than sqlalchemy: u have no hints, no auto completion, defining models requires a foreign language... I don't see it easier to work with. Sqlalchemy changed greatly in its v2, and yes, despite its api not being the most comfy one, so far I can say it really is the most powerful one. And yes, I also love django's orm :P
Michael's Website
kjune.com › home › posts › dev › prisma orm tutorial: type-safe database queries for python & javascript
Michael's Website | Prisma ORM Tutorial: Type-Safe Database Queries for Python & JavaScript
September 15, 2024 - Complete Prisma ORM guide for Python and JavaScript developers. Build type-safe PostgreSQL queries, manage migrations, and boost productivity.
Prisma
prisma.io › migrate
Prisma Migrate | Database Migrations for Prisma ORM
Prisma Migrate generates migrations based on changes in the Prisma schema – a human-readable declarative definition of your database schema.
Prisma Client Python
prisma-client-py.readthedocs.io › en › v0.2.2
Prisma Client Python - Read the Docs
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.
PyPI
pypi.org › project › prisma
prisma · PyPI
However, the arguably best feature that Prisma Client Python provides is autocompletion support (see the GIF above). This makes writing database queries easier than ever! Core features: Prisma Migrate · Full type safety · With / without async · Recursive and pseudo-recursive types ·
» pip install prisma
YouTube
youtube.com › code with struckchure
Prisma ORM with Python and FastAPI - YouTube
🚀 Dive into the world of Prisma ORM and revolutionize your Python development! This tutorial will explore the basics of using Prisma ORM to enhance your dat...
Published December 20, 2023 Views 2K
Medium
medium.com › @SahilSharma_SoftwareDeveloper › migrations-in-prisma-0a2f4e660e14
Migrations in Prisma. Migrations in Prisma are a systematic… | by Sahil Sharma | Medium
March 10, 2024 - Migrations in Prisma are a systematic way to evolve your database schema over time in a version-controlled manner. They allow you to define incremental changes to your database schema, making it easy to modify and extend over the lifecycle of ...
Prisma
prisma.io › home › migrate to prisma v7 › migrate to prisma v7 › migrate to prisma v7
Migrate to Prisma v7 | Prisma Documentation
(No code changes were applied automatically.) ``` ### 🟦 If Accelerate is not detected at all ``` Direct TCP is the recommended default for Prisma v7. Your project will be migrated accordingly using the appropriate adapter. ``` --- ## 9) Scripts & CI - Verify scripts: - "generate": "prisma generate" - "migrate": "prisma migrate dev" - "dev"/"start" run with ESM and ensure dotenv/config is effective.
Wasp
wasp.sh › blog › 2025 › 04 › 02 › an-introduction-to-database-migrations
A Gentle Introduction to Database Migrations in Prisma with Visuals | Wasp
April 2, 2025 - Once you've written a Prisma schema for your app, you'll need to create a migration file. This file will contain SQL commands needed to update your database, such as creating new tables or modifying existing ones, or adding database indexes, etc.