How does Supabase auto-generate REST APIs from a database schema?

Supabase runs PostgREST, a standalone server that introspects your Postgres schema at startup and turns every table, view, and stored procedure into a REST resource on the fly — there's no code generation step or API definition file to maintain.

A table named posts with columns id, title, and published automatically becomes queryable at /rest/v1/posts, and query string parameters map directly to SQL: ?published=eq.true&order=id.desc becomes a WHERE clause and ORDER BY. Because PostgREST talks to Postgres as the authenticated user's role, Row Level Security is applied automatically on every generated endpoint, so the API layer never becomes a way to bypass your data access rules.

Invest now in Acorns!!! 🚀
Join Acorns and get your $5 bonus!

Acorns is a micro-investing app that automatically invests your "spare change" from daily purchases into diversified, expert-built portfolios of ETFs. It is designed for beginners, allowing you to start investing with as little as $5. The service automates saving and investing. Disclosure: I may receive a referral bonus.

Invest now!!! Get Free equity stock (US, UK only)!

Use Robinhood app to invest in stocks. It is safe and secure. Use the Referral link to claim your free stock when you sign up!.

The Robinhood app makes it easy to trade stocks, crypto and more.

Webull! Receive free stock by signing up using the link: Webull signup.