VaultQuery

Execute SELECT, INSERT, UPDATE, and DELETE statements across notes, properties, tasks, tables, headings, and links.

SELECT path, title, status, priority
FROM notes_with_properties
WHERE status IS NOT NULL
ORDER BY priority, modified DESC;

Turn vault data into working views

Use SQL across notes, properties, tags, tasks, links, headings, list items, and markdown tables.

Choose interactive grids, markdown exports, charts, calendars, JavaScript templates, or inline buttons.

Use SQL to insert, update, and delete markdown-backed data with an explicit preview workflow.

Template variables such as {this.path}, {this.folder}, and frontmatter properties make note-local dashboards practical.

Define named SQL views once, then query them from other notes and dashboards.

Custom functions and triggers support advanced workflows while keeping write behavior explicit.