Schema Discovery

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

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

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...

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

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

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

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

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

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