Get a free PostgreSQL environment with Supabase#
When you want to use a free relational database in the cloud, Supabase is one of the most promising options. This article summarizes the basic points to quickly and safely start using a free PostgreSQL environment using Supabase.
Introduction#
Supabase is an open source BaaS (Backend as a Service) that aims to replace Firebase, and has a configuration centered on PostgreSQL. The following points are particularly attractive:
Free plan that can be used forever
Can be treated as a standard RDB based on PostgreSQL
REST/GraphQL API is also automatically generated
Equipped with GUI and SQL editor, ideal for learning
Free plan limitations/restrictions#
The Supabase Free Tier has the following limitations:
Number of projects: maximum 2
Storage capacity: up to 500MB
Number of requests: 500,000 per month, with daily limits
The project may be automatically stopped if there is no access for more than 3 months.
Performance is limited (I/O and CPU)
However, it is still good enough for learning purposes and small projects.
How to connect to PostgreSQL#
After creating a Supabase project, you can easily check the following information using the Connect button at the top of the screen:
Host name (e.g. db.abcdef.supabase.co)
Port number (usually 5432)
Username and password
Connection string (Postgres URI)
This URI can be used as is with psycopg and SQLAlchemy.
Force SSL connection#
To ensure secure connections, Supabase uses SSL by default. In addition, from Configuration > SSL Configuration in the dashboard, you can turn on Enforce SSL to completely reject non-SSL connections.
This prevents the risk of unintended plaintext communication and man-in-the-middle attacks.
summary#
Using Supabase, you can set up a free PostgreSQL environment on the cloud in just a few minutes, and it’s extremely easy as it has a well-equipped GUI and API. Cloud RDBs that can be used for free to this extent are rare and are ideal for learning and prototyping purposes.
It is also equipped with security features such as forced SSL settings, making it a configuration that can be used with peace of mind. Please take advantage of it.
Article information
- author:
Mr. Takagi
- Post date:
2025-05-21