List all schemas in the database

List objects in a schema

Show detailed information about a database object

Explains the execution plan for a SQL query, showing how the database will execute it and provides detailed cost estimates.

Analyze frequently executed queries in the database and recommend optimal indexes

Analyze a list of (up to 10) SQL queries and recommend optimal indexes

Analyzes database health. Here are the available health checks:

• index - checks for invalid, duplicate, and bloated indexes

• connection - checks the number of connection and their utilization

• vacuum - checks vacuum health for transaction id wraparound

• sequence - checks sequences at risk of exceeding their maximum value

• replication - checks replication health including lag and slots

• buffer - checks for buffer cache hit rates for indexes and tables

• constraint - checks for invalid constraints

• all - runs all checks You can optionally specify a single health check or a comma-separated list of health checks. The default is 'all' checks.

Reports the slowest or most resource-intensive queries using data from the 'pg_stat_statements' extension.

Execute any SQL query

Execute a SQL file containing migration scripts or DDL statements. The entire file is executed as a single transaction - all changes are rolled back if any statement fails. Only available in unrestricted access mode.