Transform your table definitions into realistic dummy data with our CLI tool using GPT-4. Simply provide an SQL file, and let the program generate the necessary insertion scripts for you. It's the smart, efficient way to create test data without the hassle, enhancing your development workflow.
The sqdif tool is an innovative command-line interface (CLI) designed to simplify the process of generating SQL insert statements for dummy data. By leveraging the power of OpenAI's GPT-4, this tool allows developers to transform SQL table definitions into fully structured insert commands effortlessly.
Features:
- Input Flexibility: Accepts an SQL file that outlines your database table schema, making it easy to work with predefined structures.
- Smart Data Generation: Utilizes the advanced capabilities of GPT-4 to generate relevant and diverse dummy data, saving you time and enhancing testing efficiency.
- Command-Line Options: Customize your usage with several flags:
--sql-file: Specify the SQL schema file to input.--output-file: Indicate the desired output file for the generated SQL commands (optional).--override: Choose to overwrite existing output files if necessary (optional).--prompt-path: Provide a custom prompt file to guide data generation (optional).--api-key: Specify your OpenAI API key directly from the command line.
Getting Started
To run the sqdif CLI, ensure you have Go installed (version 1.18 or later) and your OpenAI API key set as an environment variable. With these prerequisites in place, executing the program is straightforward. Here’s a quick example:
sqdif --sql-file=./testdata/table.sql --output-file=./testdata/test.sql --api-key={api_key} --override=true
Start generating realistic sample data today with sqdif, and enhance your development workflows!