Skip to content

Flutter Integration

Prisma ORM for Dart allows you to integrate it in Flutter Project.

Platform Support

macOSPrisma C-ABI not support
LinuxPrisma C-ABI not support
WindowsPrisma C-ABI not support
WebNo plans at the moment

Database Support

MySQL/MariaDBPrisma C-ABI not support
PostgreSQLPrisma C-ABI not support
MongoDBPrisma C-ABI not support
Microsoft SQL ServerPrisma C-ABI not support
CockroachDBPrisma C-ABI not support


You should first read the Installation Documentation, and Setup Prisma ORM of the orm package.

Now, let’s install the orm_flutter package, you can use the command line:

flutter pub add orm_flutter

Or edit your Flutter project’s pubspce.yaml file:

   orm_flutter: latest


Set your generator engine type to flutter in your Prisma schema (schema.prisma):

generator client {
  provider   = "dart run orm"
  output     = "../lib/_generated_prisma_client"
  engineType = "flutter"


Unlike server-side, databases in Flutter are not typically handled by you in the Prisma CLI before building.

Create migration file

bun prisma migrate dev
npx prisma migrate dev
pnpx prisma migrate dev

Notes: By default it is created in the prisma/migrations/ folder.

Set migration files to flutter assets

Now, let's edit your pubspec.yaml:

     - prisma/migrations/ # Migrations root dir
     - prisma/migrations/<dir>/ # Set first migration files dir
     # ... More assets

Notes: Each migration folder generated using the prisma migrate dev command needs to be added.

Run migration

final engine = prisma.$engine as LibraryEngine;

await engine.applyMigrations(
     path: 'prisma/migrations/', // You define in `flutter.assets` migrations root dir


In addition to using flutter.assets, you can customize AssetBundle to achieve:

await engine.applyMigrations(
  path: '<Your migration dir prefix>',
  bundle: <You custon bundle>,

Also, engine.applyMigrations may throw exceptions. This is usually caused by your destructive changes to the migration files, and you should handle this yourself. The most common method is to delete the database file after throwing the exception, and then rerun the migration.

If you are adding a new migration, there will be almost no problems.

Complete integration example

In this Example, we will install these packages:

We install the database in the <Application Support Directory>/database.sqlite location and then use flutter.assets to run the migration

import 'package:flutter/widgets.dart';
import 'package:orm_flutter/orm_flutter.dart';
import 'package:path/path.dart';
import 'package:path_provider/path_provider.dart';

import '_generated_prisma_client/client.dart';

late final PrismaClient prisma;

Future<void> initPrismaClient() async {

  final supportDir = await getApplicationSupportDirectory();
  final database = join(supportDir.path, 'database.sqlite.db');

  prisma = PrismaClient(datasourceUrl: 'file:$database');
  final engine = switch (prisma.$engine) {
    LibraryEngine engine => engine,
    _ => null,

  await prisma.$connect();
  await engine?.applyMigrations(path: 'prisma/migrations');
import 'prisma.dart';

Future<void> main() async {
     await initPrismaClient();

     // ...

Example App

We provide you with a demo App that integrates Prisma ORM in Flutter 👉 Flutter with ORM


Error (Xcode): Undefined symbol: prisma_*

This is due to a library compilation failure, which will persist even if you download a new fixed version.

Solution: Run the command:

flutter clean

Not fond */query_engine/*/libquery_engine.a file

This is because the automatic download of the Prisma static query engine library failed.

To fix it, run the following command:

dart run orm_flutter:dl_engine

Other unknown error solutions:

Most problems can be solved by using the following combination of commands:

flutter clean # Clean flutter cache files
flutter pub get # Reinstall deps
dart run orm_flutter:dl_engine # Download prisma engine static library
<bun/npx/pnpx/yarn> prisma generate # Regenerate prisma client

Every time you update the orm_flutter version

Since the Prisma C-ABI engine is available on CDN, the Flutter plugin does not support running a script before build. Plus, has a package size limit.

So, after you install the new orm_flutter package, it does not include the Prisma Engine, and you need to run the following command to download it:

dart run orm_flutter:dl_engine

It is best to run flutter clean to reset the native build after re-downloading the engine. Note that the cleanup is only required for iOS.

If you have installed both orm and orm_flutter dependencies and generated the Prisma client for Flutter, you only need to run prisma generate, which will automatically find and download the engine. This greatly simplifies the initialization work.

Released under the BSD-3-Clause License