…you can also use AI “directly” yourself. Personally, I would recommend my own [little text-to-SQL web app](https://www.sqlai.ai/) which, in addition to AI and optimized prompts, offers: - adding or connecting a database - database schema autocomplete to quickly look up and add table/column names…
You are welcome to check out [sqlai.ai](https://www.sqlai.ai/). It has free tier with no credit card required. I have noticed quite a few schools use it. Using AI is a great and practical way to explore SQL. You can then slowly fill in with theory when needed. Beyond generating SQL snippets, you…
I am building a [side project](https://www.sqlai.ai/) that amongst other generates, optimizes and fixes SQL using AI. Adding your specific database schema to these generations makes AI significantly more accurate while requiring less instructions. Users can add database schemas (they can also add…
…because it quicker returns a response and is easier to understand each part of the SQL query, [like so](https://www.sqlai.ai/snippets/cls4hkxdd000j14napsa5tirz) (multiple languages supported). Also it likely improves accuracy to set database engine, using GPT-4 and including database schema in…
Not even including database schema to improve AI accuracy? It is actually both easy and can be optimized/handled by AI. On [SQLAI](https://www.sqlai.ai/app/datasources/add/database-schema) I use AI to parse any database schema into CSV as I find this performs best.
Hello, thanks, we tested SQLAI but when we try to optimize our database (index, primary key, etc.) with an Oracle database it does not give reliable results and when I check the index calculation formula I found that it was different by compared to the formula used on oracle database to calculate…
Hi, For solving the problem with textsql and sqlai, i have built [sqpilot.ai](http://sqpilot.ai) It works locally, has the context of your database so you don't have to copy any schema, just mention the tables in the prompt and with be added to the prompt, I would love to hear your feedback for it
…logic in any major application (way less error-prone). That being said, [one of my previous apps](https://www.sqlai.ai/app) is a classical NextJS-Redux app and even then there still are so many components/pages that are almost entirely static. There is no reason these components/pages…
…There is an upper limit of 3MB for each database schema. I would recommend [adding your database](https://www.sqlai.ai/app/datasources/add) and then give it a try. Please note, you don't actually import database data, only the schema. The database schema is only a small fraction of the…
I had the same issue until I added a few [data source rules](https://www.sqlai.ai/documentation/ai-generators/generate-sql-query#data-source-rules). That combined with a database table autocomplete for quick references to tables and columns, just make it work. Might be worth a try.