# datacharmer/test_db

A sample MySQL database with an integrated test suite, used to test your applications and database servers

Repository: https://github.com/datacharmer/test_db
Canonical: https://ross.abutalabs.com/products/test_db
Language: PLpgSQL
License Family: other
Last push: 2026-04-10T10:00:40+00:00

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

## Adoption (not part of the score)
Stars 4434, forks 2694 (observed 2026-08-28T04:08:49.245236+00:00)

## What it is
A sample MySQL employees database with an integrated test suite, migrated from Launchpad, also compatible with MariaDB, Percona Server, and PostgreSQL. It is used to test applications and database servers against realistic data.

## Use cases
- populate a MySQL database with sample data for testing queries
- benchmark database server performance with a realistic dataset
- test application SQL against a known dataset with integrity checks
- learn SQL with a sample employees schema
- verify MariaDB or PostgreSQL compatibility with a MySQL sample database

## When to choose
- you need a well-known sample dataset for MySQL, MariaDB, Percona, or PostgreSQL testing
- you want integrity test scripts to validate database behavior
- you are following MySQL documentation tutorials that use the employees database

## When to avoid
- you need production-like data volumes or sensitive realistic data
- you need a dataset for non-relational databases
- you require a maintained software library rather than static sample data

## Facets
- artifact type: dataset
- maturity: stable
- function: database, testing, benchmarking
- domain: databases, testing, developer-tools
- platform: cross-platform
- tags: sample-database, mysql, mariadb, postgresql, employees-database, test-data

## Member repositories
- datacharmer/test_db (main) score 57

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:08:49.245236+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-29T18:20:52.890636+00:00, confidence not recorded.
  - readme: https://github.com/datacharmer/test_db (fetched 2026-08-28T04:08:49.245236+00:00, sha 834341d206c1)
- Data as of 2026-08-30T08:39:29.467469+00:00.