CChinookDB

Open sample data for developers

The Chinook
sample database, live.

A stable, readable home for Chinook Database downloads, schema documentation, and table-level data previews.

Download the database Browse tables
chinook.sqlite

-- a small database with real shape

SELECT Name

FROM Artist LIMIT 5;

AC/DC · Accept · Aerosmith

Alanis Morissette · Alice In Chains

-- 11 tables · 15,607 rows, ready for your next query

Why Chinook

A dependable fixture for database work.

Chinook models a digital music store: artists, albums, tracks, customers, invoices, and the relationships between them. It is useful for learning SQL, testing database libraries, demonstrating joins, and building data tools.

These are the canonical upstream records, packaged in formats that are easy to inspect, download, and reuse.

The schema

Eleven tables. One useful shape.

View all tables
A Artist Artists represented in the music catalogue. 2 columns; 0 FKs; connected tables; 275 records A Album Albums released by an artist. 3 columns; 1 FK; connected tables; 347 records T Track Individual audio tracks available in the store. 9 columns; 3 FKs; connected tables; 3,503 records G Genre Music genres assigned to tracks. 2 columns; 0 FKs; connected tables; 25 records M MediaType File and encoding types used by tracks. 2 columns; 0 FKs; connected tables; 5 records P Playlist Named collections of tracks. 2 columns; 0 FKs; connected tables; 18 records P PlaylistTrack The many-to-many link between playlists and tracks. 2 columns; 2 FKs; connected tables; 8,715 records C Customer Customers who purchase music from the store. 13 columns; 1 FK; connected tables; 59 records E Employee Store employees and their reporting relationships. 15 columns; 1 FK; connected tables; 8 records I Invoice Orders raised for a customer. 9 columns; 1 FK; connected tables; 412 records I InvoiceLine Individual tracks and quantities on an invoice. 5 columns; 2 FKs; connected tables; 2,240 records

Built for your workflow

Download once.
Use it anywhere.

SQLite for a local database. JSON, YAML, and CSV for tooling. SQL scripts when you need to load another engine.

SQLiteComplete database ↓JSONComplete database ↓YAMLComplete database ↓SQL + CSVMore formats →