palemoky/test-db repository overview

⁠test-db — Employees Sample Database

Pre-built Docker images with the classic employees sample database already loaded. No setup needed — pull, run, and start querying in seconds.

⁠Available Tags

⁠Quick Start

# MySQL 8.4
docker run -d -p 3306:3306 -e MYSQL_ROOT_PASSWORD=test palemoky/test-db:mysql-8.4
mysql -h 127.0.0.1 -P 3306 -uroot -ptest employees

# PostgreSQL 17
docker run -d -p 5432:5432 -e POSTGRES_PASSWORD=test palemoky/test-db:postgresql-17
psql -h 127.0.0.1 -p 5432 -U postgres -d employees

⁠Default Credentials

⁠About the Data

The employees database contains ~300,000 employee records and ~2.8 million salary entries (167 MB uncompressed). It is widely used for:

• Learning SQL and query optimization
• Testing ORM frameworks and database drivers
• Benchmarking database performance
• Practicing backup and replication setups

Original data by Fusheng Wang & Carlo Zaniolo (Siemens Corporate Research).
Schema by Giuseppe Maxia · licensed under CC BY-SA 3.0⁠.

⁠Source

github.com/palemoky/test_db⁠