orm 4.0.3

Next-generation ORM for Dart & Flutter | PostgreSQL, MySQL, MariaDB, SQL Server, SQLite, MongoDB and CockroachDB.

Prisma Client Dart

Prisma Client Dart is an auto-generated type-safe ORM. It uses Prisma Engine as the data access layer and is as consistent as possible with the Prisma Prisma Client JS/TS APIs.

👉 Learn how to use Prisma ORM for Dart in your project.

import 'package:orm/orm.dart';

final client = PrismaClient();

main() {
  final users = await client.user.findMany();
}

Tip

Prisma Client Dart is an open source project developed and maintained by Seven Du, which allows you to use Prisma ORM in the Dart language. Prisma is Next-generation Node.js and TypeScript ORM.

If your back-end project uses Node.js or Bun.js, it is highly recommended that you take a look 👉 Prisma ORM Official

Other language implementations in community 👉 Prisma Ecosystem.

Installation

This will add a like this to you packages pubspec.yaml (and run an implicit dart pub get):

dependencies:
  orm: latest

Or you can run the following command:

dart pub add orm

Sponsors

Prisma Client Dart is an BSD-3 Clause licensed open source project with its ongoing development made possible entirely by the support of these awesome backers. If you'd like to join them, please consider sponsoring Seven(@medz) or Odroe on GitHub.

Documentation

You can find the Prisma Client Dart on the website.

The documentation is divided into the following sections:

• Getting Started
  • Setup & Configuration
  • Prisma Schema
• Queries
  • CRUD
  • Select Fields
  • Relation queries
  • Filtering and Sorting
  • Pagination
  • Aggregation, grouping, and summarizing
  • Transactions
  • Raw database access

You can improve it by sending pull requests to docs folder in the main branch.

Examples

You can also find them in the example folder in the main branch.

Query engine support matrix

Engine	Dart Native	Dart Web	Flutter Native	Flutter Web
Binary	✅	❌	❌	❌
Library	✅	❌	✅	❌
Data Proxy	✅	✅	✅	✅

Contributing

We welcome contributions! Please read our contributing guide to learn about our development process, how to propose bugfixes and improvements, and how to build and test your changes to Prisma.

Thank you to all the people who already contributed to Odroe!

Code of Conduct

This project has adopted the Contributor Covenant Code of Conduct. For more information see the Code of Conduct FAQ or contact [e-mail] with any additional questions or comments.