utPLSQL
utPLSQL is a free, open-source framework and toolset for writing and running automated unit tests for Oracle Database PL/SQL code.
What utPLSQL is
utPLSQL is a free, open-source framework and toolset for writing and running automated unit tests for Oracle Database PL/SQL code. It can test packages, functions, procedures, triggers, views, and other code that PL/SQL can execute and observe. Tests use annotations and can be arranged into suite hierarchies. Matchers compare data, including objects, collections, and cursors, while configurable transaction control is intended to keep tests isolated and repeatable. Coverage reporting and multiple test-result formats support CI/CD pipelines. Listed integrations include SonarQube, Jenkins, TeamCity, Azure, and GitHub Actions. Developer tools include a command-line client, Maven plugin, SQL Developer and PL/SQL Developer extensions, and Java and .NET APIs. The command-line client runs on Windows, Linux, and Mac. The installation guide requires Oracle Database 19c or newer and says no additional licensed Oracle features are needed. Projects use the Apache 2.0 license. For questions and support, the project points users to GitHub Discussions and Stack Overflow; bugs and feature requests can be filed as GitHub issues.
Good
- Tests PL/SQL packages, procedures, triggers, and views.
- Supports suite hierarchies and configurable transaction control.
- Includes coverage and multi-format test-result reporting.
- Integrates with several CI/CD platforms.
- Free and licensed under Apache 2.0.
Watch out
- Requires Oracle Database 19c or newer.
- Focused on code executed and observed from PL/SQL.
Who it suits
utPLSQL suits developers who write PL/SQL for Oracle Database and want automated unit tests, coverage reports, and CI/CD result formats. It requires Oracle Database 19c or newer.
Verdict
utPLSQL offers a focused testing toolset for Oracle PL/SQL, with data matchers, transaction controls, coverage, and developer integrations. Its database requirement makes Oracle Database 19c or newer a prerequisite.
Plans and prices
From utPLSQL's own pricing page, checked 3 Oct 2026.
| Plan | Price | What it gives you |
|---|---|---|
| utPLSQL | Free | Free and open-source unit-testing framework and tools for Oracle Database PL/SQL code |
The facts
Each one read from utPLSQL's own pages, with the date it was checked.
What it does
- Comparison features
- Matchers compare data, including complex types such as objects, collections, and cursors.checked 3 Oct 2026
- Coverage and reporting
- The framework includes code coverage reporting and multi-format test result reporting for CI/CD pipelines.checked 3 Oct 2026
- Developer tools
- The project offers a command-line client, Maven plugin, SQL Developer and PL/SQL Developer extensions, and Java and .NET APIs.checked 3 Oct 2026
- Integrations
- The project lists integrations with SonarQube, Jenkins, TeamCity, Azure, and GitHub Actions.checked 3 Oct 2026
- License
- utPLSQL projects are licensed under Apache 2.0.checked 3 Oct 2026
- Oracle requirement
- The installation guide requires Oracle Database 19c or newer and says no extra licensed Oracle features are required.checked 3 Oct 2026
- Project stewardship
- The project describes itself as community-driven and says it is stewarded by utPLSQL Development Labs Ltd.checked 3 Oct 2026
- Support
- The project directs users to GitHub Discussions for questions and support, Stack Overflow under the utplsql tag, and GitHub issues for bugs or feature requests.checked 3 Oct 2026
- Test organization
- Tests use annotations and can be organized into hierarchies of suites.checked 3 Oct 2026
- Transaction control
- Automatic configurable transaction control is intended to keep each test isolated and repeatable.checked 3 Oct 2026
- What can be tested
- It supports testing PL/SQL packages, functions, procedures, triggers, views, and other code that can be executed and observed from PL/SQL.checked 3 Oct 2026
- What it does
- utPLSQL is a set of open-source frameworks and tools for writing and running automated unit tests for Oracle Database PL/SQL code.checked 3 Oct 2026
Where it runs
- Platform availability
- The download page says utPLSQL-cli can run from command lines on Windows, Linux, and Mac.checked 3 Oct 2026
Alternatives to utPLSQL
- 1
Atlas
Free planOpen sourceWebAPILinuxmacOS8.3From $39 a month - 2
DataKitchen TestGen
Free planOpen sourceWebAPILinuxmacOS8.1From $100 a month - 3
Soda
Free planWebAPILinuxSelf-hosted7.5From $750 a month - 4
Avidemux
Free planOpen sourceWebLinuxmacOSWindows7.3Free plan - 5
pgroll
Free planOpen sourceLinuxmacOSSelf-hostedWindows7.3Free plan - 6
Bytebase Enterprise
Free planWebAPISelf-hosted6.8From $20 a month