Downloads 18this week

GitHub stars 0

Extension repository on GitHub

Extension descriptor (YAML)

The FakeIt Extension enables generation of realistic fake/test data directly in SQL queries

Installing and Loading

INSTALL fakeit FROM community;
LOAD fakeit;

Example

-- Generate a simple fake name and email
D SELECT fakeit_name_full() as name, fakeit_contact_email() as email;
┌─────────────────┬──────────────────────────┐
│      name       │          email           │
│     varchar     │         varchar          │
├─────────────────┼──────────────────────────┤
│ Jane Doe        │ jane.doe@example.com     │
└─────────────────┴──────────────────────────┘

-- Generate fake address data
D SELECT fakeit_address_street() as street, fakeit_address_city() as city, fakeit_address_state() as state, fakeit_address_zip() as zip;
┌─────────────────────┬──────────────┬───────────────┬─────────┐
│       street        │     city     │     state     │   zip   │
│       varchar       │   varchar    │    varchar    │ varchar │
├─────────────────────┼──────────────┼───────────────┼─────────┤
│ 123 Main St         │ New York     │ New York      │ 10001   │
└─────────────────────┴──────────────┴───────────────┴─────────┘

-- Generate fake company and contact information
D SELECT fakeit_company_company() as company, fakeit_contact_phone_formatted() as phone, fakeit_internet_domain_name() as website;
┌──────────────────┬──────────────────┬─────────────────────┐
│     company      │      phone       │       website       │
│     varchar      │     varchar      │       varchar       │
├──────────────────┼──────────────────┼─────────────────────┤
│ Acme Corp        │ (555) 123-4567   │ example.com         │
└──────────────────┴──────────────────┴─────────────────────┘

-- Generate UUIDs
D SELECT fakeit_uuid_v4() as id;
┌──────────────────────────────────────┐
│                  id                  │
│               varchar                │
├──────────────────────────────────────┤
│ a1b2c3d4-e5f6-7890-abcd-ef1234567890 │
└──────────────────────────────────────┘

-- Generate fake payment information
D SELECT fakeit_payment_credit_card_type() as card_type, fakeit_payment_credit_card_number() as card_number, fakeit_payment_credit_card_cvv() as cvv;
┌───────────┬──────────────────┬─────────┐
│ card_type │   card_number    │   cvv   │
│  varchar  │     varchar      │ varchar │
├───────────┼──────────────────┼─────────┤
│ Visa      │ 4532123456789012 │ 123     │
└───────────┴──────────────────┴─────────┘

About fakeit

This community extension provides over 120 functions for generating realistic fake/test data directly in SQL queries. It's powered by the fakeit Rust library and is perfect for creating test datasets, populating development databases, and prototyping applications.

Features

• 120+ fake data generation functions across 25+ categories
• Pure Rust implementation with no C++ dependencies
• WebAssembly compatible for DuckDB-WASM environments
• Self-contained with no external dependencies
• Production-ready with CI/CD automation

Function Categories

The extension organizes functions into the following categories:

Address Functions

• fakeit_address_street() - Full street address
• fakeit_address_street_number() - Street number
• fakeit_address_street_name() - Street name
• fakeit_address_street_prefix() - Street prefix (e.g., "N", "S")
• fakeit_address_street_suffix() - Street suffix (e.g., "Ave", "St")
• fakeit_address_city() - City name
• fakeit_address_state() - State name
• fakeit_address_state_abr() - State abbreviation
• fakeit_address_zip() - ZIP/postal code
• fakeit_address_country() - Country name
• fakeit_address_country_abr() - Country abbreviation
• fakeit_address_latitude() - Random latitude
• fakeit_address_longitude() - Random longitude
• fakeit_address_latitude_in_range(min, max) - Latitude within range
• fakeit_address_longitude_in_range(min, max) - Longitude within range

Name Functions

• fakeit_name_first() - First name
• fakeit_name_last() - Last name
• fakeit_name_full() - Full name (first + last)
• fakeit_name_prefix() - Name prefix (e.g., "Mr.", "Mrs.")
• fakeit_name_suffix() - Name suffix (e.g., "Jr.", "Sr.")

Contact Functions

• fakeit_contact_email() - Email address
• fakeit_contact_phone() - Phone number (unformatted)
• fakeit_contact_phone_formatted() - Phone number (formatted)

Company Functions

• fakeit_company_company() - Company name
• fakeit_company_company_suffix() - Company suffix (e.g., "Inc", "LLC")
• fakeit_company_buzzword() - Business buzzword
• fakeit_company_bs() - Business BS phrase

Internet Functions

• fakeit_internet_ipv4_address() - IPv4 address
• fakeit_internet_ipv6_address() - IPv6 address
• fakeit_internet_domain_name() - Domain name
• fakeit_internet_domain_suffix() - Domain suffix (e.g., ".com", ".org")
• fakeit_internet_username() - Username
• fakeit_internet_mac_address() - MAC address
• fakeit_internet_http_method() - HTTP method (GET, POST, etc.)

UUID Functions

• fakeit_uuid_v1() - UUID version 1 (timestamp-based)
• fakeit_uuid_v4() - UUID version 4 (random)

Animal Functions

• fakeit_animal_pet_name() - Pet name
• fakeit_animal_animal() - Random animal
• fakeit_animal_farm() - Farm animal
• fakeit_animal_cat() - Cat breed
• fakeit_animal_dog() - Dog breed

Beer Functions

• fakeit_beer_name() - Beer name
• fakeit_beer_style() - Beer style
• fakeit_beer_hop() - Hop variety
• fakeit_beer_yeast() - Yeast type
• fakeit_beer_malt() - Malt type
• fakeit_beer_ibu() - IBU (International Bitterness Units)
• fakeit_beer_alcohol() - Alcohol percentage
• fakeit_beer_blg() - Degrees Blg (Balling)

Color Functions

• fakeit_color_full() - Full color name
• fakeit_color_hex() - Hex color code
• fakeit_color_safe() - Web-safe color
• fakeit_color_rgb() - RGB color array

Currency Functions

• fakeit_currency_short() - Currency code (e.g., "USD")
• fakeit_currency_long() - Currency name (e.g., "US Dollar")
• fakeit_currency_price() - Random price

DateTime Functions

• fakeit_datetime_month() - Month name
• fakeit_datetime_day() - Day number
• fakeit_datetime_week_day() - Weekday name
• fakeit_datetime_year() - Year
• fakeit_datetime_hour() - Hour
• fakeit_datetime_minute() - Minute
• fakeit_datetime_second() - Second
• fakeit_datetime_nanosecond() - Nanosecond
• fakeit_datetime_timezone() - Timezone name
• fakeit_datetime_timezone_full() - Full timezone name
• fakeit_datetime_timezone_abv() - Timezone abbreviation
• fakeit_datetime_timezone_offset() - Timezone offset
• fakeit_datetime_date() - Random date

File Functions

• fakeit_file_extension() - File extension
• fakeit_file_mime_type() - MIME type

Hacker Functions

• fakeit_hacker_phrase() - Hacker phrase
• fakeit_hacker_abbreviation() - Tech abbreviation
• fakeit_hacker_adjective() - Tech adjective
• fakeit_hacker_noun() - Tech noun
• fakeit_hacker_verb() - Tech verb
• fakeit_hacker_ingverb() - Tech verb (present participle)

Hipster Functions

• fakeit_hipster_word() - Hipster word
• fakeit_hipster_sentence() - Hipster sentence
• fakeit_hipster_paragraph() - Hipster paragraph

Image Functions

• fakeit_image_url() - Random image URL

Job Functions

• fakeit_job_title() - Job title
• fakeit_job_descriptor() - Job descriptor
• fakeit_job_level() - Job level

Language Functions

• fakeit_language_random() - Random language
• fakeit_language_abbreviation() - Language abbreviation
• fakeit_language_programming() - Programming language

Log Level Functions

• fakeit_log_level_general() - General log level
• fakeit_log_level_syslog() - Syslog level
• fakeit_log_level_apache() - Apache log level

Password Functions

• fakeit_password_generate() - Random password

Payment Functions

• fakeit_payment_credit_card_type() - Credit card type
• fakeit_payment_credit_card_number() - Credit card number
• fakeit_payment_credit_card_exp() - Expiration date
• fakeit_payment_credit_card_cvv() - CVV code
• fakeit_payment_credit_card_luhn_number() - Luhn-valid number

Person Functions

• fakeit_person_ssn() - Social Security Number
• fakeit_person_gender() - Gender

Status Code Functions

• fakeit_status_code_simple() - Simple HTTP status code
• fakeit_status_code_general() - General HTTP status code

User Agent Functions

• fakeit_user_agent_chrome() - Chrome user agent
• fakeit_user_agent_firefox() - Firefox user agent
• fakeit_user_agent_safari() - Safari user agent
• fakeit_user_agent_opera() - Opera user agent
• fakeit_user_agent_random_platform() - Random platform
• fakeit_user_agent_linux_platform_token() - Linux platform token
• fakeit_user_agent_mac_platform_token() - Mac platform token
• fakeit_user_agent_windows_platform_token() - Windows platform token

Vehicle Functions

• fakeit_vehicle_vehicle_type() - Vehicle type
• fakeit_vehicle_car_maker() - Car manufacturer
• fakeit_vehicle_car_model() - Car model
• fakeit_vehicle_fuel() - Fuel type
• fakeit_vehicle_transmission_gear() - Transmission type

Words Functions

• fakeit_words_word() - Random word
• fakeit_words_sentence() - Random sentence
• fakeit_words_paragraph() - Random paragraph
• fakeit_words_question() - Random question
• fakeit_words_quote() - Random quote

Boolean Functions

• fakeit_bool() - Random boolean

Generator Functions

• fakeit_generator_generate() - Custom pattern generator

Usage Examples

Generate Test Users

SELECT
    row_number() OVER () as id,
    fakeit_name_full() as name,
    fakeit_contact_email() as email,
    fakeit_contact_phone_formatted() as phone,
    fakeit_address_city() as city,
    fakeit_address_state() as state
FROM generate_series(1, 100);

Generate E-commerce Orders

SELECT
    fakeit_uuid_v4() as order_id,
    fakeit_name_full() as customer_name,
    fakeit_company_company() as vendor,
    fakeit_currency_price() as amount,
    fakeit_payment_credit_card_type() as payment_method,
    fakeit_datetime_date() as order_date
FROM generate_series(1, 1000);

Generate Log Entries

SELECT
    fakeit_datetime_date() as timestamp,
    fakeit_internet_ipv4_address() as ip_address,
    fakeit_log_level_apache() as log_level,
    fakeit_internet_http_method() as http_method,
    fakeit_status_code_general() as status_code,
    fakeit_user_agent_chrome() as user_agent
FROM generate_series(1, 10000);

Generate GeoJSON Data

SELECT json_object(
    'type', 'Feature',
    'geometry', json_object(
        'type', 'Point',
        'coordinates', json_array(
            fakeit_address_longitude(),
            fakeit_address_latitude()
        )
    ),
    'properties', json_object(
        'name', fakeit_name_full(),
        'city', fakeit_address_city(),
        'country', fakeit_address_country()
    )
) as geojson
FROM generate_series(1, 50);

Known Limitations

Note: The extension currently returns identical values across multiple rows when used with generate_series() due to DuckDB's function optimization. Single-row queries function correctly. A fix addressing the VOLATILE flag support is pending in the duckdb-rs library.

Use Cases

• Test Data Generation: Populate development and test databases with realistic data
• Prototyping: Quickly mock up applications with sample data
• Data Masking: Replace sensitive production data with fake data for testing
• Load Testing: Generate large datasets for performance testing
• Demos and Presentations: Create compelling demo data for showcasing features

This extension is experimental and actively being developed. See the repository for the latest updates and examples.

Added Functions