slick/slick

Health v2 · maintenance only

Adoption not part of the score

2664 stars · 614 forks observed · 2026-08-28

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

Slick is a strongly-typed database query and access library for Scala that lets you work with relational databases as if they were Scala collections. It compiles composable Scala queries to SQL for multiple database engines, with async APIs built on Cats Effect 3 and streaming via FS2.

Use cases

• query relational databases from Scala with compile-time safety
• generate SQL for multiple database engines from one codebase
• stream database rows reactively with FS2
• generate schema mappings from an existing database
• compose database actions in for comprehensions
• drop down to raw SQL for advanced queries

When to choose

• you're building a Scala application that needs type-safe database access
• you want collection-like query composition with control over SQL generation
• you use Cats Effect or ZIO and want effectful, streaming DB access
• you need to support several database backends from the same query code

When to avoid

• your project is in Java or another JVM language without Scala
• you prefer lightweight raw SQL or a simple JDBC wrapper
• you need a full-featured ORM with lazy loading and change tracking
• your team is unwilling to learn Slick's lifted embedding model

Facets

library · maturity active

database orm database-driver streaming databases backend web-development jvm cross-platform scala sql functional-relational-mapping cats-effect fs2 type-safe-queries query-compiler codegen

Member repositories

For agents

markdown · JSON · MCP: product_card(name="slick/slick")