dataview

name	dataview
description	Query and analyze notes using Dataview DQL language. Use when user needs tables, lists, or data analysis from vault metadata and frontmatter properties. Requires Dataview plugin.
license	MIT
compatibility	Requires Dataview plugin to be installed and enabled in Obsidian
metadata	{"author":"Smart2Brain","version":"1.0","linkedPlugin":"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).

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:".