# Prax ORM
<p align="center">
<strong>A next-generation, type-safe ORM for Rust</strong>
</p>
<p align="center">
<a href="https://crates.io/crates/prax-orm"><img src="https://img.shields.io/crates/v/prax-orm.svg" alt="crates.io"></a>
<a href="https://docs.rs/prax-orm"><img src="https://docs.rs/prax-orm/badge.svg" alt="docs.rs"></a>
<a href="https://github.com/pegasusheavy/prax-orm/actions"><img src="https://github.com/pegasusheavy/prax-orm/workflows/CI/badge.svg" alt="CI"></a>
<img src="https://img.shields.io/badge/rust-1.85%2B-blue.svg" alt="Rust 1.85+">
<a href="#license"><img src="https://img.shields.io/badge/license-MIT%2FApache--2.0-blue.svg" alt="License"></a>
</p>
<p align="center">
<a href="#features">Features</a> •
<a href="#installation">Installation</a> •
<a href="#quick-start">Quick Start</a> •
<a href="#documentation">Documentation</a> •
<a href="#license">License</a>
</p>
---
**Prax ORM** is a modern, Prisma-inspired ORM for Rust with first-class async support. Built on top of `tokio-postgres`, `sqlx`, and other async database clients, Prax provides a type-safe, ergonomic API for database operations with compile-time guarantees.
> ⚠️ **Work in Progress** - Prax is currently under active development. See [TODO.md](./TODO.md) for the implementation roadmap.
## Features
- 🔒 **Type-Safe Queries** - Compile-time checked queries with zero runtime overhead
- ⚡ **Async-First** - Built on Tokio for high-performance async I/O
- 🎯 **Fluent API** - Intuitive query builder with method chaining
- 🔗 **Relations** - Eager and lazy loading with `include` and `select`
- 📦 **Migrations** - Schema diffing, SQL generation, and migration tracking
- 🛠️ **Code Generation** - Proc-macros for compile-time model generation
- 🗄️ **Multi-Database** - PostgreSQL, MySQL, and SQLite support
- 🔌 **Framework Integration** - First-class support for [Armature](https://github.com/pegasusheavy/armature), Axum, and Actix-web
## Installation
Add Prax ORM to your `Cargo.toml`:
```toml
[dependencies]
prax-orm = "0.3"
tokio = { version = "1", features = ["full"] }
```
For specific database backends:
```toml
# PostgreSQL (default)
prax-orm = { version = "0.3", features = ["postgres"] }
# MySQL
prax-orm = { version = "0.3", features = ["mysql"] }
# SQLite
prax-orm = { version = "0.3", features = ["sqlite"] }
# DuckDB (analytics)
prax-orm = { version = "0.3", features = ["duckdb"] }
# ScyllaDB (high-performance Cassandra-compatible)
prax-scylladb = "0.3"
# Armature framework integration
prax-armature = "0.3"
```
## Quick Start
### Define Your Models
```rust
use prax::prelude::*;
#[derive(Model)]
#[prax(table = "users")]
pub struct User {
#[prax(id, auto_increment)]
pub id: i32,
#[prax(unique)]
pub email: String,
pub name: Option<String>,
#[prax(default = "now()")]
pub created_at: DateTime<Utc>,
#[prax(relation(has_many))]
pub posts: Vec<Post>,
}
#[derive(Model)]
#[prax(table = "posts")]
pub struct Post {
#[prax(id, auto_increment)]
pub id: i32,
pub title: String,
pub content: String,
#[prax(relation(belongs_to))]
pub author: User,
pub author_id: i32,
}
```
### Connect and Query
```rust
use prax::prelude::*;
#[tokio::main]
async fn main() -> Result<(), prax::Error> {
// Connect to database
let client = PraxClient::new("postgresql://localhost/mydb").await?;
// Find many with filtering and relations
let users = client
.user()
.find_many()
.where(user::email::contains("@example.com"))
.include(user::posts::fetch())
.order_by(user::created_at::desc())
.take(10)
.exec()
.await?;
// Create a new user
let user = client
.user()
.create(user::Create {
email: "hello@example.com".into(),
name: Some("Alice".into()),
..Default::default()
})
.exec()
.await?;
// Update with filtering
let updated = client
.user()
.update_many()
.where(user::created_at::lt(Utc::now() - Duration::days(30)))
.data(user::Update {
name: Some("Inactive User".into()),
..Default::default()
})
.exec()
.await?;
// Transactions
client
.transaction(|tx| async move {
let user = tx.user().create(/* ... */).exec().await?;
tx.post().create(/* ... */).exec().await?;
Ok(())
})
.await?;
Ok(())
}
```
### Armature Framework Integration
Prax integrates seamlessly with [Armature](https://github.com/pegasusheavy/armature), providing dependency injection support:
```rust
use armature::prelude::*;
use prax_armature::PraxModule;
#[module_impl]
impl DatabaseModule {
#[provider(singleton)]
async fn prax_client() -> Arc<PraxClient> {
Arc::new(
PraxClient::new("postgresql://localhost/mydb")
.await
.expect("Database connection failed")
)
}
}
#[controller("/users")]
impl UserController {
#[get("/")]
async fn list(
&self,
#[inject] db: Arc<PraxClient>,
) -> Result<Json<Vec<User>>, HttpError> {
let users = db.user().find_many().exec().await?;
Ok(Json(users))
}
}
```
## Query Operations
### Filtering
```rust
// Equals
user::email::equals("alice@example.com")
// Contains, starts with, ends with
user::name::contains("alice")
user::email::starts_with("admin")
user::email::ends_with("@company.com")
// Comparisons
user::age::gt(18)
user::age::gte(21)
user::age::lt(65)
user::created_at::lte(Utc::now())
// Logical operators
and![
user::age::gte(18),
user::status::equals("active")
]
or![
user::role::equals("admin"),
user::role::equals("moderator")
]
not!(user::banned::equals(true))
// Nested relation filters
user::posts::some(post::published::equals(true))
```
### Pagination
```rust
// Offset-based
client.user().find_many().skip(20).take(10).exec().await?;
// Cursor-based
client.user().find_many().cursor(user::id::equals(100)).take(10).exec().await?;
```
### Aggregations
```rust
let count = client.user().count().exec().await?;
let stats = client
.post()
.aggregate()
.count()
.avg(post::views)
.sum(post::likes)
.exec()
.await?;
let grouped = client
.user()
.group_by(user::country)
.count()
.exec()
.await?;
```
## Architecture
Prax ORM is organized as a workspace of focused crates:
```
prax-orm/
├── prax-schema/ # Schema parser and AST
├── prax-codegen/ # Proc-macro crate for code generation
├── prax-query/ # Query builder implementation
├── prax-postgres/ # PostgreSQL (tokio-postgres) engine
├── prax-mysql/ # MySQL (mysql_async) engine
├── prax-sqlite/ # SQLite (rusqlite) engine
├── prax-duckdb/ # DuckDB analytical engine
├── prax-scylladb/ # ScyllaDB (Cassandra-compatible) engine
├── prax-migrate/ # Migration engine
├── prax-cli/ # CLI tool (prax-orm-cli)
├── prax-armature/ # Armature framework integration
├── prax-axum/ # Axum framework integration
├── prax-actix/ # Actix-web framework integration
└── src/ # Main crate (prax-orm) re-exporting everything
```
## CLI
Prax ORM includes a CLI for schema management and migrations:
```bash
# Install the CLI
cargo install prax-orm-cli
# Initialize a new Prax project
prax init
# Generate client from schema
prax generate
# Create a migration
prax migrate dev --name add_users_table
# Apply migrations
prax migrate deploy
# Reset database
prax migrate reset
# Introspect existing database
prax db pull
```
## Comparison
| Async Support | ✅ | ❌ | ✅ | ✅ |
| Type-Safe Queries | ✅ | ✅ | ✅ | ✅ |
| Schema DSL | ✅ | ❌ | ❌ | ❌ |
| Migrations | ✅ | ✅ | ✅ | ✅ |
| Relations | ✅ | ✅ | ✅ | ❌ |
| Code Generation | ✅ | ❌ | ✅ | ❌ |
| Fluent API | ✅ | ❌ | ✅ | ❌ |
| Multi-Tenancy | ✅ | ❌ | ❌ | ❌ |
| Built-in Caching | ✅ | ❌ | ❌ | ❌ |
| DuckDB Support | ✅ | ❌ | ❌ | ❌ |
| ScyllaDB Support | ✅ | ❌ | ❌ | ❌ |
## Contributing
Contributions are welcome! Please read the contributing guidelines before submitting a pull request.
## License
Licensed under either of:
- Apache License, Version 2.0 ([LICENSE-APACHE](LICENSE-APACHE) or http://www.apache.org/licenses/LICENSE-2.0)
- MIT license ([LICENSE-MIT](LICENSE-MIT) or http://opensource.org/licenses/MIT)
at your option.
Copyright (c) 2025 Pegasus Heavy Industries LLC
## Acknowledgments
Prax ORM is heavily inspired by:
- **[Prisma](https://www.prisma.io/)** - For pioneering the modern ORM developer experience
- **[Diesel](https://diesel.rs/)** - For proving type-safe database access in Rust is possible
- **[SeaORM](https://www.sea-ql.org/SeaORM/)** - For async ORM patterns in Rust
- **[Armature](https://github.com/pegasusheavy/armature)** - Our companion HTTP framework