Supabase
The open source Firebase alternative
Start new thread

Supabase AI Assistant [LW24] - Idea to Postgres database

by•
A global AI Assistant with several new abilities, such as Postgres schema design, data queries and charting, error debugging, Postgres RLS policies, Postgres Functions, Postgres Triggers, SQL to supabase-js conversion - Available today.

Add a comment

Replies

Best
Hunter
📌
It is “Battle Royale". 15+ Launch Weeks battle it out for the Product Hunt prize. This is supa exciting - my colleagues and have been working on a new iteration of Supabase AI Assistant. This will quickly become part of my daily workflow with Postgres. My favorite ability of the Assistant is being able to quickly insert sample data without having to think about how that SQL looks. Perfect for any developer building with Supabase. Worth checking out above! 👆or hit `cmd + i` in the Supabase Dashboard.
so *hyped* by this mega launch week! keep launching ?makers! 👏👏
Well done guys, really cool video :)
great work on this one Jonny, Saxon, and Joshen!!
make it make my app profitable please
I listened to the Twitter space with , that was really insightful. Thanks for the awesome work!
Maker
Hi everyone, Today I’d like to introduce you to the new Supabase Assistant. It’s a single, persistent panel that sits alongside your workspace and can be called upon when needed (cmd+i!). It automatically retrieves context (e.g. your schema, tables, policies) based on your prompt and can be given extra context to work with, such as a policy, function, or any kind of SQL statement. It has several new abilities: * Postgres schema design * Data queries and charting directly in assistant * Error debugging * Postgres RLS Policies: create and edit * Postgres Functions: create and edit * Postgres Triggers: create and edit * Convert SQL to supabase-js client code You can go from designing your database to querying and inserting data without touching a line of sql. When used right, we feel it can be a real time saver and empower a lot of people. Here is how to get started: * to get a general idea of what to expect * for a more detailed breakdown * within your own project dashboard Give it a try! We’d love to hear your feedback and ideas in the comments. Thanks everyone! Happy building!
Hunter
congrats folks. Really sick launch. Just noticed the Assistant is context aware of what SQL snippet I'm looking at :D
This is going to be a huge deal for people who are still learning the ropes of postgres and sql.
This is exciting! Are there any future plans on the assistant?
Maker
This release gives us a foundation to build off and extend with new abilities/tools/context. Expect to see more connections from the Dashboard to Assistant, and vice versa. Would love to see logging/monitoring tie into this for example :)
Sounds awesome! So excited for the future!
I love the charting feature a lot!
Hunter
What did you ask it ?
I had a demo e-commerce app, so I asked it to generate various business insights about it! It does a really good job even with my poor prompting!
my favorite too!
Charting feature is amazing!
Connecting charts to real DBs will be super useful 😄
The demo is super cool! How does it generate the charts?
Hunter
uses , which we've wrapped into a Chart component like , and then that's used in a .
Yeah! I really enjoyed watching the demo! LFG!
The new chart component by ui.shadcn are really nice
oh, that's super cool, thanks for sharing. also awesome that it's all open source
The AI Assistant looks awesome! Is there any limits on the number of questions can ask?
Maker
No limit. You’ll get the most value when it has a schema to draw context from.
Agreed, the automatic schema context makes this super useful
Hi Saxon, The Supabase Assistant sounds like a fantastic tool for streamlining database management and boosting productivity. It's great to see such comprehensive features packed into one assistant. How intuitive is it for someone new to Postgres to get started with designing a schema using the assistant? Looking forward to trying it out!
for someone new to PG probably better to start playing around with database.build first and then jump to supabase assistant
you can always create a Supabase project and spin up some of the examples to get a feel for schema design and use this AI Assistant to help you build out a schema for your project.
also stay tuned for the rest of the launches this week, some more awesome tooling coming that will be helpful \o/
Watching this feature cook for the past few weeks has been incredible, kudos to Joshen and Saxon for the amazing work. I am very excited to see how the AI assistant evolves 😁 amazing work team
The assistant makes it so easy to write row level security rules now! 😍
Hunter
Soon it can bake a baguette
That is pretty much the only way I write RLS policies these days. let the AI write it 😂
Agree! Will definitely use it for that purpose 🤩
Man, this looks awesome!!
this is like Cursor for databases
Hunter
the cmd+i supapower
123
•••
Next
Last