{"repo":"SubhanHakverdiyev/OptimizeQL","free":true,"listed":false,"github":"https://github.com/SubhanHakverdiyev/OptimizeQL","clone":"git clone https://github.com/SubhanHakverdiyev/OptimizeQL.git","description":"OptimizeQL — AI-powered SQL query optimizer","language":"TypeScript","stars":33,"topics":["llm","mssql","optimize","postgresql","sql","database","ai","devtools","explain-analyze","hypopg"],"license":"MIT","category":"databases-storage","readme_excerpt":"# 🔍 OptimizeQL — Your SQL Assistant AI-powered SQL query optimizer that analyzes EXPLAIN plans and suggests indexes, rewrites, and configuration changes. 🚀 Quick Start · ✨ Features · ⚙️ Configuration · 🤝 Contributing --- --- ✨ Features - 🔬 EXPLAIN ANALYZE introspection — connects to your PostgreSQL or MySQL database, runs EXPLAIN ANALYZE, and gathers schema, indexes, and column statistics automatically - 🤖 Multi-provider LLM analysis — supports Anthropic, OpenAI, Gemini, DeepSeek, xAI, Qwen, Meta Llama, Kimi, and OpenRouter out of the box - 💡 Actionable suggestions — returns CREATE INDEX statements, query rewrites, materialized views, statistics recommendations, and config tuning with estimated impact levels - 🧪 HypoPG index simulation — create virtual/hypothetical indexes using PostgreSQL's HypoPG extension and compare EXPLAIN plans before vs. after — no real indexes created, zero risk - 🔀 Query comparison — compare two SQL queries side-by-side to see which performs better with detailed analysis - 📊 Interactive dashboard — landing page with query activity charts, category breakdowns, optimization streaks, and most-analyzed tables - ✏️ Monaco SQL editor — full-featured code editor with SQL syntax highlighting, autocomplete, and theme-aware styling - 🌙 Dark mode — system-aware dark theme with manual toggle, persistent preference, and zero-FOUC loading - 🔐 Encrypted credential storage — all database passwords and API keys are encrypted with Ferne","default_branch":null,"files":null,"tree":[],"storefront":"/r/SubhanHakverdiyev","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/SubhanHakverdiyev/OptimizeQL/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}