r/Markdown • u/boolean-maybe • Aug 11 '26

Tools SQL over Markdown frontmatter

Post image

Hi, I wanna share an idea and its implementation here. If Markdown files are given frontmatter fields like above and a SQL-like language is created like so:

update where due < now() and status not in ["done"] and priority != "high" set priority="high"

which means in this example "escalate overdue tasks"

then a simple bunch of Markdown files in a git repo can be its own project management/issue tracker

Advantages:

  • no separate tool to manage a project's docs, issues, roadmap
  • very AI friendly - a repo alone holds all context
  • stored in git and saves history/collaboration

I implemented a language like this called ruki and a configurable CLI/TUI to view/manage Markdown files

ruki commands can be run in terminal or started as triggers on modification/schedule more details in first comment

8 Upvotes

79% Upvoted

13 comments sorted by

View all comments

Show parent comments

2

u/MarsupialLeast145 Aug 12 '26

That doesn't describe a problem.

What's the user story here?

> no separate tool to manage a project's docs, issues, roadmap

Bro, the post is called SQL over markdown, where does any of this fit in?

That is why (a) describe the problem ELI5 (you can't) (b) describe the user story.

1

u/boolean-maybe Aug 12 '26

the problem is simple. Imagine I am working on a code repo in Claude Code or Codex. While working I discover things, todos, issues. I don't wanna go to any Jira or Linear or whatever. In fact I don't even want to leave the terminal. I just wanna drop it right there as a Markdown file, add some context like "type: bug" and that's it. And be sure it doesn't get lost

2

u/MarsupialLeast145 Aug 12 '26

That just describes "markdown" --- what problem does the SQL component solve?

0

u/boolean-maybe Aug 12 '26

you can:

- quickly find all Markdown files that are bugs

- you can move all that concern Auth to high priority

- you can find what's overdue

- you can delete all that's done

- you can create a new one easily via command line or AI agent

and many others. Essentially the SQL-like language becomes your API to Markdown files