Live activity, then drill down
Top Activity, system load, sessions, waits and SQL. Select a period on a chart and the tables follow; click a row to open the SQL, its plan, the session or the object.
Public beta · Oracle 11.2+ · PostgreSQL 13+
OPA-PA is a desktop performance analyzer for DBAs and developers: live activity dashboards, drill-down from a spike to the session, the SQL and its plan, and an AI assistant that reads the same data you do. Every view is a plain SQL script you can read, change and share.
Top Activity, system load, sessions, waits and SQL. Select a period on a chart and the tables follow; click a row to open the SQL, its plan, the session or the object.
Where the database keeps no activity history, or it is licensed separately, OPA-PA samples active sessions into a local store. Export an incident's hour and a colleague opens it offline.
Catalog, tables, charts, dashboards, actions and navigation come from SQL files with a short YAML header. Add your own next to the built-in packs; no plugins to compile.
Ask about what you see in a view, with your choice of provider: Anthropic, OpenAI, an OpenAI-compatible server or a local Ollama. An MCP server lets other AI tools use OPA-PA's scripts.
Values always go as bind variables. Actions that change anything ask for confirmation. Licensed database options are confirmed by you, and scripts that need them stay hidden otherwise.
Run SQL in the built-in worksheet, or open SQL*Plus or psql already logged on to the same connection, when a terminal is the better tool.
The application is free to use, and that will not change. Everything in the free version stays in the free version: paid licences, sponsorships and partnerships never take features away or lock existing ones.
What they do is add: extra script packs, custom branding, features built for a partner's customers, priority help. They also pay for development, so the free tool keeps getting better for everyone.
OPA-PA is developed independently. We are looking for companies that want this tool to grow and want to shape where it goes: database consultancies, support providers, vendors and teams that run many databases. Each partnership is agreed individually; these are the kinds we have in mind.
Strategic partner
Founding partner
A limited group, open during the public beta.
Gold sponsor
Something else in mind, such as an engine for another database, training or a joint offering? Write to us and we will find the right shape.
sponsors@opa-pa.comPortable builds: unpack and run, with Java included and nothing to install. The user guides (English, Spanish, Russian) come with the build.
The links always point to the latest beta. Found a bug or have an idea? beta@opa-pa.com