Skip to main content
The Work Bench is Nexalytica’s hands-on SQL workspace for analysts who want to query data directly, without an AI agent interpreting their intent. You write the SQL, you choose the source, and you get the raw results back. It is built for exploratory analysis, debugging, and one-off queries that do not need to become full dashboards. No configuration required — if you have platform access, the Work Bench is already available to you.

Sessions

A session is a named scratchpad that remembers your SQL and the most recent result set. Sessions are personal to the browser and device you are using — they are not synced to the cloud or visible to other users. The Work Bench is not available via the Nexalytica API; sessions exist only in the browser.

Create and manage sessions

From the sessions list on the left side of the Work Bench, you can create and organise your saved queries.
Session deletion is permanent. The Work Bench does not move deleted sessions to Trash. Confirm you no longer need the SQL before deleting.

Write and run SQL

Open a session to access the SQL editor. The editor occupies the main area of the Work Bench.

Reference a data source

Instead of typing table names from memory, use the @ mention shortcut to insert a fully-qualified table reference.
1

Type @ in the SQL editor

A source picker appears listing every connected SQL-compatible data source you have access to.
2

Select a source

Use the arrow keys to navigate the list, then press Enter or Tab to select. Press Escape to close the picker without selecting.
3

Select a table

A second picker lists the tables within the chosen source. Select the table the same way.
4

Reference inserted

Nexalytica inserts the fully-qualified table reference at the cursor position. Continue writing your query around it.
The @ picker only lists sources you have access to. If a source you expect is missing, check with your data administrator that you have been granted viewer access or higher on that source.

Keyboard shortcuts

Editor controls

Read query results

Results appear in the panel below the editor immediately after a query completes.

Status badges

Results table

The Work Bench caps the number of rows returned per query. There is no per-page pagination and no one-click CSV export in this view. If your results show a truncated badge, tighten your query with a WHERE clause or a LIMIT to bring the result set within the cap.

Permissions reference

  • Open the Work Bench and create sessions
  • Write and run SQL against any data source they can access
  • Save, rename, share (copy SQL), and delete their own sessions
  • Sessions are private and browser-local — other users cannot see them
Query access is governed by your permissions on each data source. The @ mention picker only lists sources you can access. Running a query against a source you do not have access to returns an error.