Have something to say?
Auto-fix queries in the backend
As it's known AI can hallucinate, and it can even suggest columns that don't exist in your database. To solve this, have the option to auto-fix the queries, by passing them to another prompt again and making sure the columns are valid or maybe even running the query if it's a safe one.
Read-Only Mode
This would be a new setting that would only allow non-destructive operations (basically only SELECTs) to run. Just in case the user wants to query their database in a chill mode, without worrying about possibly messing up stuff.
Add multiple chat support
Right now, we've only got one chat, that we can pick different queries and reset it. But it'd be good to have the possibility of creating multiple so we can keep each chat's context.
Optimize Mode
Create new chat mode for query optimization, this could read the current query, explain analyze it, view existing indexes and propose new query or new safe indexes to make it faster. We could throw in an Analyze Mode that does half of the work and doesn't make changes, just analysis.
Add Indexes to database sidebar
Right now, we can only see tables in the database sidebar. It would be really powerful to see indexes and other database artifacts, such as triggers and more
Improve query output in case of no results
This sucks. We still need the output footer to see at least how long it took.
[BUG] AI Chat shortcut (⌘ + I) unexpected behavior
If the AI chat isn't focused, the shortcut should focus it. If it's focused, the shortcut should collapse it.
Improve theme colors in the editor
Make the theme color of the Monaco Editor match the TurboSQL overall style. Make sure to fix the bright red color of the simple string, i.e. '123'. Make sure SQL is properly highlighted as well.