supabase-database
Installation
SKILL.md
Supabase Database Skill
Database operations, queries, and Row Level Security.
Quick Reference
| Operation | JavaScript | SQL |
|---|---|---|
| Select all | supabase.from('table').select('*') |
SELECT * FROM table |
| Select columns | supabase.from('table').select('col1,col2') |
SELECT col1, col2 FROM table |
| Filter | .eq('col', 'value') |
WHERE col = 'value' |
| Insert | .insert({ col: 'value' }) |
INSERT INTO table (col) VALUES ('value') |
| Update | .update({ col: 'value' }).eq('id', 1) |
UPDATE table SET col = 'value' WHERE id = 1 |
| Delete | .delete().eq('id', 1) |
DELETE FROM table WHERE id = 1 |