Swift Fork of the SQLite3 version of Microsoft's Northwind Database

What's New



A version of the database that uses Lighter 1.0.8.

The only visible change is the DocC fix for columns w/o a default value (they've been incorrectly reported as having a default value).


2022-08-04: A fork of Northwind-SQLite3 which packages Northwind as a Swift module.

This is a version of the Microsoft Access 2000 Northwind sample database, re-engineered for SQLite3.

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.

All the TABLES and VIEWS from the MSSQL-2000 version have been converted to Sqlite3 and included here. Included is a single version prepopulated with data. Should you decide to, you can use the included python script to pump the database full of more data.

Download here


alt tag

Build Instructions


  • You are running in a unix-like environment (Linux, MacOS)
  • Python 3.6 or higher (python3 --version)
  • SQLite3 installed sqlite3 -help


make build  # Creates database at ./dist/northwind.db

Populate with more data

make populate

Print report of row counts

make report


  • Swift Tools 5.7.0
View More Packages from this Author


Last updated: Tue Nov 22 2022 22:22:32 GMT-0500 (GMT-05:00)