Optimization guidelines for Order/Product schema. Covers normalization, data types, relationships, and indexing strategies.
Use this when changing the database schema, generating/applying Drizzle migrations for Cloudflare D1 (SQLite), or working with Better Auth schema generation.
Optimización PostgreSQL para la DB de Huevos Point (Neon serverless). Índices existentes en sales(tenant_id, sale_date), expenses(tenant_id, expense_date). Usar para revisar queries del Dashboard Maestro, validar uso de índices, optimizar agregaciones de métricas diarias y verificar que las queries cross-tenant usen los índices compuestos correctamente.
05번 DB Management Agent의 DB 감사 체크리스트를 실행합니다. Firebase RTDB 경로 일관성, Supabase RLS 커버리지, 심볼 키 정규화, DB 보안 감사를 수행합니다.
JSON Schema 準拠の YAML 設計書を生成・更新する手順とスキーマ参照。implementer / designer / architect Agent が設計書の作成・更新時に使う。
Design database schemas, create tables, manage migrations, and optimize database structures. Use for relational and non-relational database implementations.
Standardize Drizzle schema/migration/seed workflow for Viet K-Connect. Use when adding or changing DB tables, especially DB-driven visa rulesets and document templates (no hardcoding). (키워드= 드리즐, DB 스키마, 마이그레이션, seed, schema.ts, migrations)
Build the regulation/knowledge update pipeline (official sources -> snapshots -> structured rulesets/templates -> admin approval -> active). Use for keeping visa rules and document requirements up-to-date without code hardcoding. (키워드= 규정 최신화, 공식 정보, 스냅샷, 검수/승인, 룰셋/템플릿 업데이트)
Design and implement the Viet K-Connect visa assessment engine (DB-driven ruleset JSON schema + versioning + effective dates). No hardcoded rules in code. Use for building /api/visa/assess and admin ruleset management. (키워드= 비자 평가, 룰셋, 규칙 엔진, DB-driven, 버전/적용일, /api/visa/assess)
Expert patterns for Neon serverless Postgres, branching, connection pooling, and Prisma/Drizzle integration Use when: neon database, serverless postgres, database branching, neon postgres, postgres...
Expert guidance for distributed NoSQL databases (Cassandra, DynamoDB). Focuses on mental models, query-first modeling, single-table design, and avoiding hot partitions in high-scale systems.
Master SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow queries. Use when debugging slow queries, designing database...
Expert in vector databases, embedding strategies, and semantic search implementation. Masters Pinecone, Weaviate, Qdrant, Milvus, and pgvector for RAG applications, recommendation systems, and similar
PostgreSQL database patterns for query optimization, schema design, indexing, and security. Based on Supabase best practices.
Guides and best practices for working with Neon Serverless Postgres. Covers getting started, local development with Neon, choosing a connection method, Neon features, authentication (@neondatabase/...
Optimize vector index performance for latency, recall, and memory. Use when tuning HNSW parameters, selecting quantization strategies, or scaling vector search infrastructure.
Master modern SQL with cloud-native databases, OLTP/OLAP optimization, and advanced query techniques. Expert in performance tuning, data modeling, and hybrid analytical systems. Use PROACTIVELY for database optimization or complex analysis.
Safely bumps contract schema versions following compatibility rules and updates related metadata.
Plans and executes safe Convex schema/data migrations for this repo using a widen-migrate-narrow rollout. Use when schema deploy fails, existing documents need backfills, or fields must be added/removed/reshaped without downtime.
Comprehensive PocketBase database management skill. Use this skill when the user wants to interact with a PocketBase instance to manage collections, records, users, or perform database backups. It provides a Python client script to execute these operations.
Build, refactor, or integrate a three-panel SQL demo that uses a real C engine behind a web UI. Use when working on projects that must connect `CLI input -> parse tree -> service view`, keep frontend/backend/engine responsibilities separated, and preserve the rule that the browser does not fake SQL execution.
Expert database design and data modeling. Use when designing schemas, normalizing data, creating ER diagrams, or making architectural database decisions.
Execute SQL against staging or production databases using the repo helper. Production writes require explicit confirmation.
Expert in creating database diagrams and visual representations. Use when generating ERDs, schema diagrams, or visualizing database relationships with Mermaid.js.
Unity Catalog system tables and volumes. Use when querying system tables (audit, lineage, billing) or working with volume file operations (upload, download, list files in /Volumes/).
Patterns and best practices for using Lakebase Provisioned (Databricks managed PostgreSQL) for OLTP workloads.
Patterns and best practices for using Lakebase Autoscaling (next-gen managed PostgreSQL) with autoscaling, branching, scale-to-zero, and instant restore.
Fix silent migration failure where d9 bootstrap registers 20250910A but fails to create session_id columns, causing 500 on login.
Supabase database management for Maistro.mx marketplace. Use when working with the Maistro database, creating migrations, designing schemas, optimizing queries, or implementing RLS policies. All tables use the 'maistro_' prefix in the shared Supabase project.
Use when designing, reviewing, or applying PostgreSQL schema changes for auth or core data in corapan-webapp.