Execute SQL with pagination and parameterization

Get table structure including columns, constraints, and size statistics

List tables, views, or functions in a schema

List all schemas in the database

List indexes for a table or schema

Get query execution plan (EXPLAIN)

Find tables, columns, functions, views by name pattern across schemas

Show active database connections, utilization, and idle-in-transaction warnings

Composite database health check: cache, connections, vacuum, indexes, sequences

Analyze slow queries via pg_stat_statements with filtering and sorting

List partitioned tables and monitor partition pruning efficiency (PostgreSQL 12+)

Monitor logical replication: publications, subscriptions, and lag (PostgreSQL 13+)

Monitor progress of VACUUM, ANALYZE, CLUSTER, and CREATE INDEX operations

Monitor WAL size, growth, archive status, and replication slots

List extended statistics and provide recommendations for multi-column correlations

Identify B-tree indexes that can benefit from deduplication (PostgreSQL 13+)

List generated columns and monitor their dependencies (PostgreSQL 12+)

Analyze JSONB columns and recommend GIN indexes for better performance

Monitor parallel query worker usage and performance

Analyze autovacuum effectiveness and recommend tuning settings

Monitor huge pages usage and provide configuration recommendations

Enhanced pg_stat_statements analysis with parallel workers and WAL tracking

Monitor foreign key performance and identify missing indexes

Monitor pg_basebackup progress and PITR recovery timeline

List installed extensions, check compatibility, and view dependencies

Monitor HikariCP connection pool metrics, detect connection leaks, and track wait times

Validate database schema against JPA/Hibernate entity mappings

Analyze ORM query performance, detect N+1 problems, and identify lazy loading issues

Monitor active transactions, isolation levels, and detect long-running transactions

Analyze prepared statement cache hit ratio and query patterns

Track Flyway/Liquibase migrations, detect schema drift, and validate checksums

Analyze index coverage for ORM @Query annotations and recommend missing indexes

Analyze JSONB columns for @Convert entity attributes and recommend GIN indexes

Monitor JDBC batch operation performance and efficiency

Monitor sequences for JPA @GeneratedValue and detect exhaustion risks

Recommend partitioning strategies for time-series entity tables

Detect connection leaks and analyze connection acquisition patterns

Analyze deadlock patterns and lock wait information

Validate Spring Data JPA annotations against database schema

Establish and monitor performance baselines for ORM CRUD operations