ClearSQL is a PL/SQL code analyzer with advanced functionality for code review, editing, and formatting, quality control, and system optimization. It generates interactive visuals and delivers comprehensive analysis reports, outlining flaws in the code syntax and structure. It is a 32- and 64-bit Windows tool supporting Oracle databases up to 18c. ClearSQL checks code against a set of predefined rules and raises alerts when detects violations. The rules are based on industry standards and best programming practices. Insignificant mistakes are fixed automatically. ClearSQL draws diagrams (Flowcharts and Call Trees) and matrices (CRUD) based on relations between code elements, indicating potentially problematic areas and revealing the database structure. It also creates interactive flowcharts based on code comments, making technical processes easy to understand by other stakeholders. ClearSQL measures maintainability, complexity, and readability of PL/SQL software. Indicators help spot poor programming practices and outline optimization strategy. ClearSQL automates code analysis and exports the results into portable formats. Scheduled to run regularly, automated code reviews are easily integrated into QA sessions from early stages of product development. ClearSQL provides the interface to import PL/SQL scripts and safely modify them without committing to production as well as track changes made to the code by comparing different versions of same scripts.
