Skip to main content

Database load generator.

Project description


db-load-generator is a Python framework and toolbox for generating artificial database loads with as little code as necessary. It uses Java and JDBC drivers to connect to the databases.

PyPI PyPI - Python Version Build Status Documentation Build Status GitHub

Getting Started

New to db-load-generator? Checkout our official Getting Started guide.


  • Python 3.9 or above.
  • Java 8 or above.
  • JDBC driver for your database.


  • Test connection to the database using dbload test
  • Execute a query using dbload execute
  • Configure db-load-generator via
    • command line arguments
    • environment variables
    • default config file dbload.json
    • custom path config file
  • Print current parsed configuration using dbload show settings
  • Use decorators from dbload library to create scenarios and queries
  • Write annotated SQL queries in the .sql file and feed them using dbload --sql myfile.sql
  • Show current parsed queries using dbload show queries
  • Run any defined query using dbload query
  • Write full-fledged complex simulation scenarios using dbload library
  • Show current parsed scenarios using dbload show scenarios
  • Run any defined scenarios using dbload scenario
  • Use predefined simulations for popular databases using dbload --predefined <db-name> ACTION
  • Run db-load-generator as a background worker using dramatiq
    • ensure there is a RabbitMQ running as a message broker
    • runs scenarios as service workers dbload worker
    • enqueue executions into broker using dbload send <scenario name or actor name>
    • start beats/scheduler process using dbload scheduler

Development & Contributions

Contributions are welcome! If you are interested in contributing to the project please read our Code of Conduct.


Apache Version 2.0

Project details

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

db-load-generator-0.8.6.tar.gz (27.9 kB view hashes)

Uploaded Source

Built Distribution

db_load_generator-0.8.6-py3-none-any.whl (39.4 kB view hashes)

Uploaded Python 3

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page