Skip to main content

Editor Overview

The editor is where you write and test SQL in Kvery. It is built on Monaco — the same editor engine used by VS Code — so it feels familiar and fast, with syntax highlighting, multi-line editing, and code completion.

A focused workspace​

In the editor you:

  • Pick a connection to run against.
  • Write SQL with autocomplete for your schema.
  • Run the query and inspect the results.
  • Save it as a new query or update an existing one.

You can open several queries in the editor at once and reorder them, which makes it easy to work on related queries side by side.

What the editor gives you​

  • Schema-aware autocomplete — your schemas, tables, and columns are suggested as you type. See Autocomplete and snippets.
  • Snippets — insert reusable SQL fragments saved at the group level.
  • Directives — Kvery-specific instructions for error handling, HTTP status codes, and webhooks. See Directives.
  • Column modifiers — prefixes that change how a result column is displayed. See Column modifiers.
  • Keyboard shortcuts — run, format, and navigate without leaving the keyboard. See Keyboard shortcuts.

Working with files​

You can upload supporting files in the editor — for example SSL certificates and SSH keys for secure connections, or a data file to drive an import.

From editor to production​

The editor is the starting point, but a query becomes useful once you save it and then share, schedule, or chart it. When editing a live query, use a draft so consumers are not affected until you publish.