DDemoDB

Sample data, ready to use

Good data makes
better examples.

A dependable home for the sample databases developers use to learn, test, and build. Browse the schema, preview records, and download a fixture in the format you need.

Explore databases Open data contracts ↗
demodb.dev

-- curated sample databases

SELECT schema, records

FROM trusted_fixtures WHERE useful = true;

Chinook · Northwind · Pubs · Sakila · AdventureWorks OLTP · Employees (browser edition)

-- 6 databases · 128 tables · 38 views

The collection

Familiar data.
Clear provenance.

Each database has its own source repository and reproducible contract. DemoDB combines those contracts into one catalogue while keeping the schema, licensing, and downloadable files close to their owners.

Start with a music shop or a small business, then follow the relationships through real tables and sample queries.

Browse sample databases

Choose a dataset to explore.

6 registered databases
Music retail

Chinook

A digital music store database for learning SQL, joins, and data tooling.

11 tables0 views0.96 MB JSON · MYSQL · POSTGRESQL · SQLITE · SQLSERVER · YAML Explore database Small business

Northwind

Microsoft's classic small-business sample database, converted to SQLite with its tables, views, identifiers, binary fields, and relationships preserved.

13 tables17 views0.57 MB SQLITE · SQL Explore database Publishing

Pubs

Microsoft's classic publishing sample database, with authors, books, publishers, stores, sales, and publisher-logo images.

11 tables1 views0.20 MB SQLITE · SQL Explore database Video rental

Sakila

MySQL's sample video rental database, with films, actors, customers, rentals, payments, and stores.

16 tables7 views4.69 MB SQLITE · SQL Explore database Sales, purchasing, manufacturing, and inventory

AdventureWorks OLTP

Microsoft AdventureWorks OLTP sample database with people, products, sales, purchasing, manufacturing, and inventory.

71 tables11 views119.47 MB SQLITE · SQL Explore database Human Resources

Employees (browser edition)

A reproducible, FK-closed browser-sized edition of the MySQL Employees sample, retaining 1,024 selected employees and their associated employment history.

6 tables2 views0.84 MB SQLITE · SQL Explore database

For builders

Stable files. Reusable contracts.

Download SQLite, SQL, CSV, and JSON exports where available. Machine-readable schema contracts keep column types, keys, relationships, and row counts aligned with each fixture.

Read how the catalogue is built →