Execute a SQL query against the PostgreSQL database. Returns the query results as text. Use LIMIT clauses on exploratory queries.

List all tables in the database with their schema, name, type, and owner.

Describe a table's columns, types, constraints, and indexes. Equivalent to psql \d+ command.

List all indexes in the database, optionally filtered by table name.

Show table sizes including data, indexes, and total. Sorted by total size descending.

Show table statistics including live/dead tuples, last vacuum/analyze times.

Show active database connections with their state, query, and duration.

Show current locks in the database with blocking information.

Show the query execution plan for a SQL query using EXPLAIN. Does not execute the query.

Show the total database size and individual table sizes.

Show estimated row counts for all tables, sorted by count descending.

List foreign key constraints, optionally filtered by table.

Show index usage statistics to identify unused or rarely used indexes.

Search for tables or columns matching a pattern. Useful for finding tables by name.