Prev Next

Database / Supabase basics Interview Questions

Explain the lifecycle of a Supabase Auth session token?

When a user signs in, Supabase Auth issues two tokens: a short-lived access token (a JWT, typically valid for about an hour) that's sent with every API request to prove identity, and a longer-lived refresh token that's used only to obtain a new access token once the current one expires.

The access token's claims (including the user's ID as sub, which becomes auth.uid() inside RLS policies) are self-contained and verifiable without a database round trip, which is why PostgREST can check them cheaply on every request. When the access token nears expiry, the client SDK automatically calls the token refresh endpoint with the refresh token, and if that refresh token is still valid and hasn't been revoked, Auth issues a new access/refresh token pair — refresh tokens are typically single-use and rotated on each refresh, so a stolen but already-used refresh token becomes worthless.

Sign-out invalidates the current session's refresh token server-side, which prevents further refreshes, though any access token issued before sign-out remains technically valid (and usable) until its own short expiry passes, since it's a self-contained JWT rather than something checked against a live session table on every request.

What is the purpose of the refresh token in this lifecycle?
Why can an already-issued access token remain technically valid briefly even after sign-out?

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

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

Earn passively and while sleeping

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.

Robinhood Logo

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 Logo

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

More Related questions...

What is Supabase? What is the purpose of PostgreSQL within Supabase? What are the core services offered by Supabase? What is Supabase Authentication used for? What are the types of storage available in Supabase Storage? Define Row Level Security in Supabase? Describe the Supabase client library? What is the purpose of Supabase Edge Functions? List the API types Supabase auto-generates from your schema? How do you create a new Supabase project and connect to it? How does Supabase auto-generate REST APIs from a database schema? Why is Row Level Security important in a client-facing Supabase app? How does Supabase Realtime broadcast database changes to clients? What is the difference between the anon key and the service role key in Supabase? When should you use an Edge Function instead of a Postgres database function? How do you troubleshoot a valid query being blocked by Row Level Security? What is the difference between using Supabase Auth and rolling your own JWT-based authentication? How is data validated before insertion in a Supabase table? Why do we use database migrations in Supabase projects? What happens when a Postgres trigger fires on a table linked to Edge Function webhooks? Explain the execution flow of a request through Supabase's auto-generated API? Why doesn't Supabase recommend using the service_role key on the client? How can you optimize Postgres connection pooling for serverless Edge Functions? Explain the internal working of Row Level Security policy evaluation in Postgres? What is the difference between pgvector similarity search and hybrid search in Supabase? Which is better for real-time collaboration, Supabase Realtime or client-side polling, and why? How does Supabase handle connection pooling for high-concurrency workloads? Explain the lifecycle of a Supabase Auth session token? When would you choose self-hosting Supabase over the managed cloud offering? How do you optimize full-text search performance on a large Postgres table in Supabase?
Show more question and Answers...

Supabase Intermediate to Advanced Interview Questions

Comments & Discussions