plpgsql_check
A PostgreSQL extension that performs static analysis and linting for PL/pgSQL stored procedures.
What is plpgsql_check?
plpgsql_check is a PostgreSQL extension that performs static code analysis on PL/pgSQL stored procedures and functions. It identifies semantic errors, performance issues, security vulnerabilities, and code quality problems before runtime execution. The tool leverages PostgreSQL's internal parser to ensure findings match what would actually occur during function execution.
PostgreSQL database developers and administrators who write and maintain PL/pgSQL stored procedures, particularly those working on large codebases where manual code review is insufficient.
Unlike basic syntax checking, plpgsql_check performs deep semantic analysis using PostgreSQL's own evaluation engine, catching errors that CREATE FUNCTION commands miss. It provides configurable warning levels, pragma directives for fine-grained control, and supports both active checking via function calls and passive checking during development.
Overview
plpgsql_check is a linter tool (does source code static analyze) for the PostgreSQL language plpgsql (the native language for PostgreSQL store procedures).
Use Cases
Best For
- Identifying semantic errors in PL/pgSQL functions before deployment
Related Projects
Found a gem we're missing?
Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.
