Using AI to Generate a PostgreSQL Database for Tony Hawk's Pro Skater 2 with Zero SQL Experience 🛹

How far can you get as a backend developer with zero experience with SQL? Turns out quite far when you use AI! 🤖

In this video, Jon Meyers demonstrates how to use Supabase's AI Assistant "Clippy" to generate complex SQL queries based on the context of your PostgreSQL schema! 🧠

00:00 Introduction
00:25 Generating SQL to create a skateboarders table
01:09 Executing queries with the SQL Editor
01:40 Generate relationships across tables with AI
03:00 Populate judges scores for skateboarding competition
03:38 Generate PL/PGSQL to run SQL statements in a loop
04:10 Determine a winner of the skateboarding competition
04:32 Results

👇 Learn more about Supabase 👇

[xiiEJRAM]

The AI integration with the chat is epic. I have been using it since you added it, and it has been very helpful 💚

[mademeanalien]

Would love to see a series for this with RLS, triggers and edge functions….🎉

[abdel]

Love Supabase ❤ Really hate the project pausing on the free tier though

[greendsnow]

Supabase's biggest handicap is SQL. I just watch it from the other side of the window and can never get it... Why don't you guys wrap it around normal js?!

[rtorcato]

Supabase team are doing amazing things, but the support for mobile is a huge problem. Why is Swift Supabase package so lacking in community support? I can't use supabase for any iOS projects since the repo is hardly being supported.

[businessoftechnology]

I normally like these videos, but this one had a title that didn't match the content. ( a.k.a. click-bait ) It could not play Pro Skater 2. A novice could not achieve what you did.

Also, I saw this good. An in the know person could do what you did, saving time and brain drain. I would love your to try to find what percent of not-in-the-know people who could use AI to do what you did. The novice would not know how to ask the questions. Yes, the questions were simple... but all questions are smarter when the inquirer has more knowledge and understanding.

[kevinbatdorf]

Maybe not the best idea to copy/paste arbitrary AI-generated SQL statements into your database. Does Clippy validate the statements before sharing them? At 4:25 you even say "this looks scary enough". This video seems reckless and it's not clear who the target audience is, no offense. Using AI for this should only be done by those already familiar with SQL and can understand what they are looking at. Please no one do this on their production database at work!

[Zololololololotted]

Damn this guy's voice makes me uncomfortable is it AI?