# pthom/northwind_psql

Northwind sample database for postgres

Repository: https://github.com/pthom/northwind_psql
Canonical: https://ross.abutalabs.com/products/northwind_psql
License: NOASSERTION
License Family: other
Last push: 2024-08-31T08:38:22+00:00

## Health v2 (maintenance only)
Score: 32/100 (v2, computed 2026-09-02T17:46:02.011165+00:00)
- activity 0, release rhythm 35, longevity 100
- inputs: {"age_days": 4161, "days_push": 732, "days_rel": null, "gap_med": null, "n_releases_24m": 0}
- flags: no_releases, no_license
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 1034, forks 992 (observed 2026-08-28T04:03:18.676477+00:00)

## What it is
A SQL script and Docker Compose setup that populates a PostgreSQL database with the classic Northwind sample data. It provides an easy way to spin up a demo database locally, optionally with PgAdmin for browsing.

## Use cases
- populate a postgres database with the northwind sample data
- set up a demo database for learning SQL
- test SQL queries against a realistic sample schema
- spin up postgres with sample data using docker compose
- practice joins and aggregations on example tables
- set up a local database for tutorials and courses

## When to choose
- you need a well-known sample dataset for PostgreSQL
- you want a quick Docker-based demo database with PgAdmin
- you are teaching or learning SQL with realistic data

## When to avoid
- you need sample data for MySQL, SQL Server, or another engine without adaptation
- you need production-grade or large-scale benchmark data
- you want an actively maintained application rather than a static SQL script

## Facets
- artifact type: dataset
- maturity: stable
- function: database
- domain: databases, developer-tools, education
- platform: self-hosted, cross-platform
- tags: sample-database, northwind, postgres, sql-script, docker-compose, pgadmin, sql, docker

## Member repositories
- pthom/northwind_psql (main) score 32

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:03:18.676477+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-30T07:06:35.399621+00:00, confidence not recorded.
  - readme: https://github.com/pthom/northwind_psql (fetched 2026-08-28T04:03:18.676477+00:00, sha 3ce5e59e5ba9)
- Data as of 2026-08-30T08:39:29.467469+00:00.