MODWAI

Free trial MacWindows

What MODWAI is

MODWAI is a desktop application for monitoring, diagnosing, and optimizing Oracle databases. It supports Oracle Database 19c and later, including RAC clusters and Pluggable Databases, on macOS and Windows. More than 150 built-in monitoring queries cover sessions, locks, storage, memory, and jobs. Query profiling, wait and lock analysis, execution plans, and session recording are included. Session recording samples active sessions at intervals from 0.5 to 10 seconds without requiring Oracle Diagnostic Pack licensing. ASH and AWR analysis requires the relevant Diagnostic Pack license, while Statspack analysis is offered as an alternative. Execution-plan analysis can identify common performance problems and suggest optimizations. AI choices include MODWAI Proxy, keys supplied for OpenAI, Anthropic, DeepSeek, or Gemini, and local Ollama; Ollama processing runs locally. Credentials use Fernet symmetric encryption, and MODWAI says it collects no telemetry. Thin connections need no Oracle Client, while Thick mode uses Oracle Instant Client. Results export to CSV, Excel, clipboard, PNG, JSON, or PDF.

Who it suits

It suits Oracle database teams needing monitoring, diagnostics, SQL analysis, and execution-plan review on macOS or Windows. Teams using ASH or AWR should have the required Oracle licensing.

What it does well

Supports Oracle 19c and later
150-plus monitoring queries
Session recording without Diagnostic Pack
Local Ollama analysis option
Exports results and execution plans

What to know first

ASH and AWR require Diagnostic Pack licensing
Focused on Oracle databases

Plans

Plan	Billed and limits	Price
MODWAI PRO	Monthly subscription · Everything in BASIC · MODWAI Proxy AI: 150 requests/month	On request
MODWAI BASIC	Monthly subscription · Bring your own AI keys · Monitoring and diagnostics · 150+ pre-built queries · Session recording / ASH / AWR*	On request
MODWAI ENTERPRISE	Monthly subscription · Everything in PRO · MODWAI Proxy AI: 250 requests/month · Custom AI model selection · SQL Script view & edit	On request

As modwai.eu lists them, read 11 Oct 2026. The maker's own page has the final word.

Verdict

MODWAI combines broad Oracle monitoring coverage with configurable session recording and several AI providers. Its licensing requirements and unlisted subscription prices should be checked before adoption.

Facts from MODWAI's own pages

AI analysis: It offers execution-plan analysis with detection of common performance issues and optimization recommendations. · modwai.eu, 11 Oct 2026
AI providers: The site lists MODWAI Proxy, user-provided keys for OpenAI, Anthropic, DeepSeek, and Gemini, and local Ollama as AI options. · modwai.eu, 11 Oct 2026
Database connectivity: MODWAI supports Thin mode without an Oracle Client and Thick mode using Oracle Instant Client for features such as TNS aliases. · modwai.eu, 11 Oct 2026
Diagnostic licensing: ASH and AWR analysis requires the appropriate Oracle Diagnostic Pack license; the site also describes Statspack analysis as an alternative. · modwai.eu, 11 Oct 2026
Exports: The product can export query results to CSV, Excel, or clipboard and execution plans to PNG, JSON, or PDF. · modwai.eu, 11 Oct 2026
Local processing: The site says Ollama-based AI analysis runs locally and avoids cloud data exposure for that analysis. · modwai.eu, 11 Oct 2026
Monitoring: The product includes more than 150 pre-built monitoring queries covering areas such as sessions, locks, storage, memory, and jobs. · modwai.eu, 11 Oct 2026
Oracle support: It supports Oracle Database 19c and later, including RAC clusters and Pluggable Databases. · modwai.eu, 11 Oct 2026
Purpose: MODWAI is a desktop application for Oracle database monitoring, diagnostics, and SQL optimization. · modwai.eu, 11 Oct 2026
Security: The site says stored credentials use Fernet symmetric encryption and that MODWAI collects no telemetry. · modwai.eu, 11 Oct 2026
Session recording: Session recording samples active sessions at configurable intervals from 0.5 to 10 seconds and does not require Oracle Diagnostic Pack licensing. · modwai.eu, 11 Oct 2026
Trial: The homepage advertises a free 7-day trial for macOS and Windows. · modwai.eu, 11 Oct 2026

Where MODWAI stands on Freedom251

Database Monitoring#22 of 38