Couchbase

What is Couchbase?

The Couchbase MCP server implements the Model Context Protocol (MCP) to bridge large language models with Couchbase Capella clusters. It allows MCP clients such as Claude Desktop to execute SQL++ queries using natural language commands.

How to use Couchbase?

Clone the repository, install dependencies with npm install, create a .env file with connection string, username, and password, then build with npm run build. Run the server using npx couchbase-mcp-server, which communicates over standard input/output (Stdio transport). Ensure your MCP client (e.g., Claude Desktop) is configured to connect to this local server.

Key features of Couchbase

• Provides a single tool: query-couchbase.
• Executes SQL++ queries on Couchbase Capella clusters.
• Translates natural language requests into SQL++ statements.
• Uses the Couchbase Node.js SDK for database operations.
• Communicates via StdioServerTransport (stdin/stdout).

Use cases of Couchbase

• Ask "Show me the results of SELECT * FROM my_bucket LIMIT 10".
• Request "Execute this query: SELECT name, age FROM users WHERE active = true".
• Get the latest documents from a bucket in plain English.
• Summarize recent orders from an orders bucket.

FAQ from Couchbase

What transport does the Couchbase MCP server use?

It uses the StdioServerTransport, meaning it communicates over standard input/output.

What environment variables are required?

You need COUCHBASE_CONNECTION_STRING, COUCHBASE_USERNAME, and COUCHBASE_PASSWORD.

Does the server work with any Couchbase deployment?

It is designed for Couchbase Capella clusters; the connection string should point to a Capella endpoint.

How can I debug the server?

All logging messages are sent to stderr so that stdout contains only MCP protocol JSON; check stderr for connection and error details.

What tool does the server expose?

It exposes a single tool called query-couchbase that runs SQL++ queries against your Couchbase Capella cluster.