Random data plugin

A plugin to generate random data.

Installation

anyquery install random

Usage

Specify the columns you want to generate in the SELECT clause. The plugin will generate random data for each column and return the result. To see the list of available columns, refer to the Tables schema section.

Example

# Generate 100 random records and save them to a CSV file
anyquery -q "SELECT first_name, last_name, credit_card_number FROM random_people LIMIT 100" --csv > random.csv
# Generate 100 random records and save them to a JSON file
anyquery -q "SELECT username, email, phone_number, password FROM random_people LIMIT 100" --json > random.json
# Generate 320 passwords seperated by new lines
anyquery -q "SELECT password_lower_upper FROM random_passwords LIMIT 320" > passwords.txt

⚠️ Limitations

• The generator is not trully random so don't use for security purposes.

• Always set a LIMIT clause because the plugin will generate infinite records if you don't.

• Because the plugin returns infinite records, you can't do joins with other tables. As a workaround, save the result to a table with CREATE TABLE ... AS SELECT... and then join with that table.

Tables schema

random_people

random_password

random_internet