AI-SPM vs Rocky

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.

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.