This skill optimizes database connection pooling for enhanced performance and resource management.
This skill analyzes and optimizes SQL queries for improved performance.
Reviews Spring Data JPA for N+1 queries, fetch strategies, projections, and Specifications.
Run Supabase Management API SQL for persistent data tasks such as querying records, applying schema changes, managing policies, and…
Build a data pipeline — ETL/ELT with extraction, transformation, loading, error handling, and scheduling.
Build zero-downtime database migrations — forward SQL, rollback SQL, deployment sequence.
Configure Snowflake enterprise RBAC with system roles, custom role hierarchies, SSO/SCIM integration, and least-privilege access patterns.
Install and configure Supabase SDK, CLI, and project authentication.
Build with D1 serverless SQLite database on Cloudflare's edge.
Build type-safe D1 databases with Drizzle ORM for Cloudflare Workers.
Set up serverless Postgres with Neon or Vercel Postgres for Cloudflare Workers/Edge.
ClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads.
Database migration best practices for schema changes, data migrations, rollbacks, and zero-downtime deployments across PostgreSQL, MySQL…
JPA/Hibernate patterns for entity design, relationships, query optimization, transactions, auditing, indexing, pagination, and pooling in…
JetBrains Exposed ORM patterns including DSL queries, DAO pattern, transactions, HikariCP connection pooling, Flyway migrations, and…
Creates JPA entities following best practices.
JPA/Hibernate patterns and common pitfalls (N+1, lazy loading, transactions, queries).
Airtable REST API via curl. Records CRUD, filters, upserts.
Safely migrate Convex schemas and data when making breaking changes.
Manage Supabase local and hosted infrastructure.
This skill should be used when the user asks "why is deep pagination slow", "how do I replace OFFSET", "how do I build a cursor-based…