What features does Couchbase MCP server provide?

Q: What features does Couchbase MCP server provide?

List all buckets in the cluster: Returns a list of all buckets currently defined in the connected Couchbase cluster.. List all scopes and collections in a bucket: Provides the scopes and their collections for a given bucket.. List all scopes in a bucket: Return all scopes within the specified bucket.. List collections in a scope and bucket: List all collections within a given scope and bucket; requires the cluster to have the Query service.. Get collection structure: Get the structure for a collection.. Document CRUD operations: Get a document by ID, upsert a document by ID, and delete a document by ID from a specified scope and collection.. SQL++ query execution with read-only mode: Run a SQL++ query scoped to the bucket/scope; read-only mode is enabled by default to prevent modifying data or schema, while updates by ID remain possible.. Index management and recommendations: List all indexes with their definitions (optionally filtering by bucket/scope/collection/index name) and obtain index recommendations from the Couchbase Index Advisor.

Couchbase MCP Server 2025: Features & Setup Guide

Overview

Couchbase MCP Server is an MCP server implementation that lets LLMs directly interact with Couchbase clusters. It exposes MCP commands to discover cluster resources (buckets, scopes, and collections), inspect a collection’s structure, and perform CRUD operations on documents by ID. It supports running SQL++ queries scoped to a bucket and scope (with the cluster’s Query service required for certain operations) and enforces a read-only mode by default via CB_MCP_READ_ONLY_QUERY_MODE to prevent modifying data or schema, while allowing updates by ID. Additional capabilities include listing all indexes with their definitions, and obtaining query-optimization recommendations from the Couchbase Index Advisor; checking cluster credentials; and reporting cluster health and running services. The server can run from PyPI or from source using uv, and supports multiple transport modes: Streamable HTTP, SSE (deprecated), and stdio. Configuration is via environment variables or CLI arguments; a Docker image is available and deployment can be via a managed MCP server in Smithery.ai. The README also provides client-specific configuration guidance for Claude Desktop, Cursor, and Windsurf Editor.

Features

List all buckets in the cluster

Returns a list of all buckets currently defined in the connected Couchbase cluster.

List all scopes and collections in a bucket

Provides the scopes and their collections for a given bucket.

List all scopes in a bucket

Return all scopes within the specified bucket.

List collections in a scope and bucket

List all collections within a given scope and bucket; requires the cluster to have the Query service.

Get collection structure

Get the structure for a collection.

Document CRUD operations

Get a document by ID, upsert a document by ID, and delete a document by ID from a specified scope and collection.

SQL++ query execution with read-only mode

Run a SQL++ query scoped to the bucket/scope; read-only mode is enabled by default to prevent modifying data or schema, while updates by ID remain possible.

Index management and recommendations

List all indexes with their definitions (optionally filtering by bucket/scope/collection/index name) and obtain index recommendations from the Couchbase Index Advisor.