SQL ChatBot! Update 2025-09

A new powerful chat bot based on a local and private LLM model of Artificial Intelligence, able to translate into SQL your free data analysis prompt, and then applying them to any db to provide insight, SQL code, profile and export data!

The video below illustrates the main features of our SQL Chat Bot, friendly called "chattino".

This last and enhanced version provide you:

1. a new database selector among predefined database such as in SQLite, Oracle or SQL Server.
2. the possibility to select and load into your database data files in CSV format.
3. a column description and a table preview of the data loaded or available in a schema of your database.
4. features to extract and export information from your tables or to profile them with many charts including bar charts, word cloud, box-plot...
5. features to select and order the tables that you consider as input for your queries, this order is saved and restored per each available database.
6. a chat interface in any natural language, being able to translate user requests into queries and actions, automatically submitted and executed on the database.
7. a program in SQL corresponding to your request to be executed or submitted.
8. the program in SQL can be executed immediately or first controlled / modified / verified and then submitted.
9. produced queries can be slightly different depending on the SQL syntax specific of the selected database engine.
10. the results of the execution or submission of the code starting from your data and database are shown immediately together with the elapsed time of execution and possible messages.
11. an optional extraction of your data as requested to be exported into CSV or Excel files.
12. some optional charts can be requested to profile or describe your data.
13. when available by the current database, functions and statistics such as correlation can be provided too.
14. the SQL programs produced by our Chattino are always well indented and commented.
15. the SQL programs produced can be cumulated in a job, copied, modified and then stored as you like.
16. a second chat interface in any natural language can be provided as a premise for the LLM model, to add specific information about complex relations among tables that can improve the query production. Usually provided by your DBA.
17. the possibility like this demo to run the Chattino on a local and private LLM model of Artificial Intelligence, without any access to external provider of AI, without license, without internet access of any kind. So, with no risk to spread information outside your organization.
18. the Chattino interface are web based and can be shared among many users in your organization.

This ChatBot is written mainly in python and do not require any specific software license or access to AI providers.


Looking at the demo shown in the videos below, you can observe that this new version of our SQL Chattino is very clever in interpreting your requests starting from prompts of few words, even just a line. It can produce complex SQL query, with any possible clauses, even with nested subqueries and aggregations. It is able to join or merge multiple tables without any user's hints or external metadata. It can also provide DDL or DML code to create tables, insert data, modify date, delete date etc... And often it can correct your query request, and find the right table and variables to be used by interpreting your prompt in an unexpected and clever way.
Finally, our Chattino SQL automatically detects all the keys that link the available tables if the variables have the same name, and sometimes detects more complex association among data by itself, even if the variables have different names.

Here below you can find a long video of our "Chattino SQL". About 40 minutes and not enough to illustrate all its features.
Sorry if the audio quality is not perfect, and it is available only in Italian at the moment.

Download Italian version of the video(about 312 MB)

All our recent videos are available also from our Youtube channel Rationence.

Python and SQL ChatBot!

More and more in demand, chat bots are now able to translate your data analysis prompt into Python and SQL code, and then applying them to provide insight, code, export data, and draw charts!

Here below, we are showing some custom chatbot solutions that demonstrate our ability to develop web apps that starting from data analysis requests in a natural language of your choice are able to interpret your prompt and execute programs on your data without coding any statement.
They are under continuous development to improve their funcionalities. The versions here illustrated are currently available in Italian and English languages. Demo and screenshots were built at the state of the art in date 14th April 2025.

These solutions can provide you:

1. a column description and a table preview of the data loaded or available in a schema of your database.
2. a chat interface in any natural language, being able to translate user requests into queries and actions, automaticaly submitted and executed on the database.
3. a program in SQL or Python code corresponding to your request to be executed or submitted.
4. an explanation of the steps to produce the code above.
5. the results of the execution or submission of the code starting from your data and database.
6. an optional extraction of your data as requested to be exported into CSV or Excel files.
7. some optional charts as requested to describe your data.
8. functions and statistics such as correlation can be provided too.

These ChatBots are written in python and do not require any specific software license.
By default, an API KEY is required to access an LLM model such as those provided by Open AI.
However, alternative open source LLM Models can be implemented on a local private server to avoid any costs, and to prevent any even small amounts of information from being collected by providers such as Open AI.

Looking at the demos shown in the videos below, you can observe that these ChatBots are quite intelligent in interpreting your requests starting from prompts of few words, even just a line.
Finally, they automatically detect all the keys that link the available tables, and they are able to join or merge multiple tables without any user's hints or external metadata, as to code subqueries by themselves.

Below you can find a short video of our chatbot demo named "Chattino", version Python coding.

Download English version of the video(about 32 MB)

Download Italian version of the video(about 39 MB)

Below you can find a short video of our chatbot demo named "Chattino", version SQL coding.

Download English version of the video(about 17 MB)

Download Italian version of the video(about 31 MB)