The Markdown Database Pattern: Use Plain Files as a Lightweight Database

The Markdown Database Pattern proposes treating a folder of markdown files as a structured database, where each file acts as a record, frontmatter fields serve as columns, and directories function as tables. Tags, wikilinks, and task items in the file body become queryable relationships, enabling a surprisingly capable data layer without any dedicated database software. The approach offers key advantages including portability, Git-based version control, and zero framework lock-in, though it is not designed for large-scale data and lacks true relational joins. It works best for collections of up to roughly 10,000 files, covering use cases like team wikis, blogs, and personal knowledge bases. Tools such as Obsidian Dataview and the open-source MarkdownDB already implement versions of this pattern, and a detailed guide with worked examples is available at wayofmarkdown.com.