
? Supabase Complete Beginner Tutorial
Build a Student Database API (School Level)
?? Teaching Style: Very Simple for Students
✍️ By Dr. Balaji Shetty
? Index
? What is Supabase (Simple Explanation)
? Tools Required
? Create Supabase Account
?️ Create Your First Project
?️ Create Student Database (SGGS)
? Create Table with Columns
➕ Insert Student Data
? Read Data (Get Students)
✏️ Update Student Data
❌ Delete Student Data
? Automatic API Creation
? Test API Using Browser / Postman
? Use API in Website / Python
? Final Summary
? 1. What is Supabase?
Imagine building a school website where you store:
Student records
Teacher records
Marks
Attendance
Instead of writing complex backend code, Supabase gives everything ready.
It provides:
? Database
? Login system
? API automatically
? File storage
? Think of it like Google Drive + Database + API combined.
SGGS MIS - Student Table with following columns
Column Name Type
reg_no text
name text
year integer 1/2/3/4
branch text
gender text
address text
district text
mobile text
email text
Create Student Table in Supabase (Step-by-Step)
For Beginners / School Students
By Dr. Balaji Shetty
Steps Overview
1 Open Table Editor
2 Create New Table
3 Add Columns
4 Save Table
5 Verify Table
1 Open Table Editor
1 Go to Supabase Dashboard
2 Open your Project
3 Click Table Editor from the left sidebar
2 Click Create a Table
1 In the center panel you will see
Create your first table
2 Click the button
Create a table
3 Do NOT click "Do it for me"
3 Enter Table Name
1 A new form will open
2 Enter
Table Name
students
3 Keep default option
Enable Row Level Security → OFF (for beginners)
4 Keep Default ID Column
Supabase automatically creates a column
Column Name
id
Type
int8
Primary Key
Enabled
Do not change this column
5 Add Columns One by One
Click Add Column and create the following columns
Column 1
Column Name
reg_no
Type
text
Column 2
Column Name
name
Type
text
Column 3
Column Name
year
Type
int4
Column 4
Column Name
branch
Type
text
Column 5
Column Name
gender
Type
text
Column 6
Column Name
address
Type
text
Column 7
Column Name
district
Type
text
Column 8
Column Name
mobile
Type
text
Column 9
Column Name
email
Type
text
6 Final Table Structure
Column — Type
id — int8
reg_no — text
name — text
year — int4
branch — text
gender — text
address — text
district — text
mobile — text
email — text
7 Click Save
1 Click Save
2 Your table students will be created successfully
Purpose of This cURL Command
Send Data to Supabase
Uses POST request to insert a new record into the students table
Create New Student Record
Adds details like name, year, branch, gender, contact information
Authenticate Request
Uses apikey and Authorization Bearer token for secure access
Define Data Format
Content-Type: application/json ensures proper JSON structure
Get Inserted Record Back
Prefer: return=representation returns the created record in response
Useful for Testing APIs
Helps validate insert operations using terminal or Postman
Final Goal
Insert and verify new records in Supabase using REST API without backend code
Supabase is one of the fastest growing backend platforms used by developers to build modern applications without managing complex servers. In this course, you will learn how to build a complete backend system using Supabase from scratch.
This course is designed especially for beginners, students, and developers who want to quickly understand how modern backend systems work. Instead of learning only theory, you will build practical projects step by step.
You will start by understanding what Supabase is and how it works as an open-source alternative to Firebase. Then you will learn how to create databases, design tables, manage data, and build APIs automatically using Supabase.
During the course, you will create a real Student Management Database where you will store student information such as registration number, name, branch, mobile number, and email. You will learn how to insert data, update records, delete entries, and retrieve information using API calls.
The course also teaches how Supabase automatically generates REST APIs for your database tables. You will test these APIs using real examples and understand how frontend applications connect to a backend database.
By the end of this course, you will be able to create your own backend system, build APIs without coding complex server logic, and use Supabase to power web and mobile applications.
This course is ideal for beginners, coding students, developers, and anyone who wants to quickly learn modern backend development using Supabase.