Database & SQL AI: On-the-fly database transformation with natural language. Connect, transform, and export instantly.
Published: September 1, 2025
With DATS-4 Database AI Suite (Open Source):
- Connect: to any database (MySQL/Postgres) on-the-fly
- Instruct: the agent to add derived variables or perform data transformations
- Execute: the agent writes the SQL and creates a new, transformed table and logs the entire process
- Validate: review agent reasoning, SQL and debugging carried out by the agent
- Export: the finished table to CSV for further analysis from right within the app
DATS-4 also supports direct CSV uploads, fixed DB connections and temporary Postgres instance on-the-fly.
The live app, source code, and my full Field Guide are available at the links below.
Direct to DATS-4: app.tigzig.com/analyzer
Main Site (25+ Tools): app.tigzig.com
🔗
Blog Migration Notice: Some links or images in earlier posts may be broken.
View the original post on the old blog site.