OptiSchema Slim

Local-first AI PostgreSQL tuning with ‘what-if’ indexes

2 followers

Local-first AI PostgreSQL tuning with ‘what-if’ indexes

2 followers

Visit website

Databases and backend frameworks

•

AI Infrastructure Tools

•

AI Databases

OptiSchema Slim is a local-first AI tool for PostgreSQL performance. A Health Doctor to scan for bloat, unused indexes, slow queries, and high-impact workload issues with configurable thresholds, scan history, and deterministic scoring with AI explanations. Drill into expensive queries, get EXPLAIN plan breakdowns, test “what-if” index ideas, compare before/after plans with estimated cost, and copy the SQL.

Free

Launch tags:Open Source•Developer Tools•GitHub

Launch Team / Built With

Tines — The intelligent workflow platform

The intelligent workflow platform

Promoted

Maker

📌

Hello PH, I built OptiSchema Slim because Postgres tuning kept turning into: notice slowness late → stare at EXPLAIN → guess an index → build it → hope. OptiSchema Slim is local-first and includes a Health Doctor (configurable thresholds for bloat/unused indexes/slow queries/workload impact, scan history, and a deterministic score with AI explanations). You can drill into a query, see an AI plan breakdown, and try “what-if” index ideas to compare before/after plans + estimated cost, then copy the SQL. If you try it: what would you need to trust recommendations more, runtime proof (EXPLAIN ANALYZE), clearer diffs, or something else?

Report

6d ago

Absolutely gem project Arnab. Loved the idea.

Report

5d ago