Crate sea_orm

source ·
Expand description


🐚 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 2024!

§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?

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.

§Gold Sponsors


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




  • Module for the Entity type and operations
  • Error types for all database operations
  • Holds types and methods to perform metric collection
  • Holds types and methods to perform queries
  • Holds types that defines the schemas of an Entity




  • Access mode
  • The type of database backend for real world databases. This is enabled by feature flags as specified in the crate documentation
  • Handle a database connection depending on the backend enabled by the feature flags. This creates a database pool.
  • Isolation level
  • Defines errors for handling transaction failures
  • An error from trying to get a row from a Model
  • The types of results for an INSERT operation
  • Value variants



Type Aliases§

Derive Macros§

  • A derive macro to implement sea_orm::ActiveEnum trait for enums.
  • The DeriveActiveModel derive macro will implement ActiveModelTrait for ActiveModel which provides setters and getters for all active values in the active model.
  • Models that a user can override
  • The DeriveColumn derive macro will implement [ColumnTrait] for Columns. It defines the identifier of each column by implementing Iden and IdenStatic. The EnumIter is also derived, allowing iteration over all enum variants.
  • Derive a column if column names are not in snake-case
  • Create an Entity
  • This derive macro is the ‘almighty’ macro which automatically generates Entity, Column, and PrimaryKey from a given Model.
  • The DeriveIden derive macro will implement sea_orm::sea_query::Iden for simplify Iden implementation.
  • Derive into an active model
  • The DeriveMigrationName derive macro will implement sea_orm_migration::MigrationName for a migration.
  • The DeriveModel derive macro will implement ModelTrait for Model, which provides setters and getters for all attributes in the mod It also implements FromQueryResult to convert a query result into the corresponding Model.
  • The DerivePartialModel derive macro will implement sea_orm::PartialModelTrait for simplify partial model queries.
  • The DerivePrimaryKey derive macro will implement [PrimaryKeyToColumn] for PrimaryKey which defines tedious mappings between primary keys and columns. The EnumIter is also derived, allowing iteration over all enum variants.
  • The DeriveRelatedEntity derive macro will implement seaography::RelationBuilder for RelatedEntity enumeration.
  • The DeriveRelation derive macro will implement RelationTrait for Relation.
  • Implements traits for types that wrap a database value type.
  • Creates a new type that iterates of the variants of an enum.
  • Convert a query result into the corresponding Model.