# 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" %}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://mariadb.com/docs/server/clients-and-utilities/graphical-and-enhanced-clients/dbforge-data-generator.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.