For the past months, I have been working on a simple idea around PostgreSQL tooling: before using AI, start with deterministic analysis. This is the direction behind pgAssistant 2.8 . This release introduces a new component called Global Advisor, alongside many improvements around ranking, schema analysis, maintenance diagnostics, and index recommendations. The project remains open-source and focused on practical PostgreSQL analysis. What is pgAssistant? pgAssistant is an open-source PostgreSQL analysis tool. It helps developers: inspect database structures analyze execution plans detect schema and maintenance issues review indexes and foreign keys understand PostgreSQL behavior more easily The project combines: deterministic analysis execution-plan analysis (EXPLAIN ANALYZE) optional AI-assisted reasoning The goal is not to replace PostgreSQL expertise. The goal is simply to make PostgreSQL diagnostics more accessible and more contextual.…