FREEDOM251

Freedom251 › Database Testing Tools

utPLSQL

Free plan LinuxMacSelf-hostedWindows

Visit utPLSQL Alternatives Pricing

utPLSQL's own site

What utPLSQL is

utPLSQL is an open-source toolkit 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. Annotations organize tests into nested suites, while matchers compare data such as objects, collections, and cursors. Configurable transaction control is intended to isolate tests and make them repeatable. Coverage reporting and multiple test-result formats support CI/CD pipelines, with integrations listed for 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 client runs on Windows, Linux, and Mac. Oracle Database 19c or newer is required; the installation guide says no additional licensed Oracle features are needed. The projects use the Apache 2.0 license. utPLSQL is free, with support channels including GitHub Discussions, Stack Overflow, and GitHub issues.

Who it suits

It suits developers writing automated tests for Oracle PL/SQL code, including teams that want coverage reporting or CI/CD integrations. It requires Oracle Database 19c or newer.

What it does well

  • Tests packages, procedures, triggers, views, and more
  • Matchers cover objects, collections, and cursors
  • Configurable transaction control supports test isolation
  • Coverage and multi-format result reporting are included
  • Free and licensed under Apache 2.0

What to know first

  • Requires Oracle Database 19c or newer
  • No free trial is listed

Limits

The free plan is the framework and tools for Oracle Database PL/SQL unit testing. It requires Oracle Database 19c or newer.

Plans

PlanBilled and limitsPrice
utPLSQLFree and open-source unit-testing framework and tools for Oracle Database PL/SQL codeFree

As utplsql.org lists them, read 3 Oct 2026. The maker's own page has the final word.

Getting started

  1. Visit https://utplsql.org/ for project information and downloads.
  2. Use the command-line client on Windows, Linux, or Mac, or choose a listed Maven, editor, Java, or .NET tool.
  3. Install Oracle Database 19c or newer; no extra licensed Oracle features are required.
  4. Arrange tests in annotated suites and use the framework to run them.

Verdict

utPLSQL offers testing, reporting, and developer tools for Oracle PL/SQL projects at no cost. Its database requirement makes it specific to environments running Oracle Database 19c or newer.

Questions

How much does utPLSQL cost?

It is free. The listed plan is free.

Is there a free trial?

No. utPLSQL is offered as a free plan.

Which database versions does it support?

The installation guide requires Oracle Database 19c or newer.

Which platforms can run its command-line client?

The download page says utPLSQL-cli can run from command lines on Windows, Linux, and Mac.

Is utPLSQL open source?

Yes. utPLSQL projects are licensed under Apache 2.0.

What integrations does it list?

The project lists SonarQube, Jenkins, TeamCity, Azure, and GitHub Actions.

Facts from utPLSQL's own pages

Comparison features
Matchers compare data, including complex types such as objects, collections, and cursors. · utplsql.org, 3 Oct 2026
Coverage and reporting
The framework includes code coverage reporting and multi-format test result reporting for CI/CD pipelines. · utplsql.org, 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. · utplsql.org, 3 Oct 2026
Integrations
The project lists integrations with SonarQube, Jenkins, TeamCity, Azure, and GitHub Actions. · utplsql.org, 3 Oct 2026
License
utPLSQL projects are licensed under Apache 2.0. · utplsql.org, 3 Oct 2026
Oracle requirement
The installation guide requires Oracle Database 19c or newer and says no extra licensed Oracle features are required. · github.com, 3 Oct 2026
Platform availability
The download page says utPLSQL-cli can run from command lines on Windows, Linux, and Mac. · utplsql.org, 3 Oct 2026
Project stewardship
The project describes itself as community-driven and says it is stewarded by utPLSQL Development Labs Ltd. · utplsql.org, 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. · utplsql.org, 3 Oct 2026
Test organization
Tests use annotations and can be organized into hierarchies of suites. · utplsql.org, 3 Oct 2026
Transaction control
Automatic configurable transaction control is intended to keep each test isolated and repeatable. · utplsql.org, 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. · utplsql.org, 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. · utplsql.org, 3 Oct 2026

Where utPLSQL stands on Freedom251

Look at these too