naif/chatgpt-seeder

ChatGPT Seeder

A powerful tool that leverages the capabilities of ChatGPT to automate the generation of realistic and meaningful data for your database seeding need.

Features

Easy data seeding
Real/fake data options
Flexible table selection
Customizable record count
Detailed column info
Selective column insertion
Auto select none nullable columns
Contextual data description
Preview data before insertion
Data regeneration for accuracy
API rate limit handling using retry count
Seamless OpenAI API integration
Customizable configuration
Display API token usage
User-friendly interface
Try catch exception, both backend and frontend

Requirements

PHP 8.0 or higher
Nova 4
OpenAI API Key

Installation

You can install the package into a Laravel app that uses Nova 4 via composer:

composer require naif/chatgpt-seeder

Publish the package's configuration file

php artisan vendor:publish --provider="Naif\ChatgptSeeder\ToolServiceProvider"

Add the below to .env file:

CHATGPT_SEEDER_API_KEY= (OpenAI API Key)
CHATGPT_SEEDER_MAX_TOKENS=1000
CHATGPT_SEEDER_GENERATE_RETRY=3

Usage

Add the tool to NovaServiceProvider.php

  public function tools()
    {
        return [
            new ChatgptSeeder()
        ];
    }

Configuration

ChatGPT Seeder's configuration file, located at config/chatgpt-seeder.php
Allows you to set and customize:

ChatGPT API Key
Maximum tokens to be used for each request (higher number yields longer data)
Retry count: Refers to the tool's ability to retry the data request when the returned data is not valid. It will continue retrying until it reaches the maximum retry count, ensuring a valid and accurate result while avoiding too many API requests.

Steps

1- Access ChatGPT Seeder Tool from the Laravel Nova dashboard.
2- Fill in the required information, such as:

Data type (Real or Fake)
Table Name
Number of Records
Data Required Description
Select any nullable columns.

3- Click the "Generate" button to initiate the data generation process.
4- Data Preview will show up displaying the first 8 records.
5- Click Proceed to insert data to table, or click on Regenerate again until you are satisfied with the result.