Databases Agent Skills for VS Code

When to activate: SQLite, WAL, FTS5, JSON1, pragma, in-memory database, embedded, WASM, SQLite3

Use when working with SQLMesh — writing or editing MODEL blocks, Python @model decorators, Python @macros, audits, unit tests…

SQLx changes since training cutoff (latest: 0.9.0-alpha.1) — SqlSafeStr, owned Arguments, sqlx.toml config, begin_with transactions…

Guide SSOT implementation work after scope freeze, including schema changes, code changes, schema version advancement, migration updates…

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.