PostgresAI 💙💛

pg_ash is out github.com/NikolayS/pg_ash Postgres has no session history. When something was slow an hour ago, there's nothing to look at. pg_ash fixes that -- pure SQL, one file install, works on RDS/Cloud SQL/Supabase/self-hosted, anywhere where you have pg_stat_statements and pg_cron. No extension, no restarts, no provider approval. Just \i one file. 1s sampling, ~100-200 bytes per second,~20-30 MiB of raw data written per day, with bloat-free partition rotation (tribute to Skype's PGQ). AND: 32 functions designed to perform RCA -- friendly both to humans and AI. Check out an LLM-assisted investigation example here: https://lnkd.in/gzEUCASB // self-driving Postgres is the future of Postgres

postgresai 0.14 is out! Express health checks via `postgresai checkup`, Claude Code plugin, Supabase support, MCP tools, Bun for performance, query texts in Top-N charts, version/build timestamps, updated index analysis panels, and much more start here: npx postgresai@latest

Check your DB for unused/redundant indexes now, keep your index set lean: npm i -g postgresai postgresai checkup <DBURL> --json --check-id H002 # unused indexes postgresai checkup <DBURL> --json --check-id H004 # redundant indexes -- then feed it to your AI dev tool 🪄

The hidden cost of invalid indexes in Postgres (yes, even on Supabase/RDS/Neon) https://lnkd.in/gnQ_tBCH

PostgresAI demo 2 - automated database health What if you clicked "Resolve" and got a PR What if index bloat just... fixed itself? Now it does.

postgres_ai monitoring v0.13: k8s support, new dashboard "13. Lock contention", passwordless login from Console.Postgres.ai (Oauth with org verification), many fixes and improvements GitHub: https://lnkd.in/gcGcbWiZ GitLab: https://lnkd.in/g5K2EPQG

Reminder: DBLab Engine is available in AWS Marketplace Testing schema changes in production? Optimizing queries by guessing? Database branching solves this: - Instant preview environments - Safe query optimization - 100% CI coverage for DB changes

postges_ai monitoring 0.12: SLRU, MultiXact member space exhaustion, many improvements and fixes GitHub: https://lnkd.in/gtQWe9Bw GitLab: https://lnkd.in/g5K2EPQG

Stop fighting Postgres issues. Keep shipping features. Introducing new PostgresAI, it takes care of your Postgres. Removes unused and redundant indexes, mitigates bloat — all automated with PR-based approvals for full control. Early access: http://postgres.ai