PostgreSQL

Get information about the connected database. Returns comprehensive database information including: - PostgreSQL version - Database name and size - Current user and schema - Server encoding and timezone - Connection limits and active connections

List installed PostgreSQL extensions. Returns all extensions currently installed in the database. Returns: List of extensions with: - Extension name and version - Schema where installed - Description

Get statistics for a table. Returns detailed statistics about table usage and maintenance. Args: - table: Table name (required) - schema: Schema name (default: 'public') Returns: Table statistics including: - Live and dead tuple counts - Last vacuum/analyze timestamps - Sequential and index scan counts - Insert/update/delete counts

List functions and procedures in a schema. Args: - schema: Schema name (default: 'public') Returns: List of functions with: - Function name and type (function, procedure, aggregate, window) - Arguments and return type - Volatility (IMMUTABLE, STABLE, VOLATILE) - Language (SQL, plpgsql, etc.)