StrataDocs
↑↓ navigate ↵ open esc close

The SQL workspace and artifact panel

The artifact panel is the slide-in pane on the right of the chat that hosts a SQL workspace, a dashboard viewer, or a file preview — anywhere Strata produces output you may want to edit, re-run, or inspect.

Opening the panel

The panel opens automatically when:

  • Strata calls the SQL workspace tool to write or update a query for you (panel opens in SQL mode).
  • Strata builds an interactive dashboard (panel opens in dashboard mode).
  • You click a file card that Strata generated and the file is previewable (panel opens in file-preview mode).

You can also reopen a previously-saved artifact by loading a conversation that had one — its card appears inline in the transcript, and clicking the card reopens the panel.

SQL workspace

When the panel is in SQL mode, you see:

  • A header with the artifact's purpose (for example, "Top 10 customers"), an Edit history button, a Copy SQL button, and a Close button.
  • Two tabs: Code (the editable SQL) and Output (the query results once you run it).
  • A Run Query button at the bottom.

Editing the SQL

The Code pane is an in-place editor. Click into the SQL and edit directly. Your edits are saved automatically as a new version (see Edit history below). Syntax highlighting refreshes as you type.

Running the query

Click Run Query at the bottom of the panel. Strata executes the SQL against the active connection and switches you to the Output tab. The footer shows the row count and elapsed time.

Exporting results to CSV

The Output pane includes an Export CSV button in the result-set toolbar. It downloads the current result set as strata-export-YYYY-MM-DD-HH-MM-SS.csv. If the download is blocked, the CSV is copied to your clipboard as a fallback.

Asking Strata to modify the query

You do not need to edit by hand. In the chat, ask:

  • "Add a WHERE clause for last quarter."
  • "Group this by customer."
  • "Use a CTE instead."
  • "Add a JOIN to the Products table."

Strata updates the query in the panel, and your previous version is preserved in edit history.

Edit history

Open the history button in the artifact header to see every version of the query saved for this conversation, plus the AI's original snippet as a baseline.

For each version you can:

  • See the line-level diff (additions and deletions) against the current editor.
  • Click a version on the left to load the diff on the right.
  • Click Revert to this to replace the current editor with that version.

Edit history is per snippet, not a global timeline — if Strata is helping you with two different queries in the same conversation, each has its own version history. See /docs/chat/sql-edit-history for details.

Dashboard viewer

When the panel hosts a dashboard, the layout switches to:

  • Two tabs: Code (the raw HTML) and Preview (the rendered dashboard).
  • A Download HTML button (saves as a standalone file) and Copy button in the header.
  • A Refresh button in the footer to re-render the preview after an edit.

See /docs/chat/dashboards.

File preview

When Strata generates an Excel, PDF, Word, or PowerPoint file and you click it, the artifact panel opens a preview. From there you can:

  • Download the file (the download icon in the header).
  • Save to OneDrive (the OneDrive icon in the header — only shown if OneDrive is connected).

Resizing and closing

  • Drag the left edge of the panel to resize it. The width is remembered across pages.
  • Click the X in the header to close the panel. The artifact stays saved in the conversation as a card you can click to reopen it next time you load the conversation.

Persistence

Artifacts are saved to the conversation. When you reload the page or open the conversation from the past-chats sidebar, each saved artifact appears as a card in the transcript; click a card to reopen it in the panel. Inline SQL blocks in the chat transcript show the latest saved version of the snippet, so what you see in chat matches what is in the workspace.

What can go wrong

  • Run Query button errors out. The active SQL connection may be down. Reconnect from Settings > Extensions and retry. See /docs/integrations/sql-server.
  • Edit history is empty. New conversations start with no saved versions; the AI's original snippet always appears as a baseline labeled "Original AI snippet" once you make any edit.
  • CSV export downloads nothing. If the browser blocks the automatic download, the CSV is copied to your clipboard as a fallback — paste it into a text file.
  • Dashboard Preview is blank. Click Refresh in the panel footer. If still blank, the HTML may rely on a script that the sandboxed iframe blocked — open the Code tab to inspect.

Related