utPLSQL
utplsql.org
- Free plan
- Windows
- macOS
- Linux
- Self-hosted
What utPLSQL is
utPLSQL is a free, open-source framework and toolset for automated unit testing of Oracle Database PL/SQL code. It can test packages, functions, procedures, triggers, views and other executable PL/SQL code. Tests use annotations and can be arranged in suite hierarchies. Matchers compare data types including objects, collections and cursors, while configurable transaction control is intended to keep tests isolated and repeatable. The project includes code coverage reporting and multiple result formats for CI/CD pipelines. Listed integrations include SonarQube, Jenkins, TeamCity, Azure and GitHub Actions. Developers can use a command-line client, Maven plugin, SQL Developer and PL/SQL Developer extensions, plus Java and .NET APIs. The command-line tool runs on Windows, Linux and Mac. Oracle Database 19c or newer is required, with no extra licensed Oracle features required. Projects use Apache 2.0 licensing.
Who it suits
utPLSQL suits developers and database teams testing Oracle PL/SQL code in automated workflows. It is intended for environments running Oracle Database 19c or newer.
Good to know, and what to watch
- Free and open-source under Apache 2.0
- Tests packages, procedures, triggers and views
- Coverage and multi-format CI/CD reporting
- Integrations include Jenkins and GitHub Actions
- Command-line tool runs on Windows, Linux and Mac
- Requires Oracle Database 19c or newer
- Focused on Oracle Database PL/SQL code
- No free trial distinction because it is free
Plans
Every plan and priceutPLSQL
Free plan
The verdict
utPLSQL provides testing, isolation, coverage and reporting tools for Oracle PL/SQL projects. Its integrations and developer interfaces support command-line and CI/CD workflows, provided the required Oracle version is available.
What the maker publishes
- Comparison features
- Matchers compare data, including complex types such as objects, collections, and cursors. source
- Coverage and reporting
- The framework includes code coverage reporting and multi-format test result reporting for CI/CD pipelines. source
- Developer tools
- The project offers a command-line client, Maven plugin, SQL Developer and PL/SQL Developer extensions, and Java and .NET APIs. source
- Integrations
- The project lists integrations with SonarQube, Jenkins, TeamCity, Azure, and GitHub Actions. source
- License
- utPLSQL projects are licensed under Apache 2.0. source
- Oracle requirement
- The installation guide requires Oracle Database 19c or newer and says no extra licensed Oracle features are required. source
- Platform availability
- The download page says utPLSQL-cli can run from command lines on Windows, Linux, and Mac. source
- Project stewardship
- The project describes itself as community-driven and says it is stewarded by utPLSQL Development Labs Ltd. source
- 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. source
- Test organization
- Tests use annotations and can be organized into hierarchies of suites. source
- Transaction control
- Automatic configurable transaction control is intended to keep each test isolated and repeatable. source
- 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. source
- 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. source
Checked against the maker's pages on 3 Oct 2026.