couchbase-sqlpp-tuninglisted

Diagnose and tune slow Couchbase SQL++ / N1QL queries. Use whenever the user asks about query performance, slow queries, EXPLAIN plans, why an index isn't being used, IntersectScan, PrimaryScan, covering indexes, partial indexes, array indexes (ANY / EVERY / UNNEST), index selection, query hints, the cost-based optimizer, the Index Advisor (ADVISE), system:completed_requests, query profiling (kernTime / servTime / execTime), pagination performance, prepared statements, or 'this query is slow / how do I make it faster.' Distinct from couchbase-data-modeling (document shape) and couchbase-mcp (operating the cluster) — this skill is about reading plans, designing the right indexes, and reshaping queries that already exist. Use proactively when the user shares an EXPLAIN output or a slow query.
celticht32/Couchbase-Skills-for-Claude.ai · ★ 1 · AI & Automation · score 75

Install: claude install-skill celticht32/Couchbase-Skills-for-Claude.ai

# Couchbase SQL++ tuning A skill for diagnosing and fixing slow SQL++ / N1QL queries on Couchbase Server (7.x and 8.x). The mechanics of reading execution plans, choosing the right index type, fixing common anti-patterns, and wiring up the diagnostic tools. Distinct from the sibling skills: - `couchbase-data-modeling` — how to MODEL the data (document shape, boundaries, access patterns) - `couchbase-sizing` — how to size the cluster - `couchbase-app-integration` — how to write app code that uses Couchbase - `couchbase-migration-execution` — how to move data INTO Couchbase - `couchbase-mcp` — operating the cluster (the MCP server's `cb_explain_query`, `cb_index_advisor`, `cb_perf_*` tools) - **`couchbase-sqlpp-tuning` (this skill)** — making queries that already exist run faster If the conversation is "this query is slow, what do I do," this is the right skill. ## When this skill applies - "Why is this query slow?" - "How do I read this EXPLAIN plan?" - "Why isn't my index being used?" - "I'm seeing PrimaryScan / IntersectScan — is that bad?" - "How do I make this a covering index?" - "Should I use a partial index here?" - "How do I index an array field with ANY / EVERY / UNNEST?" - "ADVISE recommended this index — should I create it?" - "How do I tune pagination — LIMIT / OFFSET is slow at high offsets" - "What does kernTime / servTime / execTime mean in the profile?" - "Can I force the optimizer to use a specific index?" - "What do the cost-based optimizer hints do in 7