Elyra
 Elyra The coding agent e The native code editor Elyra Grove Native local development environment Askr The real server for Laravel & PHP Elyra Conductor Local project conductor Elyra SQL Server MySQL-compatible SQL server in Rust Elyra SQL Client Native desktop SQL workbench Elyra SQL Anywhere Replication-ready SQL engine
Start here
Overview
Getting started
Installation
Editions & licensing
Guide
SQL editor
Browse & edit
Query builder
Connections
Import & export
Data modeling
Navigator
Server tools
Backup
Shortcuts
Reference
Configuration
Security
Troubleshooting
Architecture
Release notes
Changelog
Elyra
Elyra
Elyra SQL Client
SQL Editor

SQL Editor

Each query tab has a CodeMirror 6 editor tuned for the ElyraSQL dialect.

Writing and running

  • Syntax highlighting and schema-aware autocomplete (keywords, tables and columns from the active database's cached schema).
  • Run the whole script or press ⌘/Ctrl + Enter.
  • Multiple statements produce multiple result sets, each with timing, row count and affected rows.
  • ⌘/Ctrl + / toggles line comments.

Query plan (EXPLAIN)

Click Explain to run EXPLAIN on the current query and view the plan in the results grid.

Formatting

Format prettifies the current SQL (MySQL dialect, upper-case keywords).

History

Every execution is recorded locally (status, rows, elapsed, timestamp). Open History from the toolbar or ⌘/Ctrl + Y, search past queries, and click one to reopen it in a new tab.

Saved queries

Press ⌘/Ctrl + S to save the current query with a name and optional folder. Reopen saved queries from the command palette (Saved queries).

Tabs

  • ⌘/Ctrl + T — new query tab.
  • ⌘/Ctrl + W — close the active tab.
  • Query tabs and table (browse) tabs coexist in the same tab bar.

!!! tip "Free edition" Free runs read-only: SELECT/SHOW/EXPLAIN work; writes and DDL require Pro.

Back to docs