xheaven / laravel-ask-database
Use natural language and AI to query your database from Laravel
1.0.2
2023-08-31 10:40 UTC
Requires
- php: ^8.1
- doctrine/dbal: ^3.6
- illuminate/contracts: ^9.0|^10.0
- openai-php/laravel: ^v0.7.0
- spatie/laravel-package-tools: ^1.14.0
- spatie/once: ^3.1
Requires (Dev)
- laravel/pint: ^1.0
- mockery/mockery: ^1.5
- nunomaduro/collision: ^6.0
- nunomaduro/larastan: ^2.0.1
- orchestra/testbench: ^7.0|^8.0
- pestphp/pest: ^1.21
- pestphp/pest-plugin-laravel: ^1.1
- phpstan/extension-installer: ^1.1
- phpstan/phpstan-deprecation-rules: ^1.0
- phpstan/phpstan-phpunit: ^1.0
- phpunit/phpunit: ^9.5
README
Ask DB allows you to use OpenAI's GPT-3 to build natural language database queries.
DB::ask('How many users do we have on the "pro" plan?');
Installation
You can install the package via composer:
composer require beyondcode/laravel-ask-database
You can publish the config file with:
php artisan vendor:publish --tag="ask-database-config"
This is the contents of the published config file:
return [ /** * The database connection name to use. Depending on your * use case, you might want to limit the database user * to have read-only access to the database. */ 'connection' => env('ASK_DATABASE_DB_CONNECTION', 'mysql'), /** * Strict mode will throw an exception when the query * would perform a write/alter operation on the database. * * If you want to allow write operations - or if you are using a read-only * database user - you may disable strict mode. */ 'strict_mode' => env('ASK_DATABASE_STRICT_MODE', true), /** * The maximum number of tables to use before performing an additional * table name lookup call to OpenAI. * If you have a lot of database tables and columns, they might not fit * into a single request to OpenAI. In that case, we will perform a * lookup call to OpenAI to get the matching table names for the * provided question. */ 'max_tables_before_performing_lookup' => env('ASK_DATABASE_MAXIMUM_TABLES', 15), ];
Usage
First, you need to configure your OpenAI API key in your .env
file:
OPENAI_API_KEY=sk-...
Then, you can use the DB::ask()
method to ask the database:
$response = DB::ask('How many users are there?');
Testing
composer test
Changelog
Please see CHANGELOG for more information on what has changed recently.
Contributing
Please see CONTRIBUTING for details.
Credits
License
The MIT License (MIT). Please see License File for more information.