Download sqlite Sample Databases

Download sample sqlite data sets below:

File Type: CSV | JSON | sqlite | duckdb | Parquet

Sqlite Data File Examples:

File	Description
sakila.db	The Sakila sample database was initially developed by Mike Hillyer, a former member of the MySQL AB documentation team. It is intended to provide a standard schema that can be used for examples in books, tutorials, articles, samples, and so forth.
chinook.db	Chinook is a sample database available for SQL Server, Oracle, MySQL, etc. It can be created by running a single SQL script. Chinook database is an alternative to the Northwind database, being ideal for demos and testing ORM tools targeting single and multiple database servers.
northwind_small.sqlite	The Northwind sample database was provided with Microsoft Access as a tutorial schema for managing small business customers, orders, inventory, purchasing, suppliers, shipping, and employees. Northwind is an excellent tutorial schema for a small-business ERP, with customers, orders, inventory, purchasing, suppliers, shipping, employees, and single-entry accounting. Original Source: https://github.com/jpwhite3/northwind-SQLite3

These data sets are used for testing QStudio
QStudio is a free SQL Editor that allows easily querying sqlite/parquet/h2/json/csv/tsv/duckdb files.

Using Sqlite Driver

QStudio includes support for sqlite.

SELECT "ArtistId", "Name" FROM artists LIMIT 5;

-- 2. Count the number of invoices per customer:
SELECT "CustomerId", COUNT("InvoiceId") AS "InvoiceCount" FROM invoices GROUP BY "CustomerId";

-- 3. Find the top 5 longest tracks:
SELECT "Name", "Milliseconds" FROM tracks ORDER BY "Milliseconds" DESC LIMIT 5;

-- 4. Get the total sales amount per billing country:
SELECT "BillingCountry", SUM("Total") AS "TotalSales" FROM invoices GROUP BY "BillingCountry";

Via DuckDB

QStudio bundles DuckDB which can also open sqlite files:

INSTALL sqlite;
LOAD sqlite;
ATTACH 'C:\Users\ray\dev\web\timestored.com\timestored.com\public_html\data\sample\chinook.db' AS chinook (TYPE SQLITE);
USE chinook;
SHOW tables;
SHOW databases;
SELECT * FROM albums LIMIT 10;

USE memory;
DETACH chinook;

Would query the file above via duckdb, alternatively within windows you can simply click to open a file.