Databases Agent Skills

Design and operate PostgreSQL databases: schema design, indexing, query optimization, transactions, and migrations.

Integration patterns for Next.js + Tailwind CSS + Prisma + Auth.js — the seams between frameworks

Integration seams for Next.js App Router + Supabase: dual-client auth (browser/server), middleware token refresh, RLS policies, typed…

Use when working with the Stacks CLI (buddy/bud/stacks/stx) — understanding all 50+ commands with their flags and options, adding custom…

Choose the right database technology for specific workloads.

Use when you need to generate, validate, or deploy stored procedures

Use when doing ANY task involving Supabase.

Use when choosing how to integrate Supabase into a specific stack — setting up Next.js SSR auth flows, wiring an SPA or React Native…

Implement Supabase Auth (signUp, signIn, OAuth, session management),

Automate Supabase database queries, table management, project administration, storage, edge functions, and SQL execution via Rube MCP…

Implement GDPR/CCPA compliance with Supabase: RLS for data isolation, user deletion via auth.admin.deleteUser(), data export via SQL, PII…

Implement custom role-based access control via JWT claims in Supabase: app_metadata.role, RLS policies with auth.jwt() role extraction…

Run your first Supabase query \u2014 insert a row and read it back.\n\

Use when reviewing Supabase code, onboarding developers, auditing an existing project, or debugging unexpected behavior — catches the…

Configure Supabase local development with the CLI, Docker, and migration

Postgres performance optimization and best practices from Supabase.

Manage Supabase rate limits and quotas across all plan tiers.

Subscribe to realtime changes in Supabase using WebSocket connections.

Implement enterprise Supabase reference architectures \u2014 monorepo\

Fix Supabase RLS issues - handles missing user context, system processes, background jobs, and provides standardized RLS templates

Use when doing ANY task involving Supabase.