Supabase AI Postgres Sandbox Database (Quick Tutorial)

This can generate complete info about the database with charts, embeddings, diagrams & more.

📌 Notable features:

↳ Offers intelligent support for various database operations through a large language model.

↳ Allows easy CSV file imports with automatic table generation.
↳ Executes queries directly in the browser using PGlite for fast interactions.
↳ Generates reports and charts based on database data with AI help.
↳ Creates entity-relationship diagrams and SQL migrations based on user descriptions.

and few others

I tried Optimizing our database named "Student Enrollment at University".

📌 Here's a summary of what I did::

↳ I asked it to normalize our table which was already on 1NF form to 2NF and 3NF form.
↳ It did a good job of identifying the Primary keys of different tables. (ex. student ID, professor ID and others)
↳ Then it performed 2nf and 3nf respectively based on the identified primary keys.
↳ In 3nf it was able to create a relationship between the professor's name and department ID.
↳ Overall they did a good job

📌 and here are my personal opinions after the results:

↳ It would have been better if we were able to edit tables directly from the Migration tab.
↳ Very cool software, I think everyone should give it a try.
↳ Though I only performed basic operations. It still gave me quality output with proper reasoning.

Hope you like the video, make sure to like and subscribe.

🧑‍💻Socials: