OptiSchema Slim
Local-first AI PostgreSQL tuning with ‘what-if’ indexes
What it does
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.
Does the same job
all alternatives →
- SDSnapQL – Desktop app to query Postgres with AI2025 · github.com · ▲104
SnapQL is an open-source desktop app (built with Electron) that lets you query your Postgres database using natural language. It’s schema-aware, so you don’t need to copy-paste your schema or write complex SQL by hand. Everything runs locally — your OpenAI API key, your data, and your queries — so it's secure and private. Just connect your DB, describe what you want, and SnapQL writes and runs the SQL for you.
- PIPostgreSQL index advisor2024 · github.com · ▲417
This is a Postgres extension that can determine if a query should have an index. For example, for this table: create table book( id int primary key, title text not null ); You can run `index_advisor()` to see if there should be an index on a select statement: select * from index_advisor('select book.id from book where title = $1'); And it will return (summarized): {"CREATE INDEX ON public.book USING btree (title)"} It works particularly well with pg_stat_statements[0] which tracks execution statistics of all SQL statements executed on your Postgres database. It leans heavily on HypoPG[1], an…
- PEPostgres extension for BM25 relevance-ranked full-text searchMar 2026 · github.com · ▲203
Last summer we faced a conundrum at my company, Tiger Data, a Postgres cloud vendor whose main business is in timeseries data. We were trying to grow our business towards emerging AI-centric workloads and wanted to provide a state-of-the-art hybrid search stack in Postgres. We'd already built pgvectorscale in house with the goal of scaling semantic search beyond pgvector's main memory limitations. We just needed a scalable ranked keyword search solution too. The problem: core Postgres doesn't provide this; the leading Postgres BM25 extension, ParadeDB, is guarded behind AGPL; developing our…
More dev tools this month
the category →
The first open-source price index for GPU compute
Dev tools · 10d ago · getcomputable.com
OpenTrailPaper is open-source bike computer firmware for the LilyGO T5S3 4.7" E-Paper PRO. It supports offline maps, GPX routes, FIT recording and Bluetooth sensors.
Dev tools · 2d ago · opentrailpaper.com
Open-source GTM skills for technical founders
Dev tools · 29d ago · gtmcofounder.com
