#diesel #crud #database #codegen #generation

bin+lib dsync

Generate rust structs & query functions from diesel schema files

16 releases

0.0.17 Sep 4, 2023
0.0.16 Aug 20, 2023
0.0.14 Jul 15, 2023
0.0.13 Mar 26, 2023
0.0.3 Oct 28, 2022

#66 in FFI

Download history 36/week @ 2023-06-05 38/week @ 2023-06-12 57/week @ 2023-06-19 62/week @ 2023-06-26 85/week @ 2023-07-03 63/week @ 2023-07-10 55/week @ 2023-07-17 46/week @ 2023-07-24 48/week @ 2023-07-31 73/week @ 2023-08-07 119/week @ 2023-08-14 181/week @ 2023-08-21 125/week @ 2023-08-28 147/week @ 2023-09-04 93/week @ 2023-09-11 49/week @ 2023-09-18

490 downloads per month


2.5K SLoC


License: MIT OR Apache-2.0

A utility to generate database structs and querying code from diesel schema files. Primarily built for create-rust-app.

Currently, it's more advantageous to generate code over deriving code with macros because intellisense and autocompletion isn't quite there when it comes to macro expansion.


Given the following schema:

// schema.rs
diesel::table! {
    todos (id) {
        id -> Int4,
        text -> Text,
        completed -> Bool,

We run:

cargo dsync -i schema.rs -o models

Now we have everything we need!

use models::todos;

async fn demo(db: Connection) {
  let created_todo = todos::create(&mut db, todos::CreateTodo {
    text: "Create a demo",
    completed: false,
  let todos_list = todos::paginate(&mut db, 1, 10).await?;
  let updated_todo = todos::update(&mut db, created_todo.id, UpdateTodo {
    text: created_todo.text,
    completed: true,

For a complete example, see test/simple_table/schema.rs which generates all the code in test/simple_schema/models.


  1. Add this crate:

    cargo add dsync
  2. Create a new binary in your project which uses the crate (for example, bin/dsync.rs)

    use std::{collections::HashMap, path::PathBuf};
    use dsync::{GenerationConfig, TableOptions};
    pub fn main() {
        let dir = env!("CARGO_MANIFEST_DIR");
            PathBuf::from_iter([dir, "src/schema.rs"]), 
            PathBuf::from_iter([dir, "src/models"]), 
            GenerationConfig { /* ... your generation options ... */ }
  3. Create a Cargo.toml binary entry:

    name = "dsync"
    path = "bin/dsync.rs"
  4. Execute!

cargo run --bin dsync

Protip: to use cargo dsync, create an alias in .cargo/config:

dsync="run --bin dsync"

Pre-built binary

Setting up a custom binary allows you to completely customize the generation; however, if complete customization isn't necessary, you can install the CLI directly (you'll have to make sure you keep it up-to-date by running this periodically):

cargo install dsync 

CLI Usage

  • -i: input argument: path to schema file
  • -o: output argument: path to directory where generated code should be written
  • -c: connection type (for example: diesel::r2d2::PooledConnection<diesel::r2d2::ConnectionManager<diesel::PgConnection>>)
  • -g: (optional) list of columns that are automatically generated by create/update triggers (for example, created_at, updated_at)
  • --tsync: (optional) adds #[tsync] attribute to generated structs (see https://github.com/Wulf/tsync)
  • --model-path: (optional) set a custom model import path, default crate::models::
  • --schema-path: (optional) set a custom schema import path, default crate::schema::
  • --no-serde: (optional) if set, does not output any serde related code
  • note: the CLI has fail-safes to prevent accidental file overwriting
dsync -i src/schema.rs -o src/models


See dsync --help for more information.

Feel free to open tickets for support or feature requests.


Use ./test/test_all.sh to run tests. After running the test, there should be no unexpected changes to files in ./test (use git status and git diff to see if there were any changes).


This tool is distributed under the terms of both the MIT license and the Apache License (Version 2.0).



~50K SLoC