SQL Editor

The SQL Editor lets you browse workspace databases, write and execute SQL statements, export query results as CSV, visualize results as charts, manage reusable workbooks, and retrieve external SQL connection strings.

Open Data Processing > SQL Editor from the left sidebar to begin.

Browse databases and manage workbooks

The left panel offers Database and Workbook tabs. You can collapse or expand the panel from the toolbar or drag the divider to resize it.

  • Database tab:

    1. Search databases, refresh metadata, and expand databases and tables to inspect columns.

    2. Databases load incrementally; click Load more when working with large lists, or choose the execution context from the Select database dropdown in the toolbar.

    3. Subscribed tables remain subject to read-only and upstream authorization constraints; see Data Sharing.

  • Workbook tab:

    1. Search workbooks, click Create new workbook to add a named workbook, and rename or delete existing workbooks (the last remaining workbook cannot be deleted; name length and workbook count limits follow UI validation).

    2. Edits are saved automatically as a Draft, and selecting another workbook loads its saved SQL buffer.

Running CREATE TABLE and similar DDL statements in the SQL Editor creates physical tables in MatrixOne without automatically registering them in Catalog, so they do not appear under Resource Center > Catalog. To manage tables in Catalog or reference them in workflows and knowledge bases, create them via Import data or Catalog objects.

Write and run SQL

  1. Select the active database in the toolbar dropdown, or qualify table names explicitly as db.table.

  2. Enter SQL in the editor (line numbers and syntax highlighting are enabled; separate multiple statements with semicolons ;).

  3. Highlight a statement or position the cursor inside a statement (the toolbar previews Current statement), then click RUN.

  4. The terminal area opens a separate result tab for each executed statement; long-running queries can be aborted from the terminal (Killed when stopped).

Inspect, download, and visualize results

The bottom terminal panel can be minimized, maximized, resized, or cleared (Close all tabs). Each successful query tab provides two sub-tabs:

Query results and CSV export

  1. Under Query Result, inspect the result grid, execution status, displayed/returned row counts (up to the first 1000 rows are shown in the grid), and elapsed duration.

  2. Click the Download icon in the result status bar to export query results as a CSV file.

Charts

  1. Switch to the Chart sub-tab.

  2. Choose a chart type: Bar, Line, Scatter, or Area.

  3. Configure X-Axis and one or more Y-Axis columns (click Add Y-Axis to compare multiple numeric series).

Chart clarity depends on clean SQL shape. If detail and summary rows are mixed, dates are unsorted, or numeric columns are cast as text, update the SQL query first.

Copy SQL connection string

To connect an external SQL client, terminal CLI, or BI tool directly to your workspace database:

  1. Click Connection String in the SQL Editor toolbar to open SQL Connection String.

  2. Toggle visibility (Show Full Connection String / Hide Connection String) or click Copy Connection String to copy the command to your clipboard.

  3. If retrieval fails, click Retry and verify workspace and role permissions.

The SQL Editor runs on the workspace query link and does not expose a separate SQL compute selector in the toolbar. For compute resource configuration or external MatrixOne instance workbench SQL, see Compute Resources and Database & SQL operations.

Browse larger database lists and troubleshoot

  • Cannot see a newly imported or shared table: Click Refresh or Load more in the database tree, check table access under Role Permissions, or confirm subscription acceptance under Data Sharing.

  • Result download fails or reports permission denied: Result downloads enforce effective role permissions; check query execution details in SQL History.

Next steps

What you want to do

Go to

Add a SQL step to a workflow

Workflow Nodes

Inspect a failed run or query profile

Run and Debug and SQL History

Build recurring multi-chart dashboards

Create and use data dashboards

Last updated on