🔥 SlowQL

Catch Expensive SQL Before Production

Static SQL analyzer with a cyberpunk aesthetic.
Detects 50+ performance killers, security risks, and anti‑patterns before they cost you money.

---

🚀 Vision

SlowQL isn’t just another linter. It’s a billion‑dollar safeguard for data‑driven companies:

• Prevent catastrophic table wipes before they hit prod.
• Slash cloud bills by eliminating full‑table scans.
• Harden pipelines against SQL injection and anti‑patterns.
• Deliver instant credibility in CI/CD with cinematic, cyberpunk‑styled reports.

---

🔗 Badges

📦 Package & Release

📊 Downloads

🧪 Tests & Quality

🔒 Security & Dependencies

📣 Community

---

---

⚡ Quick Start

pip install slowql
slowql --input-file your_queries.sql

Or analyze queries interactively:

slowql --mode paste

---

🎯 What It Catches

Severity	Issue	Impact
🚨 CRITICAL	DELETE/UPDATE without WHERE	Prevents accidental table wipes
🔥 HIGH	Non‑SARGable queries	Forces full table scans instead of index seeks
🔥 HIGH	Leading wildcards (LIKE '%x')	Prevents index usage
💫 MEDIUM	SELECT * usage	Unnecessary data transfer, prevents covering indexes
💠 LOW	Unnecessary DISTINCT	Adds sorting overhead

50+ detectors total covering performance, security, and maintainability.

---

📊 Example

slowql --input-file examples/nasty_queries.sql

╔═══════════════════════════════════════════════╗
║     SQL Analysis Results                      ║
╚═══════════════════════════════════════════════╝

Found 46 optimization opportunities
Across 21 different issue types

🚨 CRITICAL: 2
🔥 HIGH    : 8  
💫 MEDIUM  : 7
💠 LOW     : 4

🔴 CRITICAL: Missing WHERE in UPDATE/DELETE
   Query: DELETE FROM users
   Fix: Add WHERE clause or use TRUNCATE if intentional
   Impact: Can delete/update entire table accidentally

---

🚀 Features

• Cyberpunk CLI — cinematic terminal output with optional Matrix intro
• Multiple formats — export to HTML, JSON, or CSV
• CI/CD ready — --fast --non-interactive for pipelines
• Database‑free — analyzes SQL strings statically

---

📖 Usage

Analyze a file

slowql --input-file queries.sql --export html

Interactive mode

slowql
# Paste your SQL, press Ctrl+D when done

CI/CD integration

slowql --input-file schema.sql --export json --fast --non-interactive

Python API

from slowql.core.analyzer import QueryAnalyzer

analyzer = QueryAnalyzer()
results = analyzer.analyze("SELECT * FROM users WHERE id = 1")
print(results)

---

🛠️ Installation

Recommended (isolated):

pipx install slowql

Standard:

pip install slowql

From source:

git clone https://github.com/makroumi/slowql
cd slowql
pip install -e .

---

🧪 Development

pip install -e '.[dev]'
pytest
pytest --cov=slowql

---

📝 License

Apache 2.0 — see LICENSE

---

🤝 Contributing

Issues and PRs welcome! Please run tests before submitting.
For major changes, open a discussion first.

---

Built by @makroumi
📢 Report Issues