iTechGuides is reader-supported. When you buy through links on our site, we may earn an affiliate commission. As an Amazon Associate I earn from qualifying purchases. Learn more
You can start a free cloud database with Supabase by creating a project in its Dashboard, then adding a table with the Table Editor or SQL Editor. Each project includes a full Postgres database. This walkthrough creates a small example table you can inspect in the Dashboard; it does not configure a production-ready application.
What you get with a Supabase project
A Supabase project provisions a cloud environment that includes a full Postgres database. Supabase describes it as “a full Postgres database, not a Postgres abstraction.” See the Supabase Database guide. You can create and inspect tables from the Dashboard, and later connect an application to the project.
How to create a free Supabase database
-
Sign in to Supabase and open the Dashboard for an organization you belong to.
Outdated Drivers Are Slowing You Down
One free scan finds every outdated or missing driver and matches the right update for your exact hardware.Free scan · exact hardware matchWindows Errors? Fix Them Before They Spread
Repair common Windows errors and clear accumulated junk for a smoother, more stable PC - no reinstall needed.Free scan · no reinstallSpecial offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy. -
Create a new project and follow the Dashboard prompts to provide the project details and database credentials. Project creation provisions the database environment. Available choices can vary; the getting-started documentation does not establish that every account has identical region options.
#1 Best Overall
CanaKit Raspberry Pi 5 Starter Kit PRO - Turbine Black (128GB Edition) (8GB RAM)- Includes Raspberry Pi 5 with 2.4Ghz 64-bit quad-core CPU (8GB RAM)
- Includes 128GB Micro SD Card pre-loaded with 64-bit Raspberry Pi OS, USB MicroSD Card Reader
- CanaKit Turbine Black Case for the Raspberry Pi 5
- CanaKit Low Noise Bearing System Fan
- Mega Heat Sink - Black Anodized
-
Wait for the project to finish provisioning, then open it in the Dashboard. Supabase’s getting-started guide covers project setup.
Choose the Table Editor or SQL Editor
Supabase offers two ways to create a table. Choose based on whether you prefer a visual form or explicit SQL you can save and run again.
| Workflow | Comfort for a first table | Schema explicitness | Repeatability |
|---|---|---|---|
| Table Editor | Visual Dashboard workflow for entering a table name and columns. | You define the table and columns through the interface. | Steps are not a SQL script by default. |
| SQL Editor | Requires typing and running SQL. | The SQL states the table definition and constraints directly. | You can retain and rerun the statement as needed. |
Both are supported in Supabase’s Tables and data guide. The steps below use the Table Editor; the SQL alternative follows.
Create a first table with the Table Editor
-
In your project Dashboard, open the Table Editor and choose the option to create a table.
Rank #2
CanaKit Raspberry Pi 4 4GB Starter PRO Kit - 4GB RAM- Includes Raspberry Pi 4 4GB Model B with 1.5GHz 64-bit quad-core CPU (4GB RAM)
- Includes Pre-Loaded 32GB EVO+ Micro SD Card (Class 10), USB MicroSD Card Reader
- CanaKit Premium High-Gloss Raspberry Pi 4 Case with Integrated Fan Mount, CanaKit Low Noise Bearing System Fan
- CanaKit 3.5A USB-C Raspberry Pi 4 Power Supply (US Plug) with Noise Filter, Set of Heat Sinks, Display Cable - 6 foot (Supports up to 4K60p)
- CanaKit USB-C PiSwitch (On/Off Power Switch for Raspberry Pi 4)
-
Enter a descriptive, lowercase table name such as
todos. Supabase’s guide recommends lowercase names and underscores where needed, for examplemy_table. -
Define the columns. For a simple example, use a generated bigint primary key named
idand a required text column namedname. A primary key is a value that identifies a row so it can be referred to unambiguously. A text column stores character data; makingnamerequired prevents rows without a name. -
Review the column types and required settings, then save the table. The Table Editor enables row-level security (RLS) when creating a table through the Dashboard.
Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy. -
Add a sample row using the table view—for example, enter a name such as
Buy groceries—and save it. Return to the table view to confirm the row appears.
Create the same table with SQL instead
If you prefer to define the schema explicitly, open the SQL Editor in the project Dashboard and run:
create table public.todos (
id bigint generated by default as identity primary key,
name text not null
);This creates a generated numeric row identifier and a required text value. SQL-created tables require you to enable RLS explicitly; creating the table does not do that for you. To add sample data, run:
insert into public.todos (name)
values ('Buy groceries');Open the table in the Table Editor to verify that the inserted row is visible. Supabase documents table creation and data operations in its Tables and data guide.
The Tool Desk
Outbyte Driver Updater FREEScan for outdated or missing drivers - takes under a minuteDriver Scan →Outbyte PC Repair FREEClear out junk files and repair common Windows errorsFree Scan →Secure the table before exposing it to an application
A table in the public schema may be reachable through the Data API. Supabase warns that until RLS is enabled and a policy is written, anyone holding the project’s publishable key can read and write every row. A publishable key is intended for client-side use, so it must not be treated as a secret that protects rows.
Rank #4
- Broadcom BCM2711, quad-core Cortex-A72 (ARM v8) 64-bit SoC @ 1. 5GHz
- 2. 4 GHz and 5. 0 GHz IEEE 802. 11b/g/n/ac wireless LAN, Bluetooth 5. 0, BLE
- 2 × USB 3. 0 ports, 2 x USB 2. 0 Ports
- 2 × micro HDMI ports supproting up to 4Kp60 video resolution
- Micro SD card slot for loading operating system and data storage
What RLS and policies do
RLS (row-level security) lets policies determine which rows a database role may access. Policies do not replace database privileges: privileges also determine whether a role may perform operations such as selecting, inserting, updating, or deleting. Enabling RLS alone does not grant the access your app needs. Configure both policies and privileges for the specific roles and operations your application requires.
Choose access deliberately
-
For a Table Editor-created table, check its RLS status and add policies that match the intended access before connecting a client.
-
For a SQL-created table, enable RLS explicitly, then add appropriate policies and confirm the role has only the necessary database privileges.
Quick wins for a faster PC:
Fix the driver behind crashes, sound loss and screen glitchesFind Drivers →Clear out junk files and repair common Windows errorsFree Scan →Scan for outdated or missing drivers - takes under a minuteDriver Scan →Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy. -
Do not grant broad public write access just to make a demonstration work. Supabase’s getting-started example intentionally configures public reading; treat it as an example, not a general production prescription.
Best Value
CanaKit Raspberry Pi 5 16GB Starter Kit PRO - Turbine Black (128GB Edition) (16GB RAM)- Includes Raspberry Pi 5 16GB with 2.4Ghz 64-bit quad-core CPU (16GB RAM)
- Includes 128GB Micro SD Card pre-loaded with 64-bit Raspberry Pi OS, USB MicroSD Card Reader
- CanaKit Turbine Black Case for the Raspberry Pi 5
- CanaKit Low Noise Bearing System Fan
- Mega Heat Sink - Black Anodized
See Supabase’s guidance on tables and row-level security and its getting-started example before exposing data.
Independent reader supportYour contribution helps us test, update, and keep practical guides available for everyone.What the Free Plan includes—and what to plan for
Supabase’s billing documentation, accessed October 7, 2026, lists these Free Plan allowances:
| Allowance | Documented Free Plan amount |
|---|---|
| Projects | 2 free projects |
| Database size | 500 MB per project |
| Egress | 5 GB |
| Storage | 1 GB |
These are Supabase-published quotas, not guarantees that limits will remain unchanged. Supabase also says low-activity Free Plan projects may be paused, and its production checklist says downloadable database backups are not available for Free Plan projects. Check the current Supabase billing and plan information before relying on the plan for an ongoing workload.
Free tools Windows power users keep installed
One-click scans. No signup required.
What to do after the first table works
-
Use names and data types that reflect the information each column should hold.
-
Check RLS, policies, and database privileges before your application accesses the table.
-
For important data, decide how you will handle backups and recovery; the Free Plan does not provide downloadable database backups.
-
Use the Dashboard table view to inspect your data, and consult Supabase’s current documentation when you add application access or more complex schema changes.
What’s actually slowing this PC down?
Pick the symptom - the matching free tool is one click away.
Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.Quick Recap
Bestseller No. 2
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
