Couchbase

Note: This driver is available in Lite, Enterprise, Ultimate and Team editions only.

This guide provides instructions on how to set up and use Couchbase with DBeaver.

Before you start, you must create a connection in DBeaver and select Couchbase. If you have not done this, please refer to our Database Connection article.

DBeaver interacts with the Couchbase server using a specific driver. It supports all versions of Couchbase, but the correct driver must be selected: use Couchbase for versions 4.x and earlier, and Couchbase 5+ for version 5 and later.

Couchbase is a NoSQL database that diverges from traditional relational databases by storing data in JSON documents instead of tables. It employs N1QL, an SQL-like language specifically designed for querying JSON. In Couchbase, the concept typically known as databases in traditional systems is represented as Buckets. Unlike relational databases, Couchbase does not support some common features, such as triggers, stored procedures, views, complex joins, and the constructs of primary and foreign keys. For a more comprehensive understanding of Couchbase, please refer to the official documentation.

The section Powering Couchbase with DBeaver details the features supported by DBeaver that are compatible with Couchbase.

This section provides an overview of DBeaver's settings for establishing a direct connection and the configuration of secure connections using SSH, SSL, proxies, and Kubernetes.

In this subsection, we will outline the settings for establishing a direct connection to a Couchbase version 4 and below database using DBeaver.

The page of the connection settings requires you to fill in specific fields to establish the initial connection.

The connection settings for these versions are similar to those for version 4 and below, with the notable exception that the Bucket setting is not used.

The Connection Details section in DBeaver allows you to customize your experience while working with Couchbase database. This includes options for adjusting the Navigator View, setting up Security measures, applying Filters, configuring Connection Initialization settings, and setting up Shell Commands. Each of these settings can significantly impact your database operations and workflow. For detailed guides on these settings, please refer to the following articles:

• Connection Details Configuration
• Database Navigator
• Security Settings Guide
• Filters Settings Guide
• Connection Initialization Settings Guide
• Shell Commands Guide

Couchbase is a NoSQL database system integrated into DBeaver through its API. While configuring connections to Couchbase in DBeaver, there are specific custom properties available, such as Timeouts and SSL settings.

Tip: All timeout settings are specified in milliseconds.

DBeaver supports secure connections to your Couchbase database. Guidance on configuring such connections, specifically SSH, Proxy, Kubernetes, AWS SSM and SSL connections, can be found in various referenced articles. For a comprehensive understanding, please refer to these articles:

• SSH Configuration

• Proxy Configuration

• SSL Configuration

• Kubernetes Configuration

• AWS SSM

Note: For SSL configuration, the required properties are set within the DBeaver Driver settings.

DBeaver provides a host of features designed for Couchbase databases. Couchbase uses a document-oriented approach, which means each piece of data, or "document" can have a unique structure.

In DBeaver, you have the flexibility to view and edit the data within Couchbase buckets. This can be done similarly to how you would interact with tables in a traditional database, either through a grid view or as plain text. You can also work directly with JSON documents, making it easier to handle the different data formats that Couchbase supports.

DBeaver lets you view and manipulate a few Couchbase database objects. DBeaver has extensive support for various Couchbase metadata types, allowing you to interact with:

• Buckets
  • Indexes

• Cluster

  • Users

DBeaver also includes additional features compatible with Couchbase, but not exclusive to it:

Couchbase uses N1QL (Non-First Normal Form Query Language), a query language similar to SQL, it lets you search through JSON documents with complex queries. For further details on N1QL, refer to the official documentation.