ScalaSql
ScalaSql: A typed Scala query library with CRUD, joins, transactions, and ZIO integration. Ranked #24 of 51 in Database Query Builders by our editors (6.6/10); pricing: Free plan; best for scala teams using ZIO with typed queries.
At a glance
- Editor score6.6 / 10
- PricingFree plan
- Best forScala teams using ZIO with typed queries
- Free planYes
- Paid fromNone
- Type safetyStatic
- Facts checked4 Oct 2026
Where it wins
- Build queries with typed table descriptions and Scala collection-style operations
- Supports PostgreSQL, MySQL, SQLite, SQL Server, and H2
- Includes transactions, savepoints, async transactions, and ZIO integration
Where it doesn't
- Relatively new project; users may encounter bugs or missing features
- Requires Scala 3.6.2 or later
- Self-hosted use and community support may not suit every team
Our verdict on ScalaSql
ScalaSql gives Scala developers a library for querying SQL databases through typed table descriptions and familiar collection-style operations. It covers selecting, inserting, updating, and deleting records, along with joins and transaction handling. Its static type safety and ZIO integration make it a fit for Scala teams that want database access within a typed Scala API, especially teams already using ZIO. The project specifies Scala 3.6.2 or later, so it is not aimed at applications on older Scala versions.
Database support spans PostgreSQL, MySQL, SQLite, Microsoft SQL Server, and H2. The library also offers transactions, savepoints, an asynchronous transaction API, and a raw SQL escape hatch. That mix provides useful coverage for common query work while retaining an option for SQL that does not fit the library's higher-level query interface. ScalaSql is open source and self-hosted, so it can suit teams that prefer to manage the library as part of their own application stack rather than depend on a hosted query service.
The tradeoff is project maturity: ScalaSql describes itself as relatively new and cautions that users may encounter bugs or missing features. Its listed support channel is community support, which may not meet teams seeking vendor-backed assistance. Choose it if typed Scala queries, ZIO effects, and support for the listed databases match your stack and you can accommodate an evolving project. Teams that need a mature feature set or a different support model should compare alternatives before adopting it.
Your product? Our editors can test ScalaSql in depth and publish a review, labelled as paid · from $99/mo →
ScalaSql pricing
ScalaSql fact sheet
| Free plan | Yes |
|---|---|
| Paid from | None |
| Languages | Scala |
| SQL dialects | PostgreSQL, MySQL, SQLite, Microsoft SQL Server, H2 |
| Type safety | Static |
| Async queries | Yes |
| Raw SQL support | Yes |
| Compile without execution | Yes |
| Deployment | Self-hosted |
| Support | Community |
| Built for | Solo, Small business, Mid-market, Enterprise (editorial estimate) |
| Pricing | Free plan |
| Website | github.com |
| Facts checked | 4 Oct 2026 |
Alternatives to ScalaSql
- 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 ScalaSql alternatives →
Used ScalaSql? 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 ScalaSql 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
ScalaSql 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/scalasql/"><img src="https://www.itechguides.com/best/badge/scalasql.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