Krafna

Features

• Query Markdown files in a directory using SQL-like syntax
• Support for frontmatter data extraction
• Flexible output formats (TSV and JSON)
• Compatible with Neovim plugin Perec

Installation

Cargo (Recommended)

cargo install krafna

Homebrew

brew tap 7sedam7/krafna
brew install krafna

Usage

Basic Query

krafna "SELECT title, tags FROM FRONTMATTER_DATA('~/.notes')"

Find Files

krafna --find ~/.notes

Output as JSON

krafna "SELECT * FROM FRONTMATTER_DATA('~/.notes')" --json

Include Specific Fields

krafna "SELECT * FROM FRONTMATTER_DATA('~/.notes')" --include-fields title,tags

Syntax Differences from Dataview

• Uses standard SQL syntax
• Selection of "table" to query is done with FROM FRONTMATTER_DATA("<path>") function, that makes all md files within a row (their frontmatter data). Currently no other sources and no JOINs. I plan to add them later.
• Not all Dataview features are implemented yet

Neovim Integration

Use with the Perec Neovim plugin for seamless integration.

Roadmap

(not in priority order) [ ] TODOs [ ] add group by [ ] add . support for accesing sub-fields (file.name) [ ] * migrate file_name, etc under file (name, path, created, accessed, modified) [ ] add default variables (today) [ ] add functions [ ] * DATE("some-date") -> new type date [ ] implement val -> val operators [ ] add querying of TODOs [ ] add querying of links between notes

Author

7sedam7