Database Linting and Analysis for PostgreSQL

Summary

PG Linter Documentation In recent years, DBAs were more involved with the database engine itself: creating instances, configuring backups, and monitoring systems and also, overseeing developers' activities. Today, in the DBRE world where databases are cloud-managed, developers and operations teams often work independently, without a dedicated DBA. So databases objects lives their own life, created by persons that do their best. It can be usefull to be able to detect some wrong desing creation (for example foreign keys created accross differents schemas...). That's what pglinter was created for. This extension is not designed for DBAs who often have their own tools and scripts to detect those potential problems, but for developers, operations teams, or CI pipelines that do not have deep knowledge on database best practices. Database linting and analysis for PostgreSQL pglinter is a PostgreSQL extension that analyzes your database for potential issues, performance problems, and best practice violations. Written in Rust using pgrx, it provides deep integration with PostgreSQL for efficient database analysis. The project has a rule-based approach to database analysis. This means you can enable or disable specific rules and configure thresholds to match your organization's standards and requirements. The main goal of this extension is to offer database quality by design. We believe that database analysis should be integrated into your development workflow, allowing teams to catch potential issues early in the development cycle. Key Features Performance Analysis: Detect unused indexes, missing indexes. Schema Validation: Check for proper primary keys, foreign key indexing, and schema design Security Auditing: Identify potential security risks and configuration issues SARIF Output: Industry-standard reporting format compatible with modern CI/CD tools Configurable Rules: Enable/disable rules and adjust thresholds based on your needs Rule Categories PG Linter organizes its a...