Is this skill specific to Supabase?

While it is optimized for Supabase CLI commands and patterns, its logic for PostgreSQL function linting and usage analysis can be adapted for other PostgreSQL environments.

Does this skill automatically modify my database schema?

No, the skill strictly follows a 'Report Only' rule. It will analyze and recommend fixes but will never generate or apply migrations without your explicit approval.

What types of errors does the lint manager detect?

It identifies missing columns, missing tables, type mismatches between queries and return types, ambiguous references, and unused variables.

Can it detect if a function is used in my frontend code?

Yes, it searches your codebase for RPC calls and SQL references to determine if a function is actively used before suggesting any actions.

Database Function Lint Manager

Name: Database Function Lint Manager
Author: antoineschaller

byantoineschaller

•

Gestión de Bases de Datos

Lints PostgreSQL functions, analyzes codebase usage, and generates actionable maintenance reports to ensure database integrity.

The Database Function Lint Manager is a specialized tool for maintaining PostgreSQL database health by identifying broken functions and cross-referencing them with application code. It helps developers detect critical issues like missing column references, relation errors, and type mismatches across local, staging, and production environments. By analyzing actual usage patterns in TypeScript or JavaScript files, it distinguishes between high-priority fixes and safe-to-drop legacy functions, providing a structured workflow for database cleanup and pre-deployment validation.

Características Principales

01Detailed report generation with specific fix or drop recommendations

02Codebase usage analysis to identify active vs. orphaned functions

03Automated categorization of issues by severity and impact

04Multi-environment linting for local, staging, and production databases

051 GitHub stars

06Deep integration with Supabase CLI and plpgsql_check

Casos de Uso

01Identifying and safely removing unused legacy database functions to reduce technical debt

02Troubleshooting runtime errors caused by schema migrations that broke existing function logic

03Validating database integrity and function contracts before production deployments

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add antoineschaller/cortex-skills ballee

For use in Claude.ai and ChatGPT

Download Skill