Sea Orm

🐚 An async & dynamic ORM for Rust
Alternatives To Sea Orm
Project NameStarsDownloadsRepos Using ThisPackages Using ThisMost Recent CommitTotal ReleasesLatest ReleaseOpen IssuesLicenseLanguage
Prisma35,08744216 hours ago4,993September 24, 20223,033apache-2.0TypeScript
Next-generation ORM for Node.js & TypeScript | PostgreSQL, MySQL, MariaDB, SQL Server, SQLite, MongoDB and CockroachDB
Typeorm32,5621,9943,6832 days ago784October 05, 20232,296mitTypeScript
ORM for TypeScript and JavaScript. Supports MySQL, PostgreSQL, MariaDB, SQLite, MS SQL Server, Oracle, SAP Hana, WebSQL databases. Works in NodeJS, Browser, Ionic, Cordova and Electron platforms.
Prisma116,62659212a year ago859January 12, 20212apache-2.0Scala
💾 Database Tools incl. ORM, Migrations and Admin UI (Postgres, MySQL & MongoDB) [deprecated]
Efcore12,9833,5759,59120 hours ago188November 14, 20231,997mitC#
EF Core is a modern object-database mapper for .NET. It supports LINQ queries, change tracking, updates, and schema migrations.
Greendao12,595781618 days ago11November 12, 2015235Java
greenDAO is a light & fast ORM solution for Android that maps objects to SQLite databases.
Sqlalchemy8,09941,8535,930a day ago294November 02, 2023207mitPython
The Database Toolkit for Python
Exposed7,5994120 hours ago27November 28, 2023247apache-2.0Kotlin
Kotlin SQL Framework
Sled7,4104329224 days ago100September 11, 2023138apache-2.0Rust
the champagne of beta embedded databases
Mikro Orm6,67418917 hours ago2,311December 04, 202355mitTypeScript
TypeScript ORM for Node.js based on Data Mapper, Unit of Work and Identity Map patterns. Supports MongoDB, MySQL, MariaDB, PostgreSQL and SQLite databases.
Bookshelf6,3386,4174422 months ago88June 07, 2020235mitJavaScript
A simple Node.js ORM for PostgreSQL, MySQL and SQLite3 built on top of Knex.js
Alternatives To Sea Orm
Select To Compare

Alternative Project Comparisons


🐚 An async & dynamic ORM for Rust

crate docs build status


SeaORM is a relational ORM to help you build web services in Rust with the familiarity of dynamic languages.

GitHub stars If you like what we do, consider starring, sharing and contributing!

Please help us with maintaining SeaORM by completing the SeaQL Community Survey 2023!

Getting Started

Integration examples:


Discord Join our Discord server to chat with other members of the SeaQL community!

Professional support on Rust programming and best practices is available. You can email us for a quote!


  1. Async

    Relying on SQLx, SeaORM is a new library with async support from day 1.

  2. Dynamic

    Built upon SeaQuery, SeaORM allows you to build complex dynamic queries.

  3. Testable

    Use mock connections and/or SQLite to write tests for your application logic.

  4. Service Oriented

    Quickly build services that join, filter, sort and paginate data in REST, GraphQL and gRPC APIs.

A quick taste of SeaORM


use sea_orm::entity::prelude::*;

#[derive(Clone, Debug, PartialEq, DeriveEntityModel)]
#[sea_orm(table_name = "cake")]
pub struct Model {
    pub id: i32,
    pub name: String,

#[derive(Copy, Clone, Debug, EnumIter, DeriveRelation)]
pub enum Relation {
    #[sea_orm(has_many = "super::fruit::Entity")]

impl Related<super::fruit::Entity> for Entity {
    fn to() -> RelationDef {


// find all models
let cakes: Vec<cake::Model> = Cake::find().all(db).await?;

// find and filter
let chocolate: Vec<cake::Model> = Cake::find()

// find one model
let cheese: Option<cake::Model> = Cake::find_by_id(1).one(db).await?;
let cheese: cake::Model = cheese.unwrap();

// find related models (lazy)
let fruits: Vec<fruit::Model> = cheese.find_related(Fruit).all(db).await?;

// find related models (eager)
let cake_with_fruits: Vec<(cake::Model, Vec<fruit::Model>)> =


let apple = fruit::ActiveModel {
    name: Set("Apple".to_owned()),
    ..Default::default() // no need to set primary key

let pear = fruit::ActiveModel {
    name: Set("Pear".to_owned()),

// insert one
let pear = pear.insert(db).await?;

// insert many
Fruit::insert_many([apple, pear]).exec(db).await?;


use sea_orm::sea_query::{Expr, Value};

let pear: Option<fruit::Model> = Fruit::find_by_id(1).one(db).await?;
let mut pear: fruit::ActiveModel = pear.unwrap().into(); = Set("Sweet pear".to_owned());

// update one
let pear: fruit::Model = pear.update(db).await?;

// update many: UPDATE "fruit" SET "cake_id" = NULL WHERE "fruit"."name" LIKE '%Apple%'
    .col_expr(fruit::Column::CakeId, Expr::value(Value::Int(None)))


let banana = fruit::ActiveModel {
    id: NotSet,
    name: Set("Banana".to_owned()),

// create, because primary key `id` is `NotSet`
let mut banana =; = Set("Banana Mongo".to_owned());

// update, because primary key `id` is `Set`
let banana =;


// delete one
let orange: Option<fruit::Model> = Fruit::find_by_id(1).one(db).await?;
let orange: fruit::Model = orange.unwrap();

// or simply
let orange: Option<fruit::Model> = Fruit::find_by_id(1).one(db).await?;
let orange: fruit::Model = orange.unwrap();

// delete many: DELETE FROM "fruit" WHERE "fruit"."name" LIKE 'Orange'

🧭 Seaography: GraphQL integration (preview)

Seaography is a GraphQL framework built on top of SeaORM. Seaography allows you to build GraphQL resolvers quickly. With just a few commands, you can launch a GraphQL server from SeaORM entities!

Starting 0.12, seaography integration is built into sea-orm. While Seaography development is still in an early stage, it is especially useful in prototyping and building internal-use admin panels.

Look at the Seaography Example to learn more.

Learn More

  1. Design
  2. Architecture
  3. Engineering
  4. Change Log

Who's using SeaORM?

The following products are powered by SeaORM:

A lightweight web security auditing toolkit

The enterprise ready webhooks service

A personal search engine

For more projects, see Built with SeaORM. Feel free to submit yours!


Licensed under either of

at your option.


Unless you explicitly state otherwise, any contribution intentionally submitted for inclusion in the work by you, as defined in the Apache-2.0 license, shall be dual licensed as above, without any additional terms or conditions.

SeaORM is a community driven project. We welcome you to participate, contribute and together help build Rust's future.

A big shout out to our contributors!


Sponsorship is an independent open-source organization run by passionate developers. If you enjoy using our libraries, please star and share our repositories. If you feel generous, a small donation via GitHub Sponsor will be greatly appreciated, and goes a long way towards sustaining the organization.

We invite you to participate, contribute and together help build Rust's future.


A friend of Ferris, Terres the hermit crab is the official mascot of SeaORM. His hobby is collecting shells.

Popular Orm Projects
Popular Database Projects
Popular Data Processing Categories
Related Searches

Get A Weekly Email With Trending Projects For These Categories
No Spam. Unsubscribe easily at any time.