db-lint-manager

Lint PostgreSQL functions against database schemas and generate categorized reports.

1|Updated Jan 8, 2026
One-click install
npx skills add https://github.com/JaveedIshaq/ai-workflow-orchestrator --skill db-lint-manager
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: db-lint-manager
Source: https://github.com/JaveedIshaq/ai-workflow-orchestrator/tree/main/skills/ballee/db-lint-manager
Command: npx skills add https://github.com/JaveedIshaq/ai-workflow-orchestrator --skill db-lint-manager

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill identifies and helps fix broken or unused PostgreSQL functions, preventing runtime errors and improving database maintainability.

Core Features & Use Cases

  • Linting Functions: Analyzes PostgreSQL functions against schema definitions to detect errors like missing columns or tables.
  • Usage Analysis: Checks if functions are referenced in the codebase or migrations, identifying unused functions.
  • Report Generation: Creates detailed reports categorizing issues by severity and providing recommended actions.
  • Use Case: Before deploying database changes, run this Skill to ensure all existing functions are valid and to identify any legacy functions that can be safely removed.

Quick Start

Run the db-lint-manager skill to lint the production database and generate a report.

Frequently Asked Questions about db-lint-manager

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I lint PostgreSQL functions against database schemas to detect errors?

You can lint PostgreSQL functions by analyzing them against schema definitions to detect errors such as missing columns, tables, or type mismatches before deployment. This process validates function health and prevents runtime errors.

What is the best way to find unused PostgreSQL functions in my codebase?

Finding unused PostgreSQL functions involves analyzing function usage within your codebase and migrations to identify unreferenced functions. This analysis categorizes issues by severity and provides actionable recommendations for dropping legacy functions safely.

How do I check if my PostgreSQL functions reference missing columns or tables before deploying?

Checking PostgreSQL functions before deployment involves running a linting analysis against your database schemas to detect missing columns or tables. It generates categorized reports with actionable recommendations for fixing broken functions.

Can I generate a report categorizing PostgreSQL function issues by severity?

Yes, you can generate detailed reports that categorize PostgreSQL function issues by severity and provide recommended actions. These reports identify both broken functions with schema mismatches and unused functions that can be safely removed.

Why does my PostgreSQL function fail after a database schema migration?

PostgreSQL functions fail after migrations when schema changes remove columns or tables that the functions reference. Linting functions against the updated database schema detects these type mismatches and missing dependencies before they cause runtime errors.

Do I need to run a database lint before deploying PostgreSQL schema changes?

Running a database lint before deploying PostgreSQL schema changes ensures all existing functions remain valid and identifies legacy functions for safe removal. This validates function health against the new schema and prevents runtime errors.