Skill UI

Enables Claude to examine EXPLAIN plans, spot slow queries or missing indexes, and deliver concrete optimization steps—ideal for improving database query speed and resource usage when performance issues arise.

Guides ClickHouse database architects through schema designs, query optimization, ingestion strategies, and monitoring techniques tailored for high-performance analytical workloads.

Provides a practical checklist and principles for designing database schemas, indexing strategies, query optimization, and migration planning for both SQL and NoSQL systems, plus guidance on spotting and fixing N+1 issues and denormalization trade-offs.

Guides tuning Databricks clusters, Spark settings, and Delta Lake tables so teams can speed slow jobs, balance workloads, and improve query responsiveness through sizing, config, and storage optimizations.

Streamlines Guidewire InsuranceSuite performance by guiding query optimization, batching, caching, and JVM tuning; ideal for slow queries, PolicyCenter bottlenecks, and establishing metrics-driven checklists.

Implements multi-tier database caching using Redis, in-memory stores, and CDN integration to reduce load, lower query latency, and support scalable cache-aside, write-through, or read-through workflows when users ask for caching optimizations.

Analyzes SQL statements, identifies bottlenecks, suggests indexes and rewrites, and leverages the sql-query-optimizer plugin so you can improve database responsiveness when queries run slowly.

A comprehensive resource providing best practices for PostgreSQL performance optimization, schema design, and security configuration. Developed by Supabase, it covers critical areas like query performance, connection management, and Row-Level Security. Use this skill when writing complex SQL queries, reviewing schema integrity, or diagnosing database bottlenecks to ensure high performance and stability.

Provides PostgreSQL optimization advice covering index design, query plan inspection, partitioning, JSONB tweaks, connection pooling, and tuning checkpoints to stabilize OLTP workloads.

Provides Prisma ORM expertise for schema design, migrations, relations modeling, and query optimization plus database operations across PostgreSQL, MySQL, and SQLite in Node.js projects.

Orchestrates a multi-phase schema optimization workflow that launches sequential phase agents to analyze data, validate JSON artifacts, and aggregate BigQuery-oriented reports and recommendations.

This skill provides systematic patterns and best practices for transforming slow database queries into lightning-fast operations. It covers advanced topics such as proper indexing strategies, detailed query plan analysis (EXPLAIN), resolving common issues like N+1 problems, and designing highly performant database schemas. Use this when debugging performance bottlenecks, improving application response times, or ensuring scalability for growing datasets.