The Problem

Students studying Business Information Technology, business analysts, product managers, and non-technical founders frequently need to analyze data in SQL databases. However, raw SQL syntax (JOIN, GROUP BY, HAVING, foreign keys) is intimidating, and traditional database management tools are cluttered and enterprise-heavy.

TalkToDB solves this by letting anyone explore databases visually and query in plain English.

✨ Features

| Feature | Description | |---------|-------------| | 🤖 AI Engine (Gemini / OpenAI / Groq) | Converts complex questions into multi-table SQL joins, window functions, and subqueries | | 🩹 Self-Healing SQL Loop | If SQLite returns a syntax or schema error, AI inspects the error and auto-corrects the query | | 💡 Executive Data Takeaways | Synthesizes a 2-sentence human summary answering the core business question directly | | ⚡ Dual-Mode (Online & Offline) | Works instantly offline with zero config, or supercharge with a free Google Gemini key | | 🕸️ Auto ERD Diagram | Automatically maps tables, columns, primary keys (🔑), and foreign key connection lines (🔗) | | 📊 Instant Table Quality Metrics | Row counts, column data types, missing/null value percentages, and completeness scores | | 📥 1-Click CSV Export | Export any query or table preview to CSV with a single click | | 🎓 Built-in Educational Datasets | Pre-loaded with University Student Portal and Solar E-Commerce databases |

🚀 Quick Start

1. Launch with Demo Datasets in Browser

npx @damisile_ayoola/talk-to-db --demo

Open http://localhost:4300 to interactively explore the University or E-Commerce database.

2. Open Your Own SQLite Database

npx @damisile_ayoola/talk-to-db ./my_database.sqlite

💬 Example Plain-English Queries You Can Ask

| What You Type | Generated SQL Query | |---|---| | "Top 5 students with highest GPA" | SELECT * FROM students ORDER BY students.gpa DESC LIMIT 5; | | "How many courses are in Business Information Technology?" | SELECT COUNT(*) as total_count FROM courses; | | "Show instructors with salary above 1300000" | SELECT * FROM instructors WHERE salary >= 1300000 LIMIT 25; | | "List students with their department" | SELECT * FROM students JOIN departments ON students.dept_id = departments.dept_id LIMIT 25; | | "Find products with zero stock" | SELECT * FROM products WHERE stock = 0 LIMIT 25; |

🛠️ CLI Options

| Flag | Description | Default | |------|-------------|---------| | [dbFile] | Path to SQLite .sqlite, .db, or .sql file | :memory: | | --demo | Launch directly with the University Student Records database | false | | --dataset <name> | Default dataset: university, ecommerce | university | | -p, --port <number> | Web Studio port | 4300 | | -h, --help | Display help | — |

🧪 Running Automated Tests

npm test

📜 License

MIT © Ayoola Damisile