qmd vs Rocky

qmd is a lightweight local search engine built by Tobi Luetke, CEO of Shopify, for indexing and querying personal knowledge bases, documentation, and meeting notes — entirely offline. It combines three retrieval approaches in a single pipeline: BM25 full-text search for exact keyword matches, vector semantic search via ONNX-based embeddings, and LLM re-ranking using GGUF models through node-llama-cpp. All three stages run locally with no cloud dependency. The tool ships in multiple deployment modes: a CLI for ad-hoc queries, a Node.js library for programmatic use, an HTTP service for local API access, and — most useful for AI workflows — a native MCP server that lets Claude Code, Cursor, and similar editors query your local knowledge base directly during coding sessions. The hybrid retrieval approach means it handles both "find the exact error message from last week's standup notes" and "what was our decision about the auth architecture" equally well. What makes this notable beyond its technical approach is provenance: Luetke shipped it as a personal tool he actually uses, not a startup product. The GitHub history shows active iteration and he's been talking about it on X. It's a credible signal of where pragmatic AI-augmented knowledge management is heading for technical users who prefer local-first tools.

Rocky is a Rust-based SQL transformation engine that brings software engineering discipline to data pipelines. Where tools like dbt gave data teams a version-controlled workflow, Rocky goes further: type-safe compile-time SQL, column-level lineage visualization, git-style branches for isolated testing, and a built-in AI intent layer that stores your purpose as metadata alongside the code. The branching feature is the standout — you can create a branch, run it against an isolated schema, inspect the results, then drop or promote. The column-level lineage shows the full downstream blast radius before you ship a change, tracing any single column back through every aggregation and join to its source. This is the kind of visibility that prevents the "who broke the revenue dashboard" post-mortems that happen in every data team. The AI intent layer is genuinely novel: it stores what a model is supposed to do as metadata, so AI can later explain models, auto-update them when upstream schemas change, and generate tests based on the original intent. Rocky integrates with Dagster via an official plugin and supports DuckDB for local development with no credentials required. With Hacker News coverage and a Rust-native architecture, it's positioned as the data pipeline tool for engineering-forward teams who are tired of YAML-based transformations.