Project Summary

An Agentic AI-powered assistant that converts natural language into SQL across multiple database dialects (MySQL, PostgreSQL, Oracle, SQL Server, Amazon Aurora). It analyzes schemas, executes queries, explains the Order of Execution, and displays results with copy and example libraries.

Skills Demonstrated

Tools Used

Solution

Users upload a SQL script or SQLite DB. The assistant parses schema, takes a natural language question, generates dialect-specific SQL, executes it, and returns results. It also produces step-by-step Order of Execution and dialect conversions.

Approach

1. Upload: Accept .sql scripts or SQLite DB files (auto schema extraction).
2. Understand: Analyze tables/columns to build a schema context.
3. Translate: Convert natural language to SQL (target dialect aware).
4. Generate (Multi‑Dialect): Produce SQL for multiple databases in one go — MySQL, PostgreSQL, SQLite, Oracle, SQL Server, and Amazon Aurora.
5. Execute: Run the SQL and render results with DataTables.
6. Explain: Show Order of Execution to teach how the query runs.
7. Convert / Copy: Provide side-by-side equivalents across dialects with quick copy actions.

Project Link(s)