ClearSQL

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.

We are excited to announce the release of ClearSQL 9, featuring dramatic changes in the application's UI&UX. We completely reorganized all the menus and toolbars around the app, making it easier to reach frequently-used options and perform typical usage scenarios. ClearSQL now also supports several color themes, adjusting the UI elements to the light and dark mode on the fly.The optimized search engine can now find whatever you are looking for, be it a code element, script, code review rule, diagram block, or even application option, while the new smart filter helps find scripts and code analysis results, especially in huge projects, instantly filtering the project tree by script statuses and names.Code analysis can now be started much faster: just choose PL/SQL scripts from the disk, and wait until the analysis completes. Oracle Instant Client and Visual C++ Redistributable Packages are now installed along with the app, so no additional configurations are now needed to set up a database connection.As you start using the new version, a feature tour will guide you around the new options and help you run your first code analysis.