AI-SPM vs Metrics SQL by Rill

AI-SPM (AI Security Posture Management) is an open-source control plane for AI agent security in production environments. Built by indie developer dshapi and posted to Hacker News, it addresses a real gap: most LLM systems now have tool access and decision-making power, but almost no runtime oversight layer to catch when things go wrong. The system works as a gateway between your application and the LLM, enforcing three main controls: prompt injection detection (including obfuscated variants that bypass naive pattern matching), structured tool call validation against defined policies using Open Policy Agent (OPA), and sensitive data leakage prevention (PII and model output filtering). An Apache Kafka and Apache Flink streaming pipeline provides real-time audit trails and anomaly detection. The creator's key insight is that tool misuse — not model jailbreaks — is the primary risk vector in production AI agents. A rogue or compromised agent that escalates tool permissions or exfiltrates data through sanctioned channels is far harder to catch than a classic prompt injection. AI-SPM is early, minimal traction, and needs real-world stress testing. But as AI agent deployments mature from demos to production, runtime security tooling like this becomes non-optional.

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.