Every project is a full Postgres database you own: create tables, write SQL, enable extensions and connect from any tool over TLS.
Tables and SQL
The Table Editor and the SQL Editor.
Row Level Security
Decide which rows each request may read or change.
Connect to Postgres
Connection host, ports, TLS and pooling.
Use extensions
vector, postgis, pg_trgm and 50 more.
Cron jobs
Run SQL on a schedule with pg_cron.
Queues
Message queues with pgmq.
HTTP from SQL
Webhooks and API calls with pg_net.
Webhooks
Row changes and Auth events to your endpoint, signed and retried.
Read replicas
Read-only copies near your users.
Backups
Daily backups, point-in-time recovery, download and restore.
Safe schema changes
Lock warnings and safer migrations for busy tables.
Advisors
Security and performance checks with fixes.
#What you can do
- Full SQL: tables, views, functions, triggers, indexes and transactions.
- Extensions:
vector,postgis,pg_cron,pgmq,pg_net,pg_graphql,pg_trgm,citext,hstore,ltree,unaccent,fuzzystrmatch,btree_gist,pg_stat_statements,pgcryptoanduuid-osspand many more. - Pooled connections over TLS on ports 5432 (session) and 6543 (transaction).
- Studio: Table Editor, SQL Editor, database objects, policies and advisors in your browser.