Lyrebird · Realistic synthetic test databases, generated fully offline
SUBSETRAPLATFORM

MySQL 8.4.11

Chinook

Digital music store. Pick a table to see the source and the synthetic copy together.

Tables
11
Rows, source
15,607
Rows, synthetic
15,607
Broken foreign keys
0
11 foreign keys checked on the data

The profile

Lyrebird read the source once and wrote this profile. The synthetic database was generated from the profile alone, with no connection to the source.

Profile file
104 KB
Relationships measured
11
Rules tested / kept
653 / 9
Personal columns found
19
Tables with reference data
5

Generate it yourself

This is the same sealed profile that produced the copy on these pages. It holds no connection details, and you need no database to use it.

Download lyrebird-sample-chinook.lyre
  1. Install Lyrebird Community, open it and go to Generate.
  2. Choose the downloaded file as the profile, then choose an output folder.
  3. Generate the SQL files, and load them into an empty MySQL database or let Lyrebird load them into Docker.

Community generates up to 5,000 rows per table and keeps complete reference data as it is. 1 table of this sample has more rows, so your copy will be smaller there than the one shown here.

Lyrebird Community 0.4.0

This release on GitHub

104 KB · SHA-256 662c35727aae3daf25900b320a783078f2f9150af4d778947fd78c8026ad2c1c

Tables

Table Columns Source rows Synthetic rows Equal to a source row
Album 3 347 347 100%
Artist 2 275 275 0%
Customer 13 59 59 0%
Employee 15 8 8 0%
Genre 2 25 25 100%
Invoice 9 412 412 0%
InvoiceLine 5 2,240 2,240 100%
MediaType 2 5 5 100%
Playlist 2 18 18 100%
PlaylistTrack 2 8,715 8,715 Keys only
Track 9 3,503 3,503 0%

About this data

Chinook Database, copyright (c) 2008-2024 Luis Rocha. Source: Chinook, MIT license. Subsetra is not affiliated with its authors.

Generated with Lyrebird 0.4.0 (af70e35), model v2.3, seed 20261101, at the size of the source. Profile hash: 41616230b9b80629.