What’s actually slowing this PC down?
Pick the symptom - the matching free tool is one click away.
You can start a cloud database on Supabase’s Free Plan by creating a project in its Dashboard, then adding a table with the Table Editor or SQL Editor. A Supabase project includes a full PostgreSQL database. The steps below get a table and sample row into the Dashboard; they do not make the database production-ready.
How do I create a free Supabase database?
- Sign in to Supabase and open the Dashboard. Choose an organization you belong to, then create a project from that organization. Supabase’s getting-started guide describes this flow.
- Enter the requested project details, including a name and database password, and choose from the options the Dashboard presents. Project creation provisions the database environment. Available choices can depend on your account and current service options.
- Wait for the project to finish provisioning, then open it in the Dashboard. Supabase describes each project as having a full Postgres database, rather than a Postgres abstraction, in its Database guide.
Supabase’s Free Plan has limits, so “free” means you can begin within its included quotas, not that the project has unlimited capacity or guaranteed uninterrupted availability. The current documented allowances and caveats are covered below.
As an Amazon Associate I earn from qualifying purchases.
Should I use Supabase Table Editor or SQL Editor?
Supabase supports both Dashboard-based table creation and SQL statements. Choose based on whether you want to configure fields visually or specify the schema as code.
Do these 3 things before closing this tab:
1Fix the driver behind crashes, sound loss and screen glitches2Clear out junk files and repair common Windows errors3Scan for outdated or missing drivers - takes under a minute| Workflow | Comfort for a first-time user | Schema explicitness | Repeat the steps later |
|---|---|---|---|
| Table Editor | Enter a table name and columns through the Dashboard. | Set each column and its type in the visual interface. | Repeat the steps in the interface; the resulting schema is less convenient to reproduce as a saved script. |
| SQL Editor | Requires familiarity with SQL statements. | The SQL states the table definition directly. | Save and rerun the statements as needed, accounting for whether the table already exists. |
For a first table, the visual editor is a reasonable route if SQL is unfamiliar. The SQL route is useful when you want the definition written out explicitly. Both routes still require you to consider row-level security and access privileges.
#1 Best Overall
How do I create my first table in Supabase?
Option 1: Create it with the Table Editor
- In your project Dashboard, open the Table Editor and choose the option to create a new table.
- Give the table a descriptive name, such as
todosorinstruments. Supabase recommends lowercase names and underscores when needed; avoid spaces and use a name that describes the records the table will hold. - Add the columns your data needs and select a data type for each. For example, a task table might need a text column for its title and a boolean column for whether it is complete. A data type tells Postgres what kind of value a column holds.
- Keep a primary key column so each row has its own identifier. Supabase’s example uses a generated
bigintprimary key and a required textnamecolumn. A primary key is the value used to distinguish and refer to one row. - Save the table, then use the editor’s row-insertion controls to add one sample record. Open or refresh the table view and confirm that the new row appears.
Option 2: Create it with SQL
Open the SQL Editor in the project Dashboard, enter a table definition, and run it. This example follows the documented pattern of an automatically generated bigint key and a required text name:
create table public.instruments (
id bigint generated by default as identity primary key,
name text not null
);Then insert a sample row:
insert into public.instruments (name)
values ('guitar');Open the table in the Dashboard to check that the row is present. If you run the table-creation statement again, it may fail because the table already exists; use the Dashboard or adjust your SQL deliberately rather than deleting data just to repeat the tutorial.
How do I secure a Supabase table?
Security is part of table setup, not a later polish step. A table in the public schema may be accessible through the Data API. Supabase warns that until row-level security (RLS) is enabled and a policy is written, anyone with the project’s publishable key can read and write every row in such a table. See the Tables and data guide.
Recommended Free Tools
- With the Table Editor: Supabase enables RLS when you create a table through the Dashboard. Check the table’s security settings and add policies that match the access your application actually needs.
- With SQL: A table created by SQL requires you to enable RLS explicitly. For this example, the command is
alter table public.instruments enable row level security;. Enabling RLS does not itself grant access; add an appropriate policy for the intended roles and operations.
RLS policies determine which rows a database role may access. Database privileges separately determine which operations that role may perform. Both layers need to match your intended access. Do not grant broad public write access simply to make a demonstration work; choose the least-privilege access your application requires. The official example that permits public reads is a specific example configuration, not a general production recommendation.
Rank #3
What does Supabase’s Free Plan include?
Supabase’s billing documentation, accessed October 7, 2026, lists these Free Plan allowances. They are published product quotas, not performance guarantees, and may change; check the current Supabase billing and pricing guidance before planning around them.
| Documented allowance | Free Plan figure | Qualification |
|---|---|---|
| Projects | 2 free projects | Supabase’s documented allowance, accessed October 7, 2026. |
| Database size | 500 MB per project | Supabase’s documented allowance, accessed October 7, 2026. |
| Egress | 5 GB | Supabase’s documented allowance, accessed October 7, 2026. |
| Storage | 1 GB | Supabase’s documented allowance, accessed October 7, 2026. |
Supabase says low-activity Free Plan projects may be paused. Its production checklist also says downloadable database backups are not available for Free Plan projects. Those constraints matter if you rely on the database for an application or important data: plan for a backup method and service availability appropriate to your use, rather than treating a starter project as a production guarantee.
Quick Recap
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.
