DigiNews

Tech Watch by Johan Denoyer

← Back to articles

Sqlsure: deterministic semantic checks for AI-generated SQL

Quality: 8/10 Relevance: 9/10

Summary

Sqlsure is an open-source tool that deterministically checks AI-generated SQL for semantic correctness before execution. It uses dictionary-based rules derived from dbt manifests, PK/FK declarations, and information_schema to catch issues like double-counting, incorrect joins, and non-additive measures, all offline without sending data to a database. It provides a CI gate, an MCP server, and a library for embedding checks in text-to-SQL pipelines, with proven benchmarks and production usage.

🚀 Service construit par Johan Denoyer