MemPalace vs Metrics SQL by Rill

MemPalace is a free, MIT-licensed AI memory framework that stores LLM conversation data verbatim locally — no AI summarization step, no per-query API costs. It integrates with Claude Code, ChatGPT, and Cursor via MCP, and claims the highest LongMemEval benchmark score among free memory frameworks at 96.6% (initially claimed 100% before community pressure forced a correction after GitHub issue #29 exposed test-set tuning). The project went viral on GitHub with 23,000+ stars in under 48 hours, partly because it was built by actress Milla Jovovich and developer Ben Sigman — an unusual origin story that dominated early coverage. But the technical pitch is real: competing paid solutions (Mem0 at $19–249/month, Zep at $25+/month) do similar things and charge for the privilege. MemPalace runs fully local, connects to any POSIX filesystem, and the verbatim storage approach avoids hallucination artifacts introduced by AI-summarized memory. The catch: verbatim storage means much higher storage overhead than summarization-based approaches, retrieval latency grows with context size, and the benchmark controversy raised questions about the team's methodology. For personal projects and small teams, the zero-cost angle is hard to argue with. For production systems where memory quality is critical, wait for independent benchmarking.

Metrics SQL is a SQL-based semantic layer from Rill Data that solves a specific and painful problem: AI agents that query your data warehouse tend to hallucinate aggregation logic, producing metrics that look plausible but are mathematically wrong. Metrics SQL lets analysts define business metrics once — revenue, MAU, conversion rate, ROAS — in a governed definition layer, and then exposes those definitions as queryable SQL tables. Every dashboard, notebook, and AI agent resolves from the same source. The technical approach is elegant: rather than inventing a new DSL, Metrics SQL extends SQL itself. An agent that knows SQL can query `SELECT * FROM metrics.weekly_revenue` and get correctly computed numbers without needing to know how revenue is defined, which tables it joins, or how edge cases like refunds are handled. The semantic layer intercepts the query, applies the governed definition, and returns correct results. The implications for AI-native data stacks are significant. Currently, one of the biggest failure modes for AI analysts and BI agents is inconsistent metric computation — different agents or dashboards produce different numbers for 'revenue' because they implement aggregation logic differently. Metrics SQL addresses this at the infrastructure level, not by improving agent prompting.