# lerocha/chinook-database

Sample database for SQL Server, Oracle, MySQL, PostgreSQL, SQLite, DB2

Repository: https://github.com/lerocha/chinook-database
Canonical: https://ross.abutalabs.com/products/chinook-database
Language: TSQL
License: NOASSERTION
License Family: other
Last push: 2025-10-05T23:25:42+00:00

## Health v2 (maintenance only)
Score: 43/100 (v2, computed 2026-09-03T02:20:16.233290+00:00)
- activity 45, release rhythm 8, longevity 100
- inputs: {"age_days": 4322, "days_push": 332, "days_rel": null, "gap_med": null, "n_releases_24m": 0}
- flags: no_license
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 2589, forks 742 (observed 2026-08-28T04:07:02.856384+00:00)

## What it is
Chinook is a sample database representing a digital media store, available as SQL scripts for SQL Server, Oracle, MySQL, PostgreSQL, SQLite, and DB2. It serves as a modern alternative to the Northwind database for demos, testing, and ORM tool evaluation.

## Use cases
- sample database for testing ORM tools
- demo data for SQL tutorials
- test database across multiple database engines
- learning SQL with realistic data
- database benchmarking fixture
- alternative to Northwind sample database

## When to choose
- you need consistent sample data across multiple database vendors
- you're testing or demoing ORM tools
- you want realistic demo data for tutorials or presentations

## When to avoid
- you need production-scale or big data volumes
- you need domain-specific data outside a digital media store schema

## Facets
- artifact type: dataset
- maturity: active
- function: database, data-generation
- domain: databases, developer-tools, testing
- platform: cross-platform
- tags: sample-database, sql-scripts, orm-testing, demo-data, digital-media-store, sql-server, mysql, postgresql, sqlite, oracle, db2

## Member repositories
- lerocha/chinook-database (main) score 43

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:07:02.856384+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:22:22.086718+00:00, confidence not recorded.
  - readme: https://github.com/lerocha/chinook-database (fetched 2026-08-28T04:07:02.856384+00:00, sha 48e548a8a289)
- Data as of 2026-08-30T08:39:29.467469+00:00.