# Lyrebird sample databases

> Browse four public sample databases next to the synthetic copies Lyrebird generated from their profiles: PostgreSQL, MySQL, SQL Server and Oracle, table by table.

Canonical: https://subsetra.com/lyrebird/samples
Language: en

Each sample was loaded into its own engine, profiled once by Lyrebird, and generated from the profile alone into a second empty database. A script then read both databases and measured every column the same way. The pages are a snapshot of those results; no database runs behind the site. Each profile can be downloaded and opened in Lyrebird Community, which generates up to 5,000 rows per table. Community download: https://github.com/subsetra-com/lyrebird-releases/releases/tag/0.4.0

- Pagila on PostgreSQL: DVD rental store. 22 tables, 46,273 source rows, 46,273 synthetic rows, 0 broken foreign keys in 42 checked. PostgreSQL License license: https://github.com/devrimgunduz/pagila. Browse: https://subsetra.com/lyrebird/samples/pagila. Profile: https://subsetra.com/samples/profiles/lyrebird-sample-pagila.lyre
- Chinook on MySQL: Digital music store. 11 tables, 15,607 source rows, 15,607 synthetic rows, 0 broken foreign keys in 11 checked. MIT license: https://github.com/lerocha/chinook-database. Browse: https://subsetra.com/lyrebird/samples/chinook. Profile: https://subsetra.com/samples/profiles/lyrebird-sample-chinook.lyre
- AdventureWorksLT on SQL Server: Product sales, customers and orders. 12 tables, 4,277 source rows, 4,277 synthetic rows, 0 broken foreign keys in 12 checked. MIT license: https://github.com/microsoft/sql-server-samples/tree/master/samples/databases/adventure-works. Browse: https://subsetra.com/lyrebird/samples/adventureworks-lt. Profile: https://subsetra.com/samples/profiles/lyrebird-sample-adventureworks-lt.lyre
- Human Resources (HR) on Oracle: Employees, departments and locations. 7 tables, 216 source rows, 216 synthetic rows, 0 broken foreign keys in 10 checked. MIT license: https://github.com/oracle-samples/db-sample-schemas/tree/main/human_resources. Browse: https://subsetra.com/lyrebird/samples/human-resources. Profile: https://subsetra.com/samples/profiles/lyrebird-sample-human-resources.lyre