🔍 MySQLens
AI-powered MySQL performance optimization tool
See clearly. Optimize confidently.
Features • Quick Start • Docs • GitHub
💡 What is MySQLens?
MySQLens is a production-ready MySQL performance optimization tool that combines real-time monitoring with AI-powered analysis. It helps database administrators and developers:
- 🎯 Identify slow queries and performance bottlenecks
- 🤖 Get AI-powered optimization recommendations using OpenAI, Gemini, or local Ollama
- 🔍 Detect unused and redundant indexes wasting disk space
- 📊 Monitor database health in real-time
✨ Key Features
| Feature | Description |
|---|---|
| 🔐 Privacy-First | Run AI analysis locally with Ollama - no data leaves your machine |
| 🎯 Real-time Monitoring | Live metrics for QPS, connections, buffer pool, and more |
| 🤖 Multi-LLM Support | OpenAI, Gemini, DeepSeek, or local Ollama |
| 📈 Index Intelligence | Detect unused, duplicate, and missing indexes |
| 🐳 Docker-Ready | One-command deployment with Docker Compose |
| 🌐 Remote MySQL | Connect to any MySQL instance (local, cloud, RDS) |
🚀 Quick Start
# Clone the repository
git clone https://github.com/a-kash-singh/mysqlens.git
cd mysqlens
# Configure LLM (Ollama for privacy, or cloud APIs)
echo "LLM_PROVIDER=ollama
OLLAMA_BASE_URL=http://host.docker.internal:11434
OLLAMA_MODEL=llama3.2:latest" > .env
# Start MySQLens
docker compose up -d
# Open in browser
open http://localhost:3000
📖 Need more details? Check out the complete Quick Start Guide.
🏗️ Architecture
┌─────────────────┐ ┌─────────────────┐ ┌─────────────────┐
│ Next.js 15 │─────▶│ FastAPI │─────▶│ MySQL DB │
│ Frontend │ │ Backend │ │ (Your DB) │
│ (Port 3000) │◀─────│ (Port 8080) │◀─────│ │
└─────────────────┘ └─────────────────┘ └─────────────────┘
│
▼
┌──────────────┐
│ LLM APIs │
│ (AI Power) │
└──────────────┘
📚 Documentation
- 🚀 Quick Start Guide - Get started in 5 minutes
- 🤖 Ollama Setup - Local LLM configuration
- 🏗️ Architecture - System design and tech stack
- 📡 API Reference - Complete API documentation
More on GitHub:
- 📖 Full README - Complete documentation
- 🚢 Deployment Guide - Production deployment
- 📋 Contributing - How to contribute
🙏 Acknowledgments
This project is inspired by OptiSchema-Slim - an excellent PostgreSQL performance optimization tool by @arnab2001.
**Built with 🔍 for better MySQL performance**