SQLite Index

The SQLite database lives at:

<library>/.pkm/.index/pkm.db

It is a local cache. Do not commit it.

Core Tables

Table	Purpose
notes	One row per Markdown note
tags	Note tags
aliases	Frontmatter aliases
metadata	Custom frontmatter metadata
refs	Extracted wikilinks
heat	Cached relatedness scores
libraries	Registered project libraries in the global database
fts_notes	FTS5 search index

Rebuild Model

pkm index drops and recreates the schema. This avoids merge conflicts and keeps the implementation simple.

Freshness

If search, backlinks, or heat look stale, rebuild:

pkm index