DataTalk is an innovative AppGini plugin that allows you and your users to interact with your AppGini database using natural language questions. This eliminates the need for writing complex SQL queries and makes it easy for you to retrieve the data you're looking for quickly and efficiently.

With DataTalk, simply ask a question in plain English, and the plugin will translate it into SQL and return the appropriate result set. DataTalk's natural language processing technology is based on the famous ChatGPT API, ensuring accurate interpretation of your questions, making it an ideal solution for businesses and individuals who need to access and analyze data on a regular basis.

Ask questions, naturally
Interact with the database using natural language, just like you talk to your colleagues, eliminating the need for complex SQL syntax. Tip: You can ask DataTalk questions in any language, and ChatGPT will understand them and translate them into SQL code. You could even learn the right SQL syntax by asking DataTalk human questions and copying the generated SQL code.

Multilingual support
DataTalk is available in multiple languages. You can easily set the UI language to your preferred language, and you can ask questions in any language, not just English.

Translation to SQL
DataTalk translates your questions into SQL code, so you don't need to be familiar with database programming. You can copy the SQL code with a single click and use it as-is or customize it in the Interactive SQL queries tool in the admin area of your AppGini application.

Integration with AppGini
DataTalk already knows your AppGini database structure and how to access its contents. No configuration needed. No prompt engineering games. Just start using it out of the box.

User-friendly interface
DataTalk's intuitive interface makes it easy for you to navigate and use in no time.

Like ChatGPT itself, DataTalk takes a minimalistic approach to design, so you can focus on your data and not on the interface. Nonetheless, DataTalk provides many powerful features without sacrificing usability.

Questions history
DataTalk automatically keeps a history of your questions, so you can easily review and re-run them. You can always delete a question from the history if you don't need it anymore. If you click the question text, it will be copied to the input field for you to either edit then re-run, or to run as-is. If the question was asked before, DataTalk will run the corresponding SQL query without resending it to ChatGPT for a faster response.

Export results
Export your results to CSV. You can then easily import them into Excel or any other spreadsheet application. You can also share the CSV file with your colleagues, vendors, or customers.

Saved reports
DataTalk allows you to save your questions and results as reports that you can share with other users of your app. Reports can be static (a snapshot of data at a specific point in time) or dynamic (updated with the latest data).

Frequently asked questions

What's the minimum version of AppGini required for running DataTalk plugin?

The latest version of AppGini is generally recommended when running AppGini plugins. DataTalk 2.0 was tested with AppGini 24.17.

Do I need a ChatGPT account to use DataTalk plugin?

Yes, the first time you open the plugin, you'll be asked to provide a ChatGPT API key. You can currently create a ChatGPT account and obtain an API key for free. You can use that API key for a free trial period, after which you are billed for usage on a pay-as-you-go basis. To give you an idea of pricing, 200 questions would cost around USD 1 or so. And to help reduce your API usage, DataTalk caches questions to avoid making repeated requests to the ChatGPT API. More details on ChatGPT API pricing and rate limits.

Does ChatGPT/OpenAI access my database when I use DataTalk?

No. When you ask a question, DataTalk prepares a prompt consisting of your question and the simplified schema of the database. The prompt doesn't include any data from your database. ChatGPT doesn't have access to your database or the data stored in it. For more detailed info, please click the Data safety button in the plugin's interface.

Which users of my app can access the DataTalk plugin?

Only the admin users can access the DataTalk plugin. This is because the SQL queries returned by ChatGPT can't be modified to limit the results to a specific user. You can, however, export the results to CSV and then share the CSV file with other users of your app.

Some questions result in an SQL error similar to "An error occured while processing your question. Unknown column in field list". How can I fix that?

ChatGPT tries to understand your question and return an SQL query to fetch the data you're looking for. Sometimes, the query it returns is not valid, mainly due to ChatGPT "hallucinating" field names that don't exist in your tables. See the screenshot below for an example. One way of fixing such errors is to modify your question to include a hint about which tables to use for answering the question. Here is an example hint for the above question that fixes the error:

If a new version of AppGini is released, do I need to update this plugin as well?

Usually not. However, if an update is needed we'll issue it free-of-charge.

I already have another plugin installed. Is it safe to install this plugin to the same app into the same plugins folder?

Yes. AppGini plugins share a common set of files that ship with all plugins and are safe to overwrite. Plugin-specific files are installed into a separate subfolder under the plugins folder. So, it's safe to extract this plugin to the plugins folder, overwriting existing files. Both plugins will continue to work fine.

If you make a new version of this plugin, do I have to pay to upgrade?

No. All AppGini plugins come with free life-time updates.

I have several AppGini applications. Do I have to buy a separate license of this plugin for each?

No. When you buy any AppGini plugin, you can install it to all of your AppGini applications. However, just like AppGini, if you are a team of users who use AppGini as part of your development toolset, each user should have a separate license.

Does the DataTalk plugin add any code to hook files?

No. The DataTalk plugin runs only from the plugins/datatalk folder. It does not add any code to hook files.

I have a question not addressed here ... how can I contact you?

Please use our online support form.

• DataTalk 2.0, Aug 21, 2024
  • Switched to GPT4o Mini: Benefit from faster, more accurate, and cost-effective performance with the new ChatGPT model.
  • Advanced Reporting Capabilities: Create static reports to capture data snapshots as it was at a specific point in time or dynamic reports that stay up-to-date with the latest information. This flexibility helps you make informed decisions. You can also specify which groups can access specific reports.
  • Easy Report Access: Reports are now accessible from the application homepage and top navigation menu.
  • Admin Features: Admins can now quickly access OpenAI API usage and costs from the settings page. Also can easily delete and list all saved reports for efficient data handling.
  • Multilingual Support: Now available in Dutch, Italian, Portuguese, Spanish, French, Greek, German, and Arabic, making DataTalk more accessible. It's very easy to add more languages by simply copying a single file and translating it.
  • Enhanced User Interface: Enjoy a smoother and more intuitive navigation with our updated UI.
  • Improved Error Reporting.
  • Improved Prompting: Get better and more accurate results with refined prompts.

• DataTalk 1.3, Dec 13, 2023
  • Fix PHP 8.x warnings.

• DataTalk 1.2, Jul 28, 2023
  • Upgrade model to chatgpt-3.5-turbo (the model used in previous versions, davinci, is deprecated and 10 times as expensive).
  • Increase accuracy through a better prompt.
  • Better security by separating prompt to system and user roles.
• DataTalk 1.1, Jun 10, 2023
  • Preserve history panel expansion status.
  • Better error handling in case of expired API key.
• DataTalk 1.0, Apr 25, 2023
  • First release!