Visual SQL query analyzer — analyze and compare queries with execution flow diagrams.

SQTip helps developers and learners understand what their SQL queries are actually doing. Paste a query to get a visual execution flow diagram, static warnings, and an AI-powered plain-English analysis. Use compare mode to put two queries side by side and find out which one is better and why.

• Backend — Django, Django REST Framework
• Frontend — Next.js, TypeScript, Tailwind CSS
• Diagram — ReactFlow
• AI — Ollama

cd backend
python3 -m venv venv
source venv/bin/activate
pip install -r requirements.txt
cp .env.example .env
python manage.py migrate
python manage.py runserver

cd frontend
npm install
cp .env.local.example .env.local
npm run dev

Visit http://localhost:3000.

backend/.env

DJANGO_SECRET_KEY=your_secret_key
DEBUG=True
MOCK_MODE=False

frontend/.env.local

NEXT_PUBLIC_API_URL=http://localhost:8000

Set MOCK_MODE=True in your backend .env to run without using AI models. Useful for frontend development and testing.

• EXPLAIN metrics — integrate MySQL/PostgreSQL EXPLAIN output to surface real execution data: rows scanned, index usage, access type, filesort detection, and filtered row percentage
• Data size context — let users provide approximate row counts per table so the analysis can give quantitative cost estimates (e.g. "full table scan on ~500k rows")
• UI improvements — refine the layout, diagram interactions, and overall visual polish

MIT