Basic CRUD Operations in Supabase
From the Supabase cheat sheet · Database Operations · verified Jul 2026
Basic CRUD Operations
Create, Read, Update, Delete operations
typescript
// SELECT - Get data
const { data, error } = await supabase
.from('posts')
.select('*')
// INSERT - Create record
const { data, error } = await supabase
.from('posts')
.insert({ title: 'Hello', content: 'World' })
// UPDATE - Modify record
const { data, error } = await supabase
.from('posts')
.update({ title: 'Updated' })
.eq('id', 1)
// DELETE - Remove record
const { error } = await supabase
.from('posts')
.delete()
.eq('id', 1)📊 Automatic REST APIs from PostgreSQL
🔄 Chainable query methods
✅ Always check for errors
⚡ .select() returns inserted/updated data