Archibald review
A focused Rust library for guarded, asynchronous SQL across PostgreSQL and SQLite.
Reviewed by iTechGuides Editors · Editorial team · Updated Oct 2026
Archibald is an open-source Rust library for building and executing SQL through a fluent API. It is aimed at Rust developers who want programmatic query construction with static checks and asynchronous execution, particularly solo developers and small teams building applications. Its most distinctive guard is that UPDATE and DELETE queries require a WHERE clause at compile time, addressing a specific risk in constructing data-changing queries. Automatic parameter binding is also part of its documented feature set.
The query-building scope extends beyond basic selection and filtering. Archibald documents joins, aggregations, grouping, subqueries, transactions, savepoints, and isolation levels. Async execution uses Tokio and async/await, and SQL generation can be separated from deferred query validation. PostgreSQL and SQLite are the supported database integrations in its documentation; the available dialect range is therefore relatively focused. Developers working with either database and wanting Rust-native query construction may find that scope appropriate, while projects requiring other SQL dialects should consider a broader alternative.
Archibald is free and open source, with self-hosted use rather than a hosted service model. That fits teams comfortable incorporating a Rust library into their own application and deployment workflow. The compile-time WHERE requirement and binding support make it relevant where query safety matters, but the product is specifically a library rather than a general-purpose database interface. Choose it for Rust projects that need guarded, async SQL with PostgreSQL or SQLite; look elsewhere if the application uses another database or needs a broader platform ecosystem.
Archibald pros and cons
- Where it wins
- Requires WHERE clauses at compile time for UPDATE and DELETE
- Binds parameters automatically and supports async execution with Tokio
- Supports transactions, joins, aggregations, and subqueries
- Where it doesn't
- Database support is limited to PostgreSQL and SQLite
- Requires a Rust application and self-hosted deployment
- Query validation is deferred until SQL generation
Archibald fact sheet, pricing and score →
Advertiser disclosure: iTechGuides is reader-supported. Vendors can pay for top positions in our rankings and for a place on other products' pages, and we may earn a commission when you click some links. How we rank.
Last updated · How we research and update