sql-validation

YAML-first, domain-driven data governance for AI agents — teach agents your business domains, metrics, and rules before they write SQL

QA portfolio project demonstrating API testing, SQL validation, and Python automation using DummyJSON E-Commerce API, Postman, SQLite, requests, and pytest.

Eval-driven SQL reliability for AI agents — generate, validate, safely execute, and regression-test LLM SQL. MCP + FastAPI gateways, execution-truth evals, CI regression gate.

Reproducible evaluation of schema-grounded Text-to-SQL using BIRD Mini-Dev, with schema retrieval, SQL validation, bounded repair, abstention, and read-only SQLite execution.

A new package that helps developers ensure column safety in SQLite queries by analyzing and validating their SQL statements. The package takes a user's SQL query as text input and returns a structured

A standalone data quality/QA project: SQL validation queries + Great Expectations suite on a synthetic timesheet dataset.

Two-stage LLM-based Text-to-SQL framework with schema retrieval, SQL validation, and self-correction.

A Multi-Agent SQL Assistant powered by LangGraph, LangChain, Ollama, and SQLite for natural language database querying, featuring specialized agents for schema analysis, SQL generation, validation, execution, and visualization.

Deterministic semantic verification for agent-generated SQL.

Multi-agent natural language to SQL for supply-chain analytics: LangGraph agents, sqlglot safety validation, read-only DuckDB, FastAPI + Streamlit. Runs free in mock mode.

Governed, template-based text-to-SQL for manufacturing: pre-approved SQL templates, a multi-rule validator, and full audit logging, exposed via an MCP server and a no-API-key CLI.

Deterministic validation layer between a text-to-SQL model and the warehouse. Proves fan-out, metric contract and policy violations from the sqlglot AST against a semantic contract, repairs what it safely can with a diff, and refuses the rest with a reason. 30 of 30 wrong generations caught, 4.56 ms per query. No model API is called.

Agentic Text-to-SQL assistant for synthetic workforce analytics with Streamlit, RAG schema retrieval, SQL validation, DuckDB, and Live API mode.

Chat-to-SQL with read-only guardrails: the model proposes SQL, deterministic code validates it (SELECT-only, allow-listed tables, limits, timeouts, read-only role) and logs every query. Includes an MCP server for Claude.

Аналитика корпоративного хранилища по вопросам на русском языке. Локальная LLM, Text-to-SQL для MS SQL Server, многорубежная проверка запросов.

Airflow + Postgres DQ platform: observability, rule-based monitoring (SQL+JSON), pluggable alerting, Metabase dashboards.

Production-style Flask backend for safe natural-language-to-SQL analytics using OpenAI, SQLite, SQL validation, audit logging, Redis rate limiting, Docker, and pytest.

Autonomous LLM agent runtime with a Data Analyst Workbench — bounded tool/skill/delegation loop, cited SQL analysis, PDF/DOCX reporting.