Dataview

Dataview Integration

You have access to the execute_dataview_query tool for running Dataview DQL queries.

Default Result Size

Always include LIMIT 10 in Dataview DQL (queries you show or run) unless the user asks for more or specifies a different limit. If you need pagination or offsets, use a dataviewjs code block and slice the pages array (e.g., .slice(offset, offset + limit)).

Dataview DQL Cheat Sheet

• Query types: LIST or TABLE field1, field2
• FROM sources: #tag, "Folder", "path/to/file"
• Exclusions: AND !#tag, AND !"Folder"
• Note: Tag/folder exclusions belong in FROM, not WHERE. For WHERE, use expressions like !contains(file.tags, "#Template").
• Combine: A AND B, A OR B
• WHERE: WHERE prop (exists), WHERE prop = "value", WHERE numProp > 3
• SORT: SORT field asc|desc
• GROUP BY: GROUP BY prop then use rows (e.g., rows.file.name)
• FLATTEN: FLATTEN multiProp
• LIMIT: LIMIT 10 (default) or user-specified
• Display helper: choice(boolProp, "Yes", "No") as "Label"

Minimal Example

TABLE Title, Author
FROM #library AND !"Templates"
WHERE Rating > 3
SORT file.mtime desc
LIMIT 10

Data Analysis

If you need to SEE the results to answer a question or perform analysis, use the execute_dataview_query tool (supports DQL only).

Scripting the Dataview API (advanced)

Because this skill is enabled and the Dataview plugin exposes a public API, you likely also have an exec_dataview tool (check your available tools) that runs JavaScript against Dataview's api object (the same API dataviewjs blocks use) on the main thread. Use it for anything DQL can't express — aggregation, custom filtering, computing statistics across pages.

• api is the Dataview API; app is the Obsidian app.
• Prefer execute_dataview_query (DQL) for simple tables/lists; reach for exec_dataview only when you need programmatic logic.
• Keep snippets read-only unless the user asked to modify data. Awaited work times out; this is not sandboxed.

// Count pages per tag under a folder
const pages = api.pages('"Projects"');
const byStatus = {};
for (const p of pages) byStatus[p.status ?? "none"] = (byStatus[p.status ?? "none"] ?? 0) + 1;
return byStatus;

Displaying Lists/Tables

If you want to SHOW the user a list or table (e.g. 'List all my books'), simply output the Dataview DQL query in a markdown code block. The chat interface will render the result automatically.

• Do NOT repeat the rendered results in plain text.
• Do NOT tell the user to run the query in a note; it has already been run and rendered here.
• When generating a view, introduce it as "Here is the list:" or "I have generated the view below:".