Supabase
The open source Firebase alternative
Start new thread

AI SQL Editor by Supabase - Write SQL without knowing SQL

byβ€’
The AI powered SQL editor is a game changer for anyone looking to write SQL without actually knowing SQL. The Supabase SQL editor can intuitively understand what you're trying to query and offer smart suggestions uniquely just for your database.

Add a comment

Replies

Best
I had a chance to test it, and I love it. I was in a waitlist for copilot since it’s announced, and use it daily, and now supabase ai can be my second copilot right in the dashboard πŸ’š
so convenient isn't it? Also that your database schema can be shared with the AI is super helpful. Major efficiency gain.
yeah, you are literally one checkbox away from the ultimate experience πŸ”₯
wow I tried this and it’s insane!
I agree with you!
seconded and thirded
Hunter
Thanks!
I find it very useful not to remember the full syntax, just generate it with AI and then check and correcting results manually. Probably it's a good time-saver for people who don't write only SQL queries 24/7.
agreed, I never remember the RLS use vs check syntax, really helpful to have a smart assistant by my side.
The idea of the diff similar to Git is genius, especially in this context!
I asked it to generate a schema for a multi-tenanted application and it got it right with tables like tenants, users, orders etc. I could even tweak the initial schema with further instruction to massage it to my specific use case. Impressed!
Really lovely seeing this out and available for everybody to use! Oftentimes you'll head into an SQL editor to dive down into your project's data and are left with a blank textarea not knowing where to even start - this takes away that initial overhead and gives you a headstart into working with your data rather than mucking around with syntax.
agreed, it's awesome that it's available for all to improve their SQL skills \o/
I just wanted to drop a quick note to say that I tried out the new Supabase AI SQL Editor, and it's absolutely fantastic! πŸš€ Kudos to the team for bringing such a helpful tool to the SQL Editor! It's a real time-saver, and I can already see myself using it more and more. Exciting times ahead!
Kudos to the team for integrating Supabase AI into the SQL editor of Supabase Studio Dashboard in record time! Can't wait to see what else is announced this week!
This looks amazing!! What model did you use to generate the suggestions? Is the code and the prompt used to generate the suggestions open source?
Maker
Currently using OpenAI's GPT 3.5 model as a compromise between speed, cost, and quality. Overall quality is still very high, and today 3.5 is much faster and cheaper than GPT 4. We will definitely be updating this though as new and better models are released! All the code is open source and !
Interesting prompt..I like that you are recommending best practices in the prompt itself! Have you considered any of the open models from HuggingFace?
yes, would be interesting to see this working with an open source model from Hugging Face and compare the performance. I think that's planned.
Maker
yes we would love to experiment with open source large language models like Llama 2, the biggest hurdle being finding a good way to host them (very resource heavy today). Alternatively a smaller & dedicated text-to-sql model could be another option.
Great feature, I use it every time I need a SQL query.
First
Previous
123
β€’β€’β€’
Next
Last