> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/server/clients-and-utilities/graphical-and-enhanced-clients/dbforge-data-generator.md).

# 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](/files/TID2HNXPVqmCguNmt5OB)

### 2. Multiple generators with unique test data

Enjoy multiple customization options with individual generators for every data type supported

![custom-options](/files/KHWIUeUGz8btIkd0k1jI)

### 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](/files/odjAcQUqP23MWS1laUDu)

### 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](/files/JiLSmwtIMB0N10j0YZ4o)

### 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](/docs/release-notes/community-server/11.4/what-is-mariadb-114.md), Added support for temporal tables in MariaDB                                                                                            |
| dbForge Data Generator 2.6  | Support for [MariaDB 11.3](/docs/release-notes/community-server/old-releases/11.3/what-is-mariadb-113.md)                                                                                                                             |
| dbForge Data Generator 2.5  | Support for [MariaDB 10.9](/docs/release-notes/community-server/old-releases/10.9/what-is-mariadb-109.md), Support for [MariaDB 10.10](/docs/release-notes/community-server/old-releases/10.10/what-is-mariadb-1010.md)               |
| dbForge Data Generator 2.4  | Connectivity support for [MariaDB 10.5](/docs/release-notes/community-server/old-releases/10.5/what-is-mariadb-105.md) is added                                                                                                       |
| dbForge Data Generator 2.2  | Support for [MariaDB 10.4](/docs/release-notes/community-server/old-releases/10.4/what-is-mariadb-104.md)                                                                                                                             |
| dbForge Data Generator 2.1  | Support for [MariaDB 10.3](/docs/release-notes/community-server/old-releases/10.3/what-is-mariadb-103.md)                                                                                                                             |
| dbForge Data Generator 2.0  | Support for [MariaDB 10.2](/docs/release-notes/community-server/old-releases/10.2/what-is-mariadb-102.md), Support for [MariaDB 10.1](/docs/release-notes/community-server/old-releases/10.1/changes-improvements-in-mariadb-10-1.md) |

<sub>*This page is licensed: CC BY-SA / Gnu FDL*</sub>

{% @marketo/form formId="4316" %}