An automated SQL performance analyzer, schema linter, and query execution optimizer built for GitHub Actions. Parses raw SQL code or schema files, identifies structural anti-patterns, connects to ephemeral database containers (PostgreSQL / MySQL / MariaDB / SQL Server) or an in-memory SQLite engine, and evaluates query execution plans (EXPLAIN / SHOWPLAN) to flag sequential scans, disk sorts, and full table scans. BigQuery and Snowflake are supported for static dialect linting only.
Hey Product Hunt community! š
I built SQL Optima as a GitHub Action to automate SQL performance reviews directly inside CI/CD workflows.
Instead of relying on AI tools that can sometimes hallucinate, SQL Optima combines AST syntax parsing with real EXPLAIN execution plans on your database. It catches full table scans, missing indexes, and anti-patterns right in your Pull Requests before they hit production.
It's 100% open source, and Iād love to get your feedback, hear your thoughts, or receive contributions for new analyzer rules. Thanks for checking it out! š