Subscribe
Sign in
Supabase
p/supabaseThe open source Firebase alternative
Start new thread
Jonny Summers-Muir

Supabase AI Assistant [LW24] - Idea to Postgres database

by
Top Product
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
Jonny Summers-Muir
Top Product
Hunter
📌
It is MEGA LAUNCH WEEK “Battle Royale". 15+ Launch Weeks battle it out for the Product Hunt prize. This is supa exciting - my colleagues @saxonfletcher and @joshenlimek 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.
flo merian
@saxonfletcher @joshenlimek @jon_summers_muir so *hyped* by this mega launch week! keep launching ?makers! 👏👏
Ant Wilson
Top Product
@saxonfletcher @joshenlimek @jon_summers_muir great work on this one Jonny, Saxon, and Joshen!!
@saxonfletcher @joshenlimek @jon_summers_muir make it make my app profitable please
Thor
@saxonfletcher @joshenlimek @jon_summers_muir I listened to the Twitter space with @joshenlimek, that was really insightful. Thanks for the awesome work!
Saxon Fletcher
Top Product
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: * Play with a static demo to get a general idea of what to expect * Read the blog post for a more detailed breakdown * Open the assistant 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!
Jonny Summers-Muir
Top Product
Hunter
@saxonfletcher @joshenlimek congrats folks. Really sick launch. Just noticed the Assistant is context aware of what SQL snippet I'm looking at :D
Sam Rose
@saxonfletcher This is going to be a huge deal for people who are still learning the ropes of postgres and sql.
Tyler Shukert
@saxonfletcher This is exciting! Are there any future plans on the assistant?
Saxon Fletcher
Top Product
Maker
@dshukertjr 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 :)
Tyler Shukert
@saxonfletcher Sounds awesome! So excited for the future!
Tyler Shukert
I love the charting feature a lot!
Jonny Summers-Muir
Top Product
Hunter
@dshukertjr What did you ask it ?
Tyler Shukert
@jon_summers_muir 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!
Karan Shah
@dshukertjr Charting feature is amazing!
Greg Richardson
@dshukertjr Connecting charts to real DBs will be super useful 😄
Inian Parameshwaran
Top Product
The demo is super cool! How does it generate the charts?
Jonny Summers-Muir
Top Product
Hunter
@everconfusedguy uses Recharts, which we've wrapped into a Chart component like ui.shadcn, and then that's used in a generative ui component.
Karlo Ison
@everconfusedguy Yeah! I really enjoyed watching the demo! LFG!
Tyler Hillery
@everconfusedguy @jon_summers_muir The new chart component by ui.shadcn are really nice
Thor Schaeff
@everconfusedguy @jon_summers_muir oh, that's super cool, thanks for sharing. also awesome that it's all open source
Bo Lu
The AI Assistant looks awesome! Is there any limits on the number of questions can ask?
Saxon Fletcher
Top Product
Maker
@bo_lu2 No limit. You’ll get the most value when it has a schema to draw context from.
Greg Richardson
@bo_lu2 @saxonfletcher Agreed, the automatic schema context makes this super useful
Alex Dulub
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!
@web3_antivirus for someone new to PG probably better to start playing around with database.build first and then jump to supabase assistant
Wen Bo Xie
Top Product
@web3_antivirus 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.
Thor Schaeff
Top Product
@web3_antivirus @wenbo 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
Julien Goux
The assistant makes it so easy to write row level security rules now! 😍
Jonny Summers-Muir
Top Product
Hunter
@jgx Soon it can bake a baguette
Tyler Shukert
@jgx That is pretty much the only way I write RLS policies these days. let the AI write it 😂
Karlo Ison
@jgx Agree! Will definitely use it for that purpose 🤩
kiwicopple
Top Product
this is like Cursor for databases
Jonny Summers-Muir
Top Product
Hunter
the cmd+i supapower
David Fernández
Man, this looks awesome!!
Pamela Chia
Super fun supabase video! Looking forward to more John with a “h”
Jonny Summers-Muir
Top Product
Hunter
@pamelachia John will return
Thor Schaeff
Top Product
Incredible work @saxonfletcher and team. Enabling Aussies to write SQL, what a feat! ;)
Uladzislau Rasliak
This is the final blow for those urging non-technical tech workers to learn SQL from scratch. Congrats, will check it out on my pet projects built on Supabase!
Ivan Vasilov
Just tried it, it's so amazing!
Jonny Summers-Muir
Top Product
Hunter
@ivan_vasilov You're amazing!
Ariuna Khenmedekh
Amazing Launch! Love these videos and love the guy John with H!!!
Jonny Summers-Muir
Top Product
Hunter
@ariuna John will return
Hideyuki Yamada
This release is the best of all previous! (every time SB launch new features, it's best)
Jonny Summers-Muir
Top Product
Hunter
@ideagarage thanks Hideyuki! 🙏
Cam Pak
wild. Upvoted!
kiwicopple
Top Product
@campak 🙏
Wen Bo Xie
Top Product
Whoa, this is sick! Love that Supabase took the learnings from its experimental app https://database.build and applied it to Supabase with this cohesive AI Assistant.
Jordan Burnett
Wow great work - I've been a fan of Supabase for a while and was looking for an excuse to fire it up for an example project. This might be just the nudge I needed!
Ant Wilson
Top Product
@jorburn give it a go and let us know what you think!
Wen Bo Xie
Top Product
@jorburn looking forward to seeing what you build with Supabase!
Egor Romanov
@jorburn thanks, i think you are going to enjoy it!
Terry Sutton
Top Product
Anything missing? What else would you like the Assistant to do?
@saltcod cook dinner and take out the trash when it’s cold outside
Charis
@saltcod Cook my meals? 😂 Seriously though, it's already pretty incredible. Better keyboard support is probably on my wishlist, I like being able to edit and accept AI suggestions without reaching for a mouse in my IDE