Supabase Cheat Sheet

Updated 2026-04-29

Supabase is an open-source Backend-as-a-Service (BaaS) platform built on PostgreSQL, providing instant APIs, authentication, real-time subscriptions, storage, and serverless functions. It combines a full PostgreSQL database with modern BaaS features, offering a developer-friendly alternative to Firebase with the flexibility of SQL. The platform auto-generates RESTful and GraphQL APIs via PostgREST and pg_graphql, supports Row Level Security for granular access control, and provides a complete ecosystem — including Edge Functions, queues, branching, and an MCP server — for building production-ready applications. As of 2026, tables in the public schema are no longer exposed to the Data API by default; explicit GRANT statements are required for new tables.

What This Cheat Sheet Covers

This topic spans 23 focused tables and 196 indexed concepts. Below is a complete table-by-table outline of this topic, spanning foundational concepts through advanced details.

Table 1: Database OperationsTable 2: Query FiltersTable 3: Query ModifiersTable 4: Relationships and JoinsTable 5: Authentication MethodsTable 6: Row Level Security (RLS)Table 7: Storage OperationsTable 8: Storage BucketsTable 9: Realtime FeaturesTable 10: Edge FunctionsTable 11: TypeScript Type GenerationTable 12: Database ExtensionsTable 13: CLI CommandsTable 14: Database Functions and TriggersTable 15: Database ViewsTable 16: Connection ManagementTable 17: Backup and RecoveryTable 18: Auth HooksTable 19: Error HandlingTable 20: Supabase Queues (pgmq)Table 21: Database TestingTable 22: Platform FeaturesTable 23: Advanced Patterns

Table 1: Database Operations

Method	Example	Description
select	`await supabase.from('users').select('*')`	• Fetches rows from a table • use `.select('col1, col2')` for specific columns.
insert	`await supabase.from('users').insert({ name: 'John', email: 'j@x.com' })`	• Inserts one or more rows • accepts single object or array • chain `.select()` to return inserted data.
update	`await supabase.from('users').update({ name: 'Jane' }).eq('id', 5)`	• Modifies existing rows • requires a filter to avoid updating all rows.

Table 1: Database Operations

Method	Example	Description
select	`await supabase.from('users').select('*')`	• Fetches rows from a table • use `.select('col1, col2')` for specific columns.
insert	`await supabase.from('users').insert({ name: 'John', email: 'j@x.com' })`	• Inserts one or more rows • accepts single object or array • chain `.select()` to return inserted data.
update	`await supabase.from('users').update({ name: 'Jane' }).eq('id', 5)`	• Modifies existing rows • requires a filter to avoid updating all rows.