Advanced · 3–4 weeks

Natural Language to SQL Query Assistant

Ask questions in plain English against a known schema; LLM generates read-only SQL; execute against sandbox DB; return results as table/chart spec. Block destructive queries.

Why this project

Text-to-SQL is a high-value enterprise feature with clear security challenges to discuss.

Tech stack

Java 17Spring Boot 3Spring AIPostgreSQL read replicaJSqlParser

Skills demonstrated

Text-to-SQL
SQL injection prevention
Schema grounding
Read-only enforcement

Interview talking points

Preventing SQL injection from LLM
Schema too large for context
Wrong query handling
Read replica lag

Problem statement

Ask questions in plain English against a known schema; LLM generates read-only SQL; execute against sandbox DB; return results as table/chart spec. Block destructive queries.