Schema Discovery

List PostgreSQL stored procedures and functions with their parameters, return types, and definitions. Useful for understanding database logic and stor...

Find all database objects that depend on a table: views, materialized views, triggers, and functions. Critical before dropping or altering tables.

Search PostgreSQL database using SQL queries or structured syntax. Returns ranked results with IDs and titles. Supports SELECT statements and table br...

Get compact, token-efficient database schema description optimized for AI text-to-SQL. Returns tables with columns, types, relationships, and sample v...

List PostgreSQL tables with rich filtering and metadata options. Supports pattern matching, schema filtering, and optional inclusion of columns, relat...

Find tables that are not referenced by foreign keys, views, materialized views, or functions. Useful for identifying orphaned tables that may be safe ...

Find columns with enum-like behavior (limited distinct values) and show value frequencies. Useful for understanding categorical data and identifying c...

Build a graph representation of foreign key relationships showing which tables reference which other tables. Returns nodes (tables) and edges (FK rela...

List PostgreSQL triggers with their event types (INSERT, UPDATE, DELETE), timing (BEFORE, AFTER), and action statements. Essential for understanding d...

Inspect PostgreSQL schema or table in detail. Get comprehensive information about tables, columns, relationships, indexes, and constraints.