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.

The main addition in 2.8: Global Advisor

Before…