zio/zio-quill

Health v2 · maintenance only

Adoption not part of the score

2166 stars · 352 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-30, confidence not recorded

ZIO Quill is a Scala database query library providing a Quoted Domain Specific Language (QDSL) that translates Scala code into SQL or Cassandra Query Language at compile time. It offers boilerplate-free case-class mapping, compile-time query generation and optional compile-time validation against the database, with near-driver-level runtime performance.

Use cases

• write type-safe SQL queries in Scala without string concatenation
• map database tables to case classes without boilerplate
• validate database queries at compile time
• query Cassandra with a Scala DSL
• build reactive ZIO applications with PostgreSQL access
• avoid ORM runtime overhead in Scala data access layers

When to choose

• you are writing Scala (2.x or Scala 3 via ProtoQuill) and want compile-time checked queries
• you use ZIO and want idiomatic async database access
• you want LINQ-style query generation with minimal runtime overhead
• you target SQL databases or Cassandra

When to avoid

• your project is not on the JVM/Scala ecosystem
• you need dynamic queries built entirely at runtime
• you need a traditional full-featured ORM with change tracking and lazy loading
• your team is not comfortable with macro-heavy compile-time tooling

Facets

library · maturity stable

orm database database-driver databases developer-tools backend jvm scala qdsl compile-time-query-generation jdbc cassandra sql zio linq-style

Member repositories

For agents

markdown · JSON · MCP: product_card(name="zio/zio-quill")