Reviews SQLAlchemy code for session management, relationships, N+1 queries, and migration patterns.
Comprehensive SQLAlchemy skill for customer support tech enablement, covering ORM patterns, session management, query optimization, async…
Use when working with SQLiteData library (@Table, @FetchAll, @FetchOne macros) for SQLite persistence, queries, writes, migrations, or…
General guide for using the sqlite3 CLI to build composable knowledge databases.
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),