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

•

데이터베이스 관리

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.

주요 기능

Detailed report generation with specific fix or drop recommendations
Codebase usage analysis to identify active vs. orphaned functions
Automated categorization of issues by severity and impact
Multi-environment linting for local, staging, and production databases
1 GitHub stars
Deep integration with Supabase CLI and plpgsql_check

사용 사례

Identifying and safely removing unused legacy database functions to reduce technical debt
Troubleshooting runtime errors caused by schema migrations that broke existing function logic
Validating database integrity and function contracts before production deployments

소개

주요 기능

Detailed report generation with specific fix or drop recommendations
Codebase usage analysis to identify active vs. orphaned functions
Automated categorization of issues by severity and impact
Multi-environment linting for local, staging, and production databases
1 GitHub stars
Deep integration with Supabase CLI and plpgsql_check

사용 사례

Identifying and safely removing unused legacy database functions to reduce technical debt
Troubleshooting runtime errors caused by schema migrations that broke existing function logic
Validating database integrity and function contracts before production deployments