Databases Agent Skills for Zed

Teaches SQLite development including WAL mode, FTS5 full-text search, JSON1 queries, and async Python integration with aiosqlite.

This skill should be used when the user asks to "analyze data with SQLite", "query logs", "find patterns in test results", or "correlate…

SQLite across every host and engine - query performance, concurrency, schema, feature modules, operations.

SQLite performance optimization techniques

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\