Beam
Beam: Beam brings statically checked, composable SQL queries to Haskell applications. Ranked #13 of 51 in Database Query Builders by our editors (7.9/10); pricing: Free plan; best for haskell teams wanting typed multi-backend SQL.
At a glance
- Editor score7.9 / 10
- PricingFree plan
- Best forHaskell teams wanting typed multi-backend SQL
- Free planYes
- Paid fromNone
- Type safetyStatic
- Facts checked4 Oct 2026
Where it wins
- Checks query construction and scoping at compile time
- Supports aggregations, subqueries, and window functions on compatible backends
- Offers a raw SQL escape hatch and separate migration package
Where it doesn't
- Requires Haskell and self-hosted application development
- Backend availability and SQL feature compatibility vary
- Database connectivity comes from backend libraries
Our verdict on Beam
Beam is an open-source Haskell library for building and running relational database queries, aimed at teams that want query construction checked through Haskell's type system. Its composable, typed query expressions and projections generate SQL for supported databases. It is a library rather than a hosted subscription product, so it suits developers integrating database access into Haskell applications, not teams seeking a managed query-building service.
The type system is central to Beam's approach: query scoping and types are checked at compile time, while the query API includes aggregations, subqueries, and window functions across compatible backends. For cases that do not fit the typed expressions, customExpr_ allows raw SQL expressions to be embedded. That escape hatch adds flexibility, though it also means developers can step outside the checked query interface. A separate beam-migrate package provides schema migration support.
Beam documents PostgreSQL, SQLite, and DuckDB backends; MySQL or MariaDB support is maintained separately, and Firebird is also listed among its integrations. Backend availability and SQL feature compatibility vary, so teams should check the backend library that matches their database and required queries. Beam is free and open source, with packages distributed through Hackage and Stackage; database connectivity is provided by backend libraries, and support is community-based. Choose Beam if your team works in Haskell and values statically checked queries across suitable backends. If you need a hosted service or uniform feature coverage across databases, this library may not be the right fit.
Your product? Our editors can test Beam in depth and publish a review, labelled as paid · from $99/mo →
Beam pricing
Beam fact sheet
| Free plan | Yes |
|---|---|
| Paid from | None |
| Languages | Haskell |
| SQL dialects | ANSI SQL; backend-specific SQL for PostgreSQL, SQLite, DuckDB, MySQL/MariaDB, and Firebird |
| Type safety | Static |
| Async queries | Not verified |
| Raw SQL support | Yes |
| Compile without execution | Yes |
| Deployment | Self-hosted |
| Platforms | Linux, macOS, Windows |
| Support | Community |
| Built for | Solo, Small business, Mid-market, Enterprise (editorial estimate) |
| Integrations | 6 integrations: PostgreSQL, SQLite, DuckDB, MySQL, MariaDB, Firebird |
| Pricing | Free plan |
| Website | haskell-beam.github.io |
| Facts checked | 4 Oct 2026 |
Beam integrations
Beam lists 6 integrations on its own site.
- PostgreSQL
- SQLite
- DuckDB
- MySQL
- MariaDB
- Firebird
Alternatives to Beam
- 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
Used Beam? 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 Beam 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
Beam 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/beam-database-query-builder/"><img src="https://www.itechguides.com/best/badge/beam-database-query-builder.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