# slick/slick

Slick (Scala Language Integrated Connection Kit) is a modern database query and access library for Scala

Repository: https://github.com/slick/slick
Canonical: https://ross.abutalabs.com/products/slick-slick
Homepage: https://scala-slick.org/
Language: Scala
License: BSD-2-Clause
License Family: permissive
Topics: database, scala, sql
Last push: 2026-08-24T01:48:20+00:00

## Health v2 (maintenance only)
Score: 70/100 (v2, computed 2026-09-03T02:20:16.233290+00:00)
- activity 99, release rhythm 16, longevity 100
- inputs: {"age_days": 6403, "days_push": 10, "days_rel": 474, "gap_med": 112.5, "n_releases_24m": 3}
- flags: none
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 2664, forks 614 (observed 2026-08-28T04:07:08.981319+00:00)

## What it is
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
- artifact type: library
- maturity: active
- function: database, orm, database-driver, streaming
- domain: databases, backend, web-development
- platform: jvm, cross-platform
- tags: scala, sql, functional-relational-mapping, cats-effect, fs2, type-safe-queries, query-compiler, codegen

## Member repositories
- slick/slick (main) score 70

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:07:08.981319+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-30T02:18:19.605166+00:00, confidence not recorded.
  - readme: https://github.com/slick/slick (fetched 2026-08-28T04:07:08.981319+00:00, sha 4792c47b514b)
  - homepage: https://scala-slick.org/ (fetched 2026-08-29T10:01:02.176108+00:00, sha f6b83ca5906f)
  - site_page: https://scala-slick.org/docs (fetched 2026-08-29T10:01:02.185076+00:00, sha afcca32466fe)
- Data as of 2026-08-30T08:39:29.467469+00:00.