Free & open source · Oracle SQL and PL/SQL IDE
Pythia covers the daily work of an Oracle developer — writing and running SQL, editing and compiling PL/SQL, debugging, editing data, comparing schemas and watching what the database is doing — in one responsive, keyboard-first app for Windows, macOS and Linux.
Version 0.10.0 · October 30, 2026 · Windows, macOS and Linux · no sign-up
MySQL, MariaDB, PostgreSQL and SQL Server are experimental: SQL windows, the object browser, users and roles, monitoring and maintenance, also through an SSH tunnel. The PL/SQL tools are Oracle's.
From the first query to the deployment script, with the shortcuts you'd expect: Ctrl+Enter, F8, F5, F12, Ctrl+Space.
Completion with the real columns after alias., package members with their signatures, %ROWTYPE and cursor records. Go to definition — also into the database — references, rename, live diagnostics, multi-cursor and code folding.
Run the statement under the cursor, the selection or the whole script. A virtualized grid sorts, filters, charts and exports to CSV, Excel, JSON or INSERTs, and follows foreign keys to parent and child rows.
Change query results in place, with no FOR UPDATE: changes are checked against the values you fetched, so someone else's update is reported instead of overwritten. Show SQL previews the DML.
Program windows with spec and body, compile errors you can click, an outline and a formatter your team can share. Test… writes a ready-to-run block for any procedure or function — records, collections and ref cursors included.
Conditional breakpoints, step into, watches, Run to Cursor, and values you change while stopped. Hover a selection like l_order.lines(i) to see that element. At every stop it checks the plans of the SQL the code just ran, marks a misestimate on its line and lets the plan button blink; a click shows the real plan beside the code, estimated and actual rows side by side. When the database can't connect back, Debugger Setup finds out why — grants, ACL, host name, firewall — and fixes it. A profiler too.
A dashboard that says it plainly — “session 175 blocks 2 sessions, likely an uncommitted transaction” — the blocking tree, sessions and SQL with their plans and binds, ASH, AWR and SQL Monitor reports, tkprof for traces.
Anthropic, any OpenAI-compatible API, a local model (Ollama, llama.cpp, LM Studio) or a command line tool. Generate SQL from your real tables, fix errors, explain plans. Each answer shows what was sent.
Schema compare with ordered sync scripts, data compare by key, CSV and Excel import with type inference, table export, and a maintenance scan for stale statistics, unusable indexes and dead rows.
Open a folder as a project with its git status, compare a file with its object in the database, export a schema as one file per object, and deploy what changed in dependency order.
Built for databases where mistakes are expensive.
tnsnames.ora and proxy users work as they are.$IF's first branch as the code, and Format keeps statements with $IF as written (#171, #172).Free for everyone. Version 0.10.0, released October 30, 2026.
Connects to Oracle on its own — take this one unless you need the Instant Client.
For Oracle 11.2, servers that require Native Network Encryption, and OS or wallet logins. Needs Oracle's Instant Client installed (see the FAQ).
Windows 10 and 11 · x64
macOS 11 or later · Apple silicon and Intel
x86_64 · glibc 2.35 or newer (Ubuntu 22.04, Debian 12, …)
Every file's SHA-256 is in SHA256SUMS.txt. Older versions are on the releases page. Prefer to build it yourself? cargo build --release
The packages aren't code-signed yet, so Windows and macOS ask once before they run Pythia.
xattr -dr com.apple.quarantine /Applications/Pythia.app in Terminal.chmod +x pythia_*.AppImage.Pythia is young and moves fast. Found a bug, or missing something from the tool you used before? Tell us — every report is read.
Yes, for personal and commercial use. It's open source under the MIT or Apache-2.0 license, with no account, license key or paid edition.
No. Pythia talks to Oracle with a built-in driver written in Rust. Easy Connect strings (host:port/service) work as they are; for net service names, point TNS_ADMIN at the folder with your tnsnames.ora, and the one of an Oracle Client that's already installed is found the way Oracle finds it.
The one with the built-in driver, unless you connect to Oracle 11.2, to a server that requires Native Network Encryption (connecting fails with “Native Network Encryption and Data Integrity”), or with OS or wallet logins (/@alias). For those, take the Instant Client download and install Oracle's Instant Client (Basic or Basic Light) on the library path. Installing one replaces the other; your settings and connections stay.
Pythia is developed against Oracle 23ai and tested against 18c and 21c; Oracle 11.2 works with the Instant Client download. A few features need a newer release: the profiler needs 18c, reading trace files through the database 12.2.
They're experimental: SQL windows with results, explain plan and completion, the object browser, users and roles, sessions, monitoring dashboards and maintenance, also through an SSH tunnel. Their drivers are built in too. The tools that rest on PL/SQL and Oracle's dictionary — debugger, profiler, schema compare and others — stay on Oracle.
Only to your databases, and to the AI model you set up when you use the assistant. Requests carry table definitions, statistics, plans and source; result rows and bind values only if you allow it in Settings → AI, and each answer shows what was sent. There's no telemetry and no account.
Yes, under WSLg. Pythia opens its window through X11 there; on a scaled display, size it with Settings → UI scale or Ctrl + and Ctrl −.
Free, open source, and ready in a minute — on Windows, macOS and Linux.