Validates data migrations, backfills, and production data transformations against reality.
Produces Go/No-Go deployment checklists with SQL verification queries, rollback procedures, and monitoring plans.
Design a PostgreSQL-specific schema. Covers best-practices, data types, indexing, constraints, performance patterns, and advanced features
Master SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow…
ClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads.
Build production-grade Azure Cosmos DB NoSQL services following clean code, security best practices, and TDD principles.
Use when the user asks to create ERD diagrams, normalize database schemas, design table relationships, or plan schema migrations.
Django performance code review. Use when asked to "review Django performance", "find N+1 queries", "optimize Django", "check queryset…
JPA/Hibernate patterns for entity design, relationships, query optimization, transactions, auditing, indexing, pagination, and pooling in…
MUST use when writing MySQL queries.
Authors n8n database migrations. Use when creating or modifying files under packages/@n8n/db/src/migrations/, when the user asks to add a…
Design a PostgreSQL-specific schema. Covers best-practices, data types, indexing, constraints, performance patterns, and advanced features
Universal SQL code review assistant that performs comprehensive security, maintainability, and code quality analysis across all SQL…
Transform slow database queries into lightning-fast operations through systematic optimization, proper indexing, and query plan analysis.
Master modern SQL with cloud-native databases, OLTP/OLAP optimization, and advanced query techniques.
Use when the user needs to filter data — whether in a structured query, a metric aggregation, or an attribute expression.
Guides Qdrant search strategy selection.
Use this skill to implement hybrid search combining BM25 keyword search with semantic vector search using Reciprocal Rank Fusion (RRF)…
PostgreSQL schema design, query optimization, indexing, and administration.
Database schema patterns for InsForge including social graphs, e-commerce, content publishing, and multi-tenancy with RLS policies.
Use when targeting International Conference on Very Large Data Bases (VLDB) or deciding whether a computer-science manuscript fits this…