👾 📢 Join our Discord or email us at founders@aisqlgen.com for updates, support, and more!
Don't write SQL by hand. Use LLMs to link to your SQL database, then generate, edit SQL, and auto-generate visualization. Run it locally.
Pre-requisites: OpenAI API Key, Postgres Database (more database support coming soon)!
- Install
yarn
- Start
cd frontend
yarn dev
-
Input your OpenAI API Key
- Add your datasource
- Generate or edit your query!
A "query" is a single notebook for which you can iterate on a SQL statement with natural language. You can create more by clicking 'create new query'.
Write plain-text in the input box to generate the appropriate sql query. Run generate.
The more descriptive the question is, the better the performance will be.
->
The above SQL query is generated in one-shot.
However, other times, the query may not be generated properly and may not run.
We understand that your databases are not open source datasets. We know that they have complex data. We know that you may have pre-existing queries that you want to edit.
The UI is designed such that you can make modifications on the SQL by hand manually. You can also copy and paste the SQL script to begin with. Add plain-text description on how you want the query to be edited. Run edit and wait for the magic!
->
You can see that the WHERE clause is added to the query properly given the context.
With a simple description, you will be able to visualize your data. Currently, we've only tested charts that would work with Chart.js, but we will be able to support all types of visualization in the near future.
For 60~70% of the time, 3.5 is sufficient to generate the query, and since it's a lot cheaper and faster, we leave it as an option. If you end up with an error, typically switching on 4 makes things just work.
For each query item you set up, you can view its history.
Blue represent user inputs and purple represent generated artifacts. We use next.js API routes for conveniency since it runs on Node. The routes establish connection with the Database and LLM (currently GPT).
All data is saved locally - none of your API Key or data source information is shared with anyone else. Down the road when we have a hosted version, we will encrypt the information.
- More database connectors
- More visualization outside of Chart.js
- Email us at founders@aisqlgen.com
