SQL Editor

SQL Editor

Write, save, and run SQL queries against your connected data sources — no coding required.

Open Script Engine → SQL Editor. Use it to run ad‑hoc queries, save them for reuse, parameterize them so one query serves many inputs, and review past executions.

Anatomy of the editor

• Saved queries (left) — your library of saved queries; click one to load it. Use the search box to find a query by name.
• Data Source — choose which connected data source (for example an ODBC/SQL connection) the query runs against.
• Timeout — the maximum number of seconds the query may run before it is cancelled.
• Parameters — named placeholders such as @part_no prompt you for a value before the query runs, so a single query works for many inputs.
• Editor — write SQL with syntax highlighting and schema‑aware autocomplete.
• Run Query / Save — execute the query, or save it to your library for reuse.
• Editor / Executions tabs — switch between editing and the history of past runs.

Running a query

1. Select a Data Source.
2. Write your SQL. Reference parameters with @name — you'll be prompted for their values.
3. Click Run Query. Results appear below, and the run is recorded on the Executions tab.
4. Click Save to add the query to your saved list.

Permissions: Builders can create, edit, and save queries; Viewers can open and run saved queries.

Next steps

• DataMagik Script Engine
• Script Schedules