Logo User Guide

SQL Console

The SQL Console is Trilium's built-in database editor.

It can be accessed by going to the Global menu → Advanced → Open SQL Console.

Article Image

Interaction#

  • Hovering the mouse over one of the tables listed at the top of the document will show the columns and their data type.
  • Only one SQL statement can be run at once.
  • To run the statement, press the Execute icon.
  • For queries that return a result, the data will displayed in a table.
  • For statements (e.g. INSERT, UPDATE), the number of affected rows is displayed.
Article Image

Interacting with the table#

After executing a query, a table with the results will be displayed:

  • Clicking on a column allows sorting ascending or descending.
  • Underneath each column there is an input field which allows filtering by text.
  • Press Ctrl+C to copy the current cell to clipboard.
  • Multiple cells can be selected by dragging or by holding Shift + arrow keys
  • Results are paginated for performance reasons. The controls at the bottom of the table can be used to navigate through pages.

Saved SQL console#

SQL queries or commands can be saved into a dedicated note.

To do so, simply write the query and press the Article Image button. Once saved, the note will appear in Day Notes.

The note can be locked for editing by pressing the Lock button in the note actions section near the title bar (on the New Layout, or in the Floating buttons area if using the old layout). When editing is locked, the SQL statement is hidden from view.