---
title: Query and Explore with the Workbench
description: The workbench for Operational Insights provides a graphical user
  interface for query development and data exploration.
pubDate: 2026-11-05T15:16:13.118Z
meta:
  component:
    title: Operational Insights Capella
    version: ""
  topic_type: guide
antora:
  editUrl: https://github.com/couchbaselabs/docs-columnar/edit/main/modules/query/pages/workbench.adoc
  xref: xref:analytics:query:workbench.adoc[]
---

[Consult the llms.txt file for a full list of contents](/llms.txt)
[View original HTML](/operational-insights-cloud/query/workbench.html)

# Query and Explore with the Workbench

> The workbench for Operational Insights provides a graphical user interface for query development and data exploration. 

You use the workbench to manage your databases, scopes, and collections; create, run, and save SQL++ for Operational Insights Cloud queries; and view and save query results and metrics — all in a single window.

## [](#prerequisites)Prerequisites

To use the workbench for Operational Insights:

* You must have the [Organization Owner](../../cloud/organizations/organization-user-roles.md#organization-role-organization-owner) role in your organization, or one of the following [project roles](../../cloud/projects/project-roles.md) for the project that contains your cluster:

  * [Project Owner](../../cloud/projects/project-roles.md#project-owner-role)
  * [Database Data Reader/Writer](../../cloud/projects/project-roles.md#project-cluster-data-reader-writer) (Allows queries that read and write data)
  * [Database Data Reader](../../cloud/projects/project-roles.md#project-cluster-data-reader) (Allows read-only queries)

## [](#workbench-features)Workbench Features

Features of the workbench include:

* Controls for adding and managing databases, scopes, collections, and links. See [Access and Organize Data in Operational Insights Services](../sources/database-objects.md).
* View a collection's primary key, source link, and indexes, or infer its schema, from the explorer. See [Managing Operational Insights Collections](../sources/manage-collections.md).
* A single, integrated visual interface for query development and testing. The query editor offers multi-line formatting, copy-and-paste, syntax coloring, and easy cursor movement. See [Write and Run Queries](editor.md).
* Query-writing assistance from Capella iQ. See [Get Assistance from Capella iQ](iq.md).
* Immediate display of metrics for executed queries and access to the query plan. See [View Query Metrics or Plan](metrics-plan.md).
* A query history for quick revision and re-execution. See [Use the Query History](history.md).
* Index recommendations for the query in the active query editor, based on query patterns and data samples. See [Index Advisor](../sqlpp/5c-index-advisor.md).
* Define query-specific settings, including a maximum time limit and positional parameters. See [Set Query Options](options.md).
* Options for displaying query results in JSON or table format, for copying or downloading query results in JSON format, and for copying a flattened version of query results in TSV format. See [Work with Query Results](results.md).
* Data visualization options for query results. See [Visualize Results in Charts](charts.md).
* Options for saving results in views or tabular views. See [Save Views or Tabular Views](views-tavs.md).

## [](#accessing-the-workbench)Accessing the Workbench

1. Select the **Operational Insights** tab.
2. Click the name of the cluster you want to work with. The workbench opens.

The workbench has the following working panes:

* An explorer where you select, create, and manage entities.
* The query editor.
* Options for reviewing query results.
* **History**, **iQ**, and **Index Advice** tabs that toggle with one another.

## [](#see-also)See Also

* [Access Data](../intro/examples.md)
* [SELECT Statements](../sqlpp/3%5Fquery.md)