Archibald
Archibald: A focused Rust library for guarded, asynchronous SQL across PostgreSQL and SQLite. Ranked #48 of 51 in Database Query Builders by our editors (4.1/10); pricing: Free plan; best for rust developers needing guarded async SQL building.
At a glance
- Editor score4.1 / 10
- PricingFree plan
- Best forRust developers needing guarded async SQL building
- Free planYes
- Paid fromNone
- Type safetyStatic
- Facts checked4 Oct 2026
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
Our verdict on Archibald
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.
Your product? Our editors can test Archibald in depth and publish a review, labelled as paid · from $99/mo →
Archibald pricing
Archibald fact sheet
| Free plan | Yes |
|---|---|
| Paid from | None |
| Languages | Rust |
| SQL dialects | PostgreSQL, SQLite |
| Type safety | Static |
| Async queries | Yes |
| Raw SQL support | Not verified |
| Compile without execution | Yes |
| Deployment | Self-hosted |
| Platforms | Linux, macOS, Windows |
| Built for | Solo, Small business (editorial estimate) |
| Integrations | 4 integrations: PostgreSQL, SQLite, SQLx, Tokio |
| Pricing | Free plan |
| Website | github.com |
| Facts checked | 4 Oct 2026 |
Archibald integrations
Archibald lists 4 integrations on its own site.
- PostgreSQL
- SQLite
- SQLx
- Tokio
Alternatives to Archibald
- jOOQA fluent SQL framework for JVM teams that want generated, type-safe database access.9.3
- SQLAlchemySQL construction, ORM, and database services for Python applications.9.1
- JetBrains ExposedA free, open-source Kotlin library with a type-safe SQL DSL and JDBC and R2DBC access.9.0
See all Archibald alternatives →
Used Archibald? Be the first to review it
The editor score above is our own research. What this page doesn't have yet is a reader's view — what you used Archibald for, what worked and what didn't. No stars are seeded and no review is paid for; an editor reads every one before it appears.
Write a reviewTwo minutes · verified accounts only · read by an editor before it appears
Featured on iTechGuides
Archibald is listed in our Database Query Builders directory. Add the badge to your site — it links back to this page.
<a href="https://www.itechguides.com/products/archibald/"><img src="https://www.itechguides.com/best/badge/archibald.svg" alt="Featured on iTechGuides" width="230" height="46"></a>
Reviewed by iTechGuides Editors · Editorial team · Updated Oct 2026
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