Design and use Couchbase Capella Analytics (formerly Capella Columnar), the standalone columnar analytics database service on Capella. Use whenever the user asks about Capella Analytics, Capella Columnar, columnar analytics, an Analytics instance, Capella Analytics vs the operational Analytics Service, Analytics collections, links to operational data, Analytics SQL++, pricing, when to use standalone Capella Analytics vs the embedded Analytics Service, or 'I need to run analytical queries on my Couchbase data.' Distinct from the cb-analytics-* skills (which cover the Couchbase Analytics Service embedded in Couchbase Server / Capella operational clusters) — Capella Analytics is a separate, standalone columnar database product on Capella. Use proactively when the user needs OLAP-scale analytics, BI tool integration, or columnar storage for analytical workloads.
Design and use Couchbase Capella Analytics (formerly Capella Columnar), the standalone columnar analytics database service on Capella. Use whenever the user asks about Capella Analytics, Capella Columnar, columnar analytics, an Analytics instance, Capella Analytics vs the operational Analytics Service, Analytics collections, links to operational data, Analytics SQL++, pricing, when to use standalone Capella Analytics vs the embedded Analytics Service, or 'I need to run analytical queries on my Couchbase data.' Distinct from the cb-analytics-* skills (which cover the Couchbase Analytics Service embedded in Couchbase Server / Capella operational clusters) — Capella Analytics is a separate, standalone columnar database product on Capella. Use proactively when the user needs OLAP-scale analytics, BI tool integration, or columnar storage for analytical workloads.
license
MIT
Couchbase Capella Analytics
A skill for designing and using Couchbase Capella Analytics — the standalone columnar analytics database product on Capella.
Naming: Couchbase formally rebranded Capella Columnar to Capella Analytics. This skill uses "Capella Analytics" for the product. The lowercase word "columnar" still appears where it describes the underlying storage format (columnar storage), and some API/endpoint names retain "Columnar" (e.g. Columnar Analytics Cluster) — those are left as-is where they are literal identifiers.
Distinct from the cb-analytics-* skills, which cover the Analytics Service embedded within Couchbase Server / Capella operational clusters. These are different products:
Analytics Service (embedded)
Capella Analytics (standalone)
What it is
Analytics service co-located with an operational cluster
Standalone columnar database, separate instance
Where it runs
On Analytics nodes of an operational cluster
Separate Capella Analytics instance on Capella
Data ingestion
DCP-based streaming from the operational cluster
Links to Capella operational cluster, S3, or external sources
Storage
Row-oriented (same as operational)
True columnar storage
Best for
Ad-hoc analytics alongside operational workloads
OLAP, BI tools, large analytical queries
Skills
cb-analytics-*
This skill
When this skill applies
"What's Capella Analytics (Capella Columnar)?"
"Should I use standalone Capella Analytics or the embedded Analytics Service?"
"How do I connect Capella Analytics to my operational Capella cluster?"
"How do I connect a BI tool (Tableau, Power BI, Looker) to Couchbase?"
"How do I query JSON data in Capella Analytics?"
"What's the difference between Analytics collections and operational collections?"
Pick the right reference
Question
Read
"Capella Analytics architecture, when to use it vs the embedded Analytics Service"
references/architecture.md
"Connecting data sources, querying, BI tool integration"
references/usage.md
Core principle: Capella Analytics is for OLAP, not OLTP
Capella Analytics is optimized for analytical queries — large scans, aggregations, GROUP BY, window functions, JOINs across large datasets. It is not a replacement for the operational cluster. Transactional writes (your application's reads/writes) still go to the operational cluster. Capella Analytics receives data via links and stores it in columnar format for efficient analytical access.
Related skills
cb-analytics-* — the Analytics Service embedded in operational clusters (different product)
couchbase-capella — provisioning the operational Capella cluster that Capella Analytics links to
couchbase-sqlpp-tuning — SQL++ query patterns apply to Capella Analytics with minor differences
