Query and index Couchbase 8 data with N1QL and GSI design.
npx skills add https://github.com/frocentus/domcouch --skill couchbase8
Please help me install this Agent Skill. Skill: couchbase8 Source: https://github.com/frocentus/domcouch/tree/main/.skills/couchbase8 Command: npx skills add https://github.com/frocentus/domcouch --skill couchbase8
In domcouch, developing against Couchbase 8 can be challenging due to advanced N1QL patterns, index design, and consistency behavior. This skill provides consolidated guidance to clarify these topics and streamline development.
Run the included N1QL samples and EXPLAIN plans against your domcouch instance to validate indexing and query performance.
High-intent search queries and answers about installing and using this skill.
To optimize N1QL queries for pagination and nested fields in Couchbase 8, apply specific patterns for filtering and use Global Secondary Index (GSI) design with EXPLAIN analysis to ensure page-friendly query execution.
The best way to design GSI indexes for Couchbase collections is following collection rules to organize data safely, utilizing EXPLAIN plans to validate indexing, and ensuring queries avoid full scans by leveraging key-based pagination.
Eventual consistency in Couchbase 8 means query results might not immediately reflect the latest writes. You handle this by benchmarking consistency behavior and validating query performance across development, test, and production environments.
You benchmark query performance by running N1QL samples and EXPLAIN plans against your Couchbase instance, comparing full scans versus key-based pagination strategies to validate indexing improvements and ensure efficient document retrieval.
To retrieve 200 documents efficiently, use a suitable Global Secondary Index (GSI) combined with N1QL patterns for key-based pagination, validating the query route and performance through EXPLAIN analysis to avoid full collection scans.
celticht32Design and troubleshoot Couchbase Eventing functions for document-driven workflows.
panaversityValidate a Skill Unit against nine quality criteria and generate a structured report.
travisjneumanGuide feature development with architecture patterns and decision frameworks.
Harmeet10000Analyzes SQL slow queries and recommends indexing and rewrite strategies.
