dependency_analysis
Assess dependencies between database objects - views, functions, triggers, sequences, and foreign data wrappers - across schemas and tables to understand impact before modifying or dropping objects.
Instructions
Comprehensive dependency analysis - views, functions, triggers, sequences, FDW.
LEVEL: Database ↔ Schema ↔ Table (multi-level tool)
schema='all': Database level - dependencies for ALL schemas
schema='': Schema level - dependencies in that schema (supports ANY schema name: 'sales', 'billing', 'auth', 'analytics', etc.)
table='users': Table level - what depends on this specific table
REQUIRED: Specify schema explicitly - use 'all' for all schemas or a specific schema name.
USE FOR: dependencies, views, functions, triggers, sequences, extensions, FDW, lineage, "what depends on this table?", "what views exist?", impact analysis before DROP. DO NOT USE FOR: table structure (use get_schema), index analysis (use maintenance_analysis), security permissions (use security_audit).
INCLUDE OPTIONS:
'all': Everything (default)
'views': Views, materialized views, view dependencies
'functions': User-defined functions, trigger functions
'triggers': Triggers on tables
'sequences': Sequences and their usage
'extensions': Installed PostgreSQL extensions
'fdw': Foreign data wrappers, foreign servers, foreign tables
Examples: dependency_analysis() - All dependencies in public schema (default) dependency_analysis(schema='all') - Database-wide analysis dependency_analysis(schema='billing') - Dependencies in billing schema dependency_analysis(table='users') - What depends on users table dependency_analysis(include='views') - Only view dependencies dependency_analysis(include='functions') - Only functions dependency_analysis(include='triggers') - Only triggers dependency_analysis(include='fdw') - Foreign data wrappers only
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| schema | No | Schema to analyze. Omit for all schemas, or specify one. Use get_schema() to list available. | |
| include | No | What to include: 'all', 'views', 'functions', 'triggers', 'sequences', 'extensions', 'fdw' | all |
| table | No | Optional: analyze dependencies for specific table | |
| format | No | Output format: 'json' or 'markdown' | json |
| url | No | Database URL for auto-connection | |
| summary_only | No | Return only summary counts, not detailed object lists |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |