QueryMate is a full-stack SaaS application that allows users to query their databases using natural language. It converts user questions into code using AI, executes queries safely, and displays results with visualization.
This project is built with separate frontend and backend architecture to simulate real-world production systems.
Warning
Preview version only support Postgres and MySQL db tested.
- AI-powered query generation
- Connect PostgreSQL, MySQL, SQLLite, MONGODB databases
- Secure authentication (JWT and google)
- Execute queries with safety validation
- Query history and saved queries
- Results table with export (CSV, JSON) [upcoming]
- Modern dashboard UI
Frontend
- Next.js
- TypeScript
- Tailwind CSS
Backend
- Next.js API
- PostgreSQL
- JWT Authentication
AI
- Groq API
- User connects their database
- User asks question in natural language
- Backend sends request to Groq api
- AI generates SQL query
- Backend validates and executes query
- Results displayed in frontend
Dhiraj Arya [dhirajarya.ptn@gmail.com]