Skip to main content

Autocomplete and Snippets

The editor actively helps you write SQL by suggesting names from your database schema, your group's snippets, and Kvery's own directives.

Schema-aware autocomplete​

As you type, Kvery suggests:

  • Schemas in the connected database,
  • Tables within those schemas, and
  • Columns within those tables.

Suggestions are sorted to surface the most relevant matches first, so you can write correct SQL quickly without memorising your schema or switching to another tool to look up column names.

Snippet suggestions​

Your group's snippets appear as completion items too. Insert one to drop its SQL into your query at the cursor. Snippets are the recommended way to reuse tested fragments — joins, filter blocks, or directive boilerplate — across many queries.

Kvery directive suggestions​

The editor also suggests Kvery's own directives and column modifiers as completions, so you can discover and insert them without memorising the syntax:

  • Directives such as ON ERROR RETURN, SET HTTPCODE, and ON SUCCESS POST '' TO '' / ON ERROR POST '' TO ''. See Directives.
  • Column modifiers such as json::, hidden::, select::, and more. See Column modifiers.
  • Helpers such as return(); and returnk();.

Tips​

  • Start typing a table name and let autocomplete complete the rest — this avoids typos that cause runtime errors.
  • Build a small library of group snippets for the patterns your team uses most.
  • Use directive completions to learn the available directives and modifiers.