mdsql

mdsql runs SQL over the frontmatter of a tree of markdown files. Each file is a row in a docs table (one column per frontmatter key); the file's own content is never queried, only its frontmatter. A running app is never required — files on disk are the only source of truth.

Before anything else

Confirm mdsql is installed (mdsql --list or which mdsql; if missing, npm install -g mdsql) and that a config exists. Discovery walks up from cwd looking for mdsql.config.json, same as git looks for .git — you don't need to cd to the project root, and --config <path> bypasses discovery entirely. If no config exists yet in the tree you're being asked to query, run mdsql init at its root to write a starter config, then tailor the queries.

See what's queryable

mdsql --list