plpgsql_check is a powerful extension that serves as a comprehensive linter for PL/pgSQL in PostgreSQL. By utilizing the internal PostgreSQL parser, it identifies potential runtime errors, semantic issues, and performance concerns in your PL/pgSQL code, ensuring that developers can write more robust and efficient functions with ease.
Runtime error detection using the internal PostgreSQL parser
Semantic validation of embedded SQL statements
Customizable warning levels and hints through PRAGMA markers
Detection of unused variables, dead code, and missing RETURN statements
SQL injection vulnerability checks on EXECUTE statements
Support for PostgreSQL versions 12 to 17