Use when writing BigQuery queries, optimizing query performance, analyzing execution plans, or avoiding common SQL gotchas. Covers parameterized queries, UDFs, scripting, window functions (QUALIFY, ROW_NUMBER, RANK, LEAD/LAG), JSON functions, ARRAY/STRUCT operations, BigQuery-specific features (EXCEPT, REPLACE, SAFE_*), CTE re-execution issues, NOT IN with NULLs, DML performance, Standard vs Legacy SQL, and performance best practices.
JOOQ type-safe SQL patterns - use for database queries, repositories, complex SQL operations, and PostgreSQL-specific features
PostgreSQL query optimization, JSONB operations, advanced indexing strategies, partitioning, connection management, and database administration. Use this skill for PostgreSQL-specific optimizations, performance tuning, replication setup, and PgBouncer configuration.
SQL query optimization, schema design, indexing strategies, and relational database mastery for production data systems
Write type-safe Kysely queries following project patterns. Use when writing new database queries, optimizing queries, or working with the @packages/db/src/queries/* files.
Prisma/SQL 마이그레이션 관리. Use when: (1) 스키마 변경, (2) 마이그레이션 생성/적용, (3) DB 동기화, (4) 마이그레이션 상태 확인, (5) 롤백 필요 시.
Show details about a specific database. Requires authentication. Use for Agentuity cloud platform operations
Get query logs for a specific database. Requires authentication. Use for Agentuity cloud platform operations
Generate SQL schema for Agentuity Auth tables. Use for managing authentication credentials
Drizzle ORM best practices including schema design with relationships, database migrations, prepared statements for performance, transactions, indexes, Turso SQLite database operations, type safety patterns, query optimization, and database workflow for ree-board project
Detects N+1 queries, suggests eager loading, and recommends database indexes
Master Redis transactions - MULTI/EXEC, WATCH for optimistic locking, Lua scripting, and atomic operation patterns
Generate production-ready Row Level Security (RLS) policies for Supabase tables with is_super_admin() bypass, proper USING/WITH CHECK, automated testing framework, performance analysis, and coverage reports. Use when creating RLS policies, securing tables, testing access controls, analyzing policy performance, or auditing RLS coverage.
Use when creating Room entities for Kotlin/Android apps that mirror Django/PostgreSQL backend schemas. Enforces exact field alignment, prevents schema drift, validates type mappings. Critical for maintaining zero impedance mismatch between backend and mobile.
Apply when implementing multi-tenant data isolation, user-specific data access, or any scenario requiring row-level authorization in Supabase.
Master PostgreSQL SQL fundamentals - data types, tables, constraints, schema design
Implement database queries, repositories, and use cases following the project's layered architecture with Prisma ORM. Use this skill when creating or modifying repository classes (*.repository.ts) in shared/repository/, use case classes (*.use-case.ts) in features/{feature}/use-case/, query classes (*.query.ts) for read operations, or working with Prisma transactions and query builders. This includes implementing CRUD operations, transaction handling with prisma.$transaction(), eager loading with include/select, soft delete patterns (deletedAt filtering), and optimizing database queries. Apply when using PrismaService, Prisma.TransactionClient, or building complex database queries with proper indexing considerations.
Work with JSONB data - queries, indexing, transformations
PostgreSQL administration and setup including installation, configuration, backup/recovery, replication, and high-availability. Learn production PostgreSQL operations.
Database transactions, ACID properties, and concurrency control
Comprehensive PostgreSQL-specific table design reference covering data types, indexing, constraints, performance patterns, and advanced features
