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.
Hey everyone! 👋
Today, we're releasing a big improvement to our SQL Editor: an AI assistant, embedded directly into the editor.
What can you do with Supabase AI?
- 🚀 Generate tables, reports, and more using natural language
- 🔧 Tweak and massage your query using natural language until you’re satisfied
- 🐞 Debug errors using AI - instead of cryptic messages, get direct solutions
- 🔤 Title your SQL snippets automatically based on the contents of the query
✨ How does it work?
When you spin up the SQL editor, you are now presented with a brand new input where you can ask Supabase AI to build any SQL query you like - using only natural language. For example “build a table to store employees” will produce a CREATE statement auto populated with common fields that you’d likely want to track for each employee.
Of course you don’t have to stop there - Supabase AI is aware of the SQL snippet in the editor and can modify it for you. For example, you could ask Supabase AI to split a “department” text column into its own table, all while adding proper foreign key references and following best practices.
This is all presented via a new diff editor that shows which changes Supabase AI is making to your SQL snippet. This will feel exactly like a Git diff view in an editor like VS Code. Nothing is applied until you accept or discard the change. From there you’re free to keep asking Supabase AI to make changes until you're satisfied.
🎯 Motivation
We've wondered for a long time how to make it easier to teach developers how to use SQL, while at the same time speeding up development for those who do. It's fortunate we didn't solve this problem too quickly, as it turns out that AI does a much better job than we could do ourselves.
We first introduced Supabase AI into our documentation website (aka the revival of Clippy 📎 😄) to help developers answer their questions directly, ChatGPT style, instead of searching for it through the docs. If you’ve had a chance to play around with large language models (LLMs) like OpenAI’s GPT 3.5/GPT 4, you’ll know they are also incredible at generating and interpreting code. The SQL editor was the next natural fit for this technology.
With Supabase AI, you won't even need the whole weekend to scale to millions. Head over to the SQL Editor and give it a try!
📈 What’s next?
In the coming months, we're looking to sprinkle Supabase AI through more parts of the Studio. With Postgres under the hood, there's so much we can do with SQL and a little bit of AI to help you move fast. Keep an eye out for the Supabase AI icon, you never know where it will pop up next.
🌐 Remember - it's all open source!
View all the code right now on GitHub.
—-
Thanks everyone!
We would absolutely love to hear your feedback in the comments.
Greg,
Supabase team
