List all available database schemas (excluding system schemas like pg_catalog and information_schema)

List all tables and views in a given schema with estimated row counts, sizes, and comments

Get full structural details of a table as CREATE TABLE DDL, including columns, data types, constraints, foreign keys, and indexes

List foreign key relationships between tables to understand data model associations and joins

List indexes on tables with sizes and scan usage statistics to evaluate index health

Analyze query patterns, scan ratios, and missing foreign key indexes to provide index recommendations

Execute a safe read-only SQL query (SELECT, WITH, SHOW) with strict LIMIT enforcement and formatting

Get query execution plan via PostgreSQL EXPLAIN (or EXPLAIN ANALYZE) to debug performance bottlenecks

Get high-level PostgreSQL database runtime information: version, size, active connection count, and server settings

Get scan statistics, tuple counts, dead row accumulation, and maintenance history for tables

Retrieve top slowest queries recorded by pg_stat_statements extension (if enabled in PostgreSQL)

List installed PostgreSQL extensions with version information and specialized framework detection (PostGIS, TimescaleDB, pgvector)