Skip to content

A ready-to-use local development environment with real, preconfigured databases.

License

Notifications You must be signed in to change notification settings

juliosguz/dev-db-kit

Folders and files

NameName
Last commit message
Last commit date

Latest commit

ย 

History

4 Commits
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 

Repository files navigation

dev-db-kit ๐Ÿงฐ

๐ŸŒ Available languages: Espaรฑol ๐Ÿ‡ช๐Ÿ‡ธ

A ready-to-use local development environment with real, preconfigured databases.
Ideal for developers who want to start projects, test integrations, or explore realistic database schemas without setup hassle.


๐Ÿš€ Whatโ€™s included (currently)

  • ๐Ÿฌ MySQL 8.0.42 with the classicmodels dataset
  • ๐Ÿ˜ PostgreSQL 10.23 and PostgreSQL 17.5 with adapted classicmodels
  • Ready-to-import .sql scripts
  • Persistent volumes to keep data between container restarts
  • Compatible with tools like TablePlus, DBeaver, pgAdmin, etc.

๐Ÿ”ง How to use

  1. Clone this repository:

    git clone https://github.com/your-user/dev-db-kit.git
    cd dev-db-kit
  2. Make sure you have Docker and Docker Compose installed.

  3. Start the containers:

    docker-compose up -d
  4. Connect using your favorite database client.


๐Ÿ“ฆ Default access

Database Port User Password Database
MySQL 8.0.42 3306 devuser devpass classicmodels
PostgreSQL 10.23 5432 devuser devpass classicmodels
PostgreSQL 17.5 5433 devuser devpass classicmodels

๐Ÿ› ๏ธ In progress

This project is under active development. Upcoming features:

  • โœ… Support for additional database engines (MongoDB, Redis, SQLite, etc.)
  • โœ… Additional datasets (currently only classicmodels is included)
  • โœ… Entity-Relationship diagrams and technical documentation of schemas

๐Ÿ“˜ SQL Exercises

This project includes the classicmodels dataset, ideal for practicing SQL.
You can explore educational exercises by Richard T. Watson:


โš–๏ธ Licenses & Credits

Your content

All Docker setup, scripts, and documentation in this repo are licensed under MIT.

classicmodels dataset

The classicmodels dataset was originally created for BIRT by Actuate/Eclipse Foundation and is licensed under the Eclipse Public License v1.0 (EPLโ€‘1.0).
It is included here solely for educational and demonstration purposes and is not covered by the MIT license.

Reference:


๐Ÿ“„ License

Your code is under MIT. The classicmodels dataset remains under EPLโ€‘1.0.

About

A ready-to-use local development environment with real, preconfigured databases.

Resources

License

Stars

Watchers

Forks