We have chosen to take the best of the existing SQLAI app and implement many of the suggestions we have received. To ensure that our users always have a stable and professional SQL and NoSQL tool at hand, we are launching the new SQLAI app separately. Below we describe the most significant improvements we have made - if you have any feedback or found a bug, please feel free to drop us a message (praise also welcome).

SQL and NoSQL generator (RAG-based text-to-SQL)

We’ve rewritten this generator from the ground up based on user feedback and the latest AI technology. Specifically, this means that the new SQL generator uses an extensive vector database, with over 100,000 vectors of existing SQL queries, to gather context-relevant information before SQL generation begins. This is called RAG (retrieval augmented generation) and it ensures that the SQL generations are much more reliable and higher quality. Previously, we experienced several fluctuations where AI went in the wrong direction, which has been minimized. It also generates much faster, which significantly increases usability.

In list form are improvements:

• RAG-based text-to-SQL generator based on a vector database with over 100,000 vectors
• Many times faster SQL generations quality assured with RAG

You can try out the new SQL and NoSQL generator here.

Datasources

Overall, we have made it easier to add and manage your data sources. Data sources can be added in 2 ways:

• by importing the database schema in any format (which happens automatically with AI)
• connecting to your database

We ONLY store the database schema, never your data.

You can see it here.

We’ve also made it easier and more manageable to add data source rules and share your data source with other users. When you share your data source with other users, users will now receive an email about it. You can see more on your data source overview.

Other improvements

• saved generations have been renamed to “Saved queries” and now side-by-side generation for increased usability
• settings](/settings) have been simplified (they can also be operated directly from generators)
• dark and light theme

Feedback

If you’ve found a bug, have an idea for improvement or just want to give us your input, please don’t hesitate to drop us a message. All messages are read and appreciated and we do our best to answer any questions.