Natural language to SQL, but with read-only guardrails
Summary
A tool that converts natural language queries to SQL with read-only restrictions to prevent data modification.
Similar Articles
Giving a database agent read-only that the database enforces, not a regex over the SQL
The author shares lessons learned from adding a natural-language-to-SQL assistant to an open-source database client, focusing on challenges with local models like schema selection and the need for database-enforced read-only access to prevent semantically incorrect queries.
AgentNLQ: A General-Purpose Agent for Natural Language to SQL
This paper presents AgentNLQ, a multi-agent system for natural language to SQL conversion that achieves 78.1% semantic accuracy on the BIRD benchmark through schema enrichment and a self-correcting orchestrator.
The Nuts and Bolts of Natural Language to SQL Translation: A Systematic Analysis of Model Pipeline Optimisation Approaches and their Interactions
This paper systematically analyzes multiple pipeline extension components for Natural Language to SQL translation, including intermediate representations, synthetic data, preprocessing, and a reranker, using SmBoP and RASAT architectures, and finds that their interactions matter more than simply combining all components.
**No need to write SQL anymore. Just ask questions in plain English and get your answers (with the SQL behind them).** Link in Comments
A developer built 'Ask Your Data,' an AI-powered text-to-SQL app that lets users query a 1M-row synthetic loan portfolio in plain English, generating validated PostgreSQL queries with charts and transparent SQL output for verification.
Pattern for giving an agent reliable "talk to my data warehouse" access without raw text-to-SQL
A pattern for giving AI agents reliable access to data warehouses by using a curated semantic layer (Databricks Genie) instead of raw text-to-SQL, improving accuracy and governance. The agent calls Genie's Conversation API as a tool, receiving both natural-language responses and exact SQL.