MarkItDown vs Rocky

MarkItDown is Microsoft's open-source Python utility that converts virtually any file format into clean, LLM-friendly Markdown. It handles PDFs, Word documents, PowerPoint presentations, Excel spreadsheets, HTML, CSV, JSON, XML, ZIP archives, images (with optional vision model descriptions), audio files (with transcription), YouTube URLs, and EPub files in one consistent interface. The key design philosophy is LLM-first: rather than trying to reproduce original formatting for human readers, MarkItDown preserves document structure—headings, lists, tables, links—in a format that language models naturally parse efficiently. It integrates with OpenAI-compatible vision clients for image descriptions and supports speech transcription for audio content. With 108k+ GitHub stars and still gaining nearly 2,000 per day, MarkItDown has become the default document ingestion layer for countless AI pipelines. As agents increasingly need to process real-world enterprise documents, this kind of robust conversion utility becomes critical infrastructure—turning messy business files into clean inputs that Claude or GPT-4o can reason about without token-wasting formatting artifacts.

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.