Text-to-SQL & semantic layer

KlodMetrics

In prod DuckDBxgrammarPython

What it is

Natural-language warehouse querying, 100% local: declarative semantic layer, constrained SQL generation, DuckDB execution. klodmetrics ask CLI.

The architect's call

Six phases shipped under gates: each had to clear its own exit criterion before the next began. One founding assumption was falsified by its own gate and dropped rather than worked around — all forty decisions, abandonments included, are tracked by name in a decision log. Costly trap learned: xgrammar constrained decoding enforces alphabetical key order in the schema, silently breaking a prompt written in logical order.

The code

Private repository — walkthrough over a call

Capabilities engaged

Your data cannot leave the building?

That is precisely the problem I solve. A 30-minute call is enough to scope an audit.