Skip to the content
Know your tech before you buy it. Makers: get listed from $49/mo

utPLSQL

utplsql.org

  • Free plan
  • Windows
  • macOS
  • Linux
  • Self-hosted
7.4 Club score Visit utplsql.org

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

utPLSQL

Free

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.