Query Editor

The Studio SQL Editor is a full-featured IDE for writing and executing SQL queries against Nucleus or PostgreSQL.

Writing Queries

The editor uses CodeMirror with SQL syntax highlighting and the One Dark theme. Write single or multi-statement SQL.

Executing

Press Cmd+Enter (macOS) or Ctrl+Enter (Windows/Linux) to execute the current query.

Results appear in a data grid below the editor with:

  • Column headers with types
  • Sortable columns
  • Row count and execution duration
  • CSV export — Download results as CSV
  • JSON export — Download results as JSON

Query History

Every executed query is saved to browser localStorage (up to 50 per connection).

History entries include:

  • SQL text
  • Execution timestamp
  • Row count
  • Duration (milliseconds)

Click any history entry to restore it into the editor. Duplicate queries are deduplicated to the top.

Saved Queries

Save frequently-used queries by name for permanent storage:

  1. Write your SQL
  2. Click Save and enter a name
  3. Access saved queries from the side panel

Saved queries are persisted server-side (not localStorage), so they're available across browser sessions.

Tips

  • Use \dt style meta-commands in the REPL (neutron repl) — Studio uses standard SQL
  • Multiple statements separated by ; execute sequentially
  • Results show the output of the last SELECT statement
  • DDL statements (CREATE, ALTER, DROP) show success/failure status