Made a Postgres performance tool because reading EXPLAIN plans got old

Working on Optischema-Slim - a tool that helps you optimize PostgreSQL without needing to be a database expert.

The idea: most teams have slow queries but don't know why. Reading EXPLAIN plans is painful, and guessing at indexes usually makes things worse.

So we built something that:

• Explains query plans in plain English (not cryptic node types)

• Suggests indexes that actually help (simulates them first)

• Rewrites queries when there's a better way

• Scans for common issues (bloat, missing vacuums, lock contention)

We use LLMs under the hood, but the tricky part was making sure the AI doesn't suggest something dangerous. Recently spent weeks adding validation layers - blocking risky functions, checking SSL properly, making sure it understands your schema before suggesting changes.

Also added 64 tests because "AI touching production databases" without guardrails is terrifying.

It's open source. Not trying to sell anything - just scratching our own itch since we kept running into slow queries and didn't want to manually dig through pg_stat_statements every time.

If you work with Postgres and deal with performance issues, would love feedback.

https://www.producthunt.com/products/optischema-slim?launch=optischema-slim