DataTalk plugin for AppGini

DataTalk plugin for AppGini

DataTalk plugin for AppGini
License: Commercial, per-user
Compatible with any PC/server that can run PHP

DataTalk is a powerful AppGini plugin that transforms how you access and analyze your database—while keeping your data private and secure on your own server. Instead of writing complex SQL queries, you simply ask questions in plain English or your native language, and DataTalk instantly delivers accurate answers.

The advanced AI models from OpenAI are used solely to interpret your questions: only your database schema is sent to OpenAI, never your actual data. This means your sensitive information remains protected within your server at all times. With DataTalk, anyone on your team can effortlessly retrieve, analyze, and share both live and snapshot reports, making collaboration simple, fast, and secure—without compromising data privacy.

Your Data, Your Questions, Instant Answers—Powered by AI

Ask Questions Naturally, in Any Language

With DataTalk, you can interact with your database using everyday language—no SQL required. Ask questions in any language, and only your database structure is shared with OpenAI to generate the right SQL, while your actual data always stays private and secure on your server.

Save, Share, and Export Reports

Easily save the results of your questions as reports to view later or share with others in your app. Choose between static reports, which capture data at a specific moment, or dynamic reports that always show the latest information. Control access for different user groups, and print reports or download them as CSV files for use in Excel whenever you need.

Watch the video to see how to create, share, and analyze data reports with DataTalk.

Questions history

DataTalk automatically saves your questions, so you can easily review, re-run, or delete them whenever you like. To boost efficiency and reduce OpenAI API costs, repeated questions are answered from your history by default. If you want to update or improve the underlying SQL query—such as taking advantage of newer AI models—you can always resend your question to OpenAI.

Export results to CSV

DataTalk allows you to export the results of your questions to CSV format. This makes it easy to share the results with your coworkers, vendors, or customers, or to analyze them in Excel or any other spreadsheet application.

Multilingual Experience

DataTalk’s interface adapts to your preferred language, and you can ask questions in any language—not just English—for seamless, accessible data interaction.

Your Data Stays Private and Secure

DataTalk never shares your actual database data or user details with OpenAI—only your question and a simplified schema are sent. All queries are read-only, so your data is never modified. For full transparency, you can click the Data safety note button in the plugin to see exactly what information is sent to OpenAI.

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.2 was tested with AppGini 25.12.
Do I need an OpenAI account to use DataTalk plugin?
Yes, you’ll need an OpenAI account and an API key to use DataTalk. The first time you open the plugin, you’ll be prompted to enter your OpenAI API key. OpenAI no longer offers free credits for new accounts, so you’ll need to add payment details and purchase credits before you can use the API. The minimum amount you can purchase is $5, and these credits expire one year from the date of purchase.

Regarding pricing, the GPT-4.1 model currently costs $2 per 1 million tokens. Each question you ask—including the database structure and the AI’s response—typically uses between 300 and 2,000 tokens, so most questions cost just a fraction of a cent. To help you save on costs, DataTalk automatically caches previous questions to avoid repeated API requests whenever possible.

More details on OpenAI API pricing and rate limits.
Does OpenAI have access to my database when I use DataTalk?
No, OpenAI does not have access to your database or any of your data. When you ask a question, DataTalk sends only your question and a simplified version of your database schema—never any actual data—to OpenAI for processing. Your database and its contents remain securely on your server at all times. For more details, you can click the Data Safety button within the plugin’s interface.
Who can access the DataTalk plugin in my AppGini app?
Only admin users can access the DataTalk plugin. This is because the SQL queries generated by OpenAI aren’t limited to individual users, so results can’t be automatically filtered for specific access. However, you can save results as reports within DataTalk and share them with specific user groups, or export results as CSV files to distribute them manually to other users.
How do I adjust DataTalk settings? (e.g. change OpenAI model, set language, set the OpenAI API key, etc.)
To adjust DataTalk settings, click the Settings button in the plugin’s interface. This will open a settings page where you can change the OpenAI model, set your OpenAI API key, and select your preferred language for the plugin’s interface. See the video below for a quick overview of the settings page.
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?
OpenAI 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 OpenAI "hallucinating" field names that don't exist in your tables. See the screenshot below for an example. An error occured while processing your question. Unknown column in field list. 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: Use table hints to fix OpenAI SQL errors.
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?
The DataTalk plugin runs only from the plugins/datatalk folder. When you create reports, it adds an entry to the hooks/links-home.php and hooks/links-navmenu.php files to add a link to the reports page in the app's homepage and top navigation menu. No other code is added to any of your app's files.
I have a question not addressed here ... how can I contact you?

What's new?

Latest version: 2.2, released on Jun 24, 2025
  • DataTalk 2.2, Jun 24, 2025
    • Add printing and CSV export functionality and improve report UI.
    • Refine SQL query suggestions and improve UI/UX for question submission.
    • Improve display of grouped results.
    • Add model selection to settings, allowing user to choose preferred OpenAI model for optimizing answers.
    • Various UI enhancements and bug fixes.
  • DataTalk 2.1, Jun 5, 2025
    • Fix theme loading issue with apps created by AppGini 25.11 and above.
    • Allow admin group members to access the DataTalk plugin if multiple admins option is enabled.
  • DataTalk 2.0, Aug 21, 2024
    • Switched to GPT4o Mini: Benefit from faster, more accurate, and cost-effective performance with the new OpenAI 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!