# dbForge Data Generator [dbForge Data Generator for MariaDB and MySQL](https://www.devart.com/dbforge/mysql/data-generator/) is a powerful solution that helps create massive volumes of meaningful and realistic data. This tool performs various predefined data generators with customizable options. ## Data Generator Key Features: ### 1. Extensive support for all column data types Enjoy the advantage of various data types support ![column-data-types](https://2988006611-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSsmexDFPv2xG2OTyO5yV%2Fuploads%2Fgit-blob-61f24436dfe1add0ca33b2adfafd7a08b905e901%2Fcolumn-data-types.png?alt=media) ### 2. Multiple generators with unique test data Enjoy multiple customization options with individual generators for every data type supported ![custom-options](https://2988006611-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSsmexDFPv2xG2OTyO5yV%2Fuploads%2Fgit-blob-4ae975f49ad6fc7c2a55e972440279e6865fa2da%2Fcustom-options.png?alt=media) ### 3. MariaDB data generation and data integrity support Generate consistent random data through multiple tables Disable triggers and constraints to avoid interference with database logic ### 4. MariaDB data distribution modes Fine-tune the way you want your data to be generated ### 5. Multiple ways to generate data in MySQL Generate a data population script, execute it against a MariaDB database, save or edit it later ### 6. Basic generators Populate tables with a great variety of values types, like JSON, Python, XML, etc. ![basic-generators-1](https://2988006611-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSsmexDFPv2xG2OTyO5yV%2Fuploads%2Fgit-blob-51896b82a6dc6b63cdd93a2a3e001c47e3ccf212%2Fbasic-generators-1.png?alt=media) ### 7. Meaningful test data generators Select any of 200+ real-world generators and populate tables with realistic data related to various spheres ![meaningful-generators-1](https://2988006611-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSsmexDFPv2xG2OTyO5yV%2Fuploads%2Fgit-blob-e6390e52334295d97595df0753892297d5545b8a%2Fmeaningful-generators-1.png?alt=media) ### 8. User-defined generators Create, save and use your own data generators tailored for your needs ### 9. Real-time data generation preview Enjoy real-time visualization of the alterations you make Visually assess the data to be generated ### 10. Command-line interface Schedule your routine data generation tasks Create a command line execution file for running database documentation tasks ### 11. Broad compatibility options MariaDB server versions 5.5-11.4 Various cloud services: Amazon RDS, Amazon Aurora, Google Cloud, Oracle MySQL Cloud, Alibaba Cloud Security connections: Secure Socket Layer (SSL), Secure Shell (SSH), HTTP Tunneling, PAM Percona Download a free 30-day trial of dbForge Data Generator [here](https://www.devart.com/dbforge/mysql/data-generator/download.html). [Documentation](https://docs.devart.com/data-generator-for-mysql/) | Version | Introduced | | --------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | dbForge Data Generator 10.1 | Support for the rds-ca-rsa2048-g1 SSL/TLS certificate for connecting to MariaDB servers on AWS and enhanced cloud compatibility features, new automation capabilities | | dbForge Data Generator 10.0 | Support for [MariaDB 11.4](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/11.4/what-is-mariadb-114), Added support for temporal tables in MariaDB | | dbForge Data Generator 2.6 | Support for [MariaDB 11.3](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/11.3/what-is-mariadb-113) | | dbForge Data Generator 2.5 | Support for [MariaDB 10.9](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.9/what-is-mariadb-109), Support for [MariaDB 10.10](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.10/what-is-mariadb-1010) | | dbForge Data Generator 2.4 | Connectivity support for [MariaDB 10.5](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.5/what-is-mariadb-105) is added | | dbForge Data Generator 2.2 | Support for [MariaDB 10.4](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.4/what-is-mariadb-104) | | dbForge Data Generator 2.1 | Support for [MariaDB 10.3](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.3/what-is-mariadb-103) | | dbForge Data Generator 2.0 | Support for [MariaDB 10.2](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.2/what-is-mariadb-102), Support for [MariaDB 10.1](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.1/changes-improvements-in-mariadb-10-1) | *This page is licensed: CC BY-SA / Gnu FDL* {% @marketo/form formId="4316" %}