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
•

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
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! 👏👏
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
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
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
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 :)
Paul C
@saxonfletcher loving how easy this is to use, and how it is lowering the barriers to database design. The implications for levelling developers up who might not yet have really got into PostgreSQL is huge.
Tyler Shukert
I love the charting feature a lot!
Jonny Summers-Muir
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!
Charis
@dshukertjr so good for ad-hoc analysis! (time to delete all the SQL snippets I have named various versions of scratch....)
Inian Parameshwaran
The demo is super cool! How does it generate the charts?
Jonny Summers-Muir
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.
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
Maker
@bo_lu2 No limit. You’ll get the most value when it has a schema to draw context from.
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
@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
@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! 😍
kiwicopple
this is like Cursor for databases
David Fernández
Man, this looks awesome!!
Pamela Chia
Super fun supabase video! Looking forward to more John with a “h”
Thor Schaeff
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!
Ariuna Khenmedekh
Amazing Launch! Love these videos and love the guy John with H!!!
Hideyuki Yamada
This release is the best of all previous! (every time SB launch new features, it's best)
Cam Pak
wild. Upvoted!
Wen Bo Xie
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!
Terry Sutton
Anything missing? What else would you like the Assistant to do?
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