supabase-database
Supabase Database
Quick Start
When working with Supabase:
- Always use Supabase client from
@/lib/supabase/serveror@/lib/supabase/client - Never make queries without filtering by
tenant_idin multitenant tables - Always enable RLS on tables and include tenant verification in policies
- Use prepared parameters (Supabase client methods, never string concatenation)
- Use migrations in
supabase/migrations/for schema changes
Key Files
src/lib/supabase/- Supabase client utilitiessrc/lib/integrations/supabase/- Supabase integrationsupabase/migrations/- Database migrationssupabase/functions/- Edge functionssrc/lib/auth/enterprise-rls-utils.ts- RLS utilities
More from santiagoxor/pintureria-digital
checkout-payments
Specialized skill for working with checkout and payment systems including MercadoPago integration, order management, address validation, and checkout flow. Use when implementing checkout improvements, integrating payment methods, debugging payment issues, or optimizing checkout process.
63authentication
Specialized skill for working with NextAuth.js authentication including session management, JWT tokens, role-based access control, and protected routes. Use when implementing authentication features, securing routes, managing user sessions, or debugging auth issues.
34postgres-best-practices
Postgres performance optimization guidelines from Supabase. Contains rules across 8 categories prioritized by impact. Use when writing SQL queries, designing schemas, implementing indexes, optimizing queries, reviewing database performance, configuring connection pooling, or working with Row-Level Security (RLS).
29testing-qa
Specialized skill for writing and maintaining tests including unit tests, integration tests, E2E tests with Playwright, and accessibility tests. Use when writing tests for new features, debugging failed tests, improving test coverage, or setting up E2E tests.
18error-handling
Specialized skill for implementing proper error handling, logging, user-friendly error messages, and error recovery strategies. Use when implementing error handling in APIs, components, or when debugging error issues.
17lighthouse-audit
Specialized skill for running Lighthouse audits, analyzing Core Web Vitals, identifying performance opportunities, and generating performance reports. Use when auditing performance, analyzing Lighthouse metrics, optimizing Core Web Vitals, or generating performance reports.
17