Launching in 15 Minutes.

I’m launching OptiSchema Slim on Product Hunt in 15 minutes 🚀

It’s a local-first, open-source tool for PostgreSQL performance, focused on validating index/query changes before applying them in production.

Here’s what it does (in plain terms):

1) Finds your actual slow queries (not the ones you think are slow):

Pulls real execution data from pg_stat_statements and ranks queries by total time, call frequency, and full-scan signals, so you optimize what’s actually burning CPU.

2) Verifies every index suggestion before you touch production:

Creates a virtual index (HypoPG), re-runs EXPLAIN, and shows the before/after estimated cost. No “trust me, add this index” , you see the delta.

3) Checks workload impact across other queries:

Tests your fix against ~20 other queries touching the same table, to catch the classic trap: speeding up one query while hurting others.

4) AI reasoning you can audit (not a black box):

Each recommendation includes a 0–100 confidence score + the concrete factors behind it (ex: “HypoPG verified 45% reduction”, “table has 2.3M rows”) + the LLM’s reasoning.

5) Batch changes into a single migration script:

Add suggestions to a cart, review them together, then apply in one transaction or export a timestamped .sql migration for your staging pipeline.

6) Runs entirely on your infrastructure:

Works with local Ollama (zero API calls) or cloud providers (DeepSeek/Gemini/OpenAI). Single Docker image, no telemetry, your schema + query patterns stay yours.

If you run Postgres in production, I’d genuinely value your feedback.

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