The SQL workbench for Oracle Fusion Cloud.

Run queries against live Fusion tenants. Edit BI Publisher data models in place. Ship reports 10× faster than FRC. Built for analysts who live in Fusion all day.

Free 30-day trial · no credit card · macOS & Linux builds also available

Built for Fusion analysts

Not a generic SQL IDE. Every feature is tuned for the reality of working inside Oracle Fusion Cloud.

Real SQL against live Fusion

Connect with SOAP/REST credentials stored in the OS keychain. Stream rows as they land — no 500-row caps. Cancel runaway queries mid-stream.

📊

BI Publisher catalog, browsable

See every report + data model in a Fusion-style folder tree. View SQL, edit data-model XDMs in place, save back to the tenant. Automatic pre-edit backups + one-click restore.

📚

Query history + snippet library

Every query you've run, searchable. Save SQL as reusable snippets with folders, RC/approval workflow, and optional git-backed team library.

🧭

Schema intelligence

Bundled offline vault of Fusion table + column metadata. Jump-to-definition, column search across the whole vault, ERD renderings.

🤖

AI-assisted SQL

Industry-aware assistant with few-shot grounding in your query history. Refuses to hallucinate — only suggests schema-verified columns.

📤

Export anywhere

XLSX with formatting. CSV, JSON, XML matching BIP output shape. PDF with live preview. Everything the audit team will ever ask for.

See it in action

Three features that will change how your team works with Fusion. Click any screenshot to open it full-size.

Fusion Forge — analytics_query
▾ Snippets
★ Active users
Invoice aging
GL trial balance
▾ Catalog
Finance > GL
Procurement
SELECT user_id,
legal_entity_id,
COUNT(*) AS n
FROM gl_je_lines_v
WHERE posted_date > :start_date
GROUP BY user_id, legal_entity_id
ORDER BY n DESC;
▶ Run ⌘↵
Grid ChartJSONCSVXMLExcelPDF
USER_ID LEGAL_ENTITY_ID N
3000000121011,248
300000018101872
300000024204611
300000031101440
300000045307389
Connected · PROD_GL 5 rows · 127 ms
01 · Run queries

Stream real SQL against your live tenant

Rows land as they come back from Fusion — no 500-row cap, no batch UI freeze. Cancel mid-stream, export to XLSX / CSV / JSON / XML / PDF, or pipe into a chart without leaving the app.

  • Syntax highlight + auto-complete for Fusion's dialect
  • Split-editor for comparing two queries side-by-side
  • Query history with full search + replay
02 · BI Publisher

Edit BIP data models without leaving the app

Browse every report + data model in a Fusion-style folder tree. View the SQL behind any report, edit the XDM in place, and save back to the tenant. Automatic pre-edit backups + one-click restore mean a botched save is never permanent.

  • Run any saved report from the catalog directly
  • Open report output in the editable grid (not a read-only PDF)
  • Timestamped backups kept locally — restore in one click
Fusion Forge — BI Publisher catalog
▾ Shared Folders
▾ Custom
▾ FusionForge
📊 AP_Invoice_Aging
📊 GL_Trial_Balance
📊 Cash_Forecast
▸ Finance
▸ Procurement
GL_Trial_Balance
/Custom/FusionForge/GL_Trial_Balance.xdo
▶ Run </> View SQL ✎ Edit 3 backups
SELECT ledger_id, period_name,
account, SUM(entered_dr) total_dr,
SUM(entered_cr) total_cr
FROM gl_balances
WHERE period_name = :period
GROUP BY ledger_id, period_name, account;
1 dataset · last edited 2d ago · Data source: ApplicationDB
Fusion Forge — snippets
★ Starred
GL trial balance by period
▾ Finance
R AP aging by supplier
Active users per LE
D Cash forecast (WIP)
▾ Team library
Monthly close checklist finance/close.sql
SOX audit — posted JEs audit/jes.sql
Status: RC · ready for review
03 · Snippets

A reusable query library, reviewed like code

Save every query you write. Promote drafts to RC to approved through a lightweight review workflow. Git-backed team library means your whole team sees the same blessed queries — edit a .sql file, git push, everyone has it 30 seconds later.

  • Template parameters with values prompted on load
  • Full version history with line-by-line diffs
  • Star your most-used snippets to the top

How it compares

We're not trying to replace your generic SQL IDE for your other databases. We're the tool you use when you're working against Oracle Fusion — and nothing else does that well.

Feature Fusion Forge Toad for Oracle DBeaver Pro DataGrip Fusion FRC (native)
Connects to Fusion Cloud SOAP / REST via generic JDBC — no BIP integration ✓ (native)
BI Publisher catalog browser ✓ folder tree, search, run, edit
Edit BIP data-model SQL in place ✓ with auto-backups + restore partial — via browser
Streaming result grid (no row cap) 500-row cap
Offline schema vault for Fusion tables ✓ bundled, versioned
Snippet library with git-backed team sharing local only
AI assistant grounded in your query history ✓ BYO key paid add-on ✓ JetBrains AI
Starting price Free → $29/mo ~$1,000/yr Free → $19/mo $99/yr bundled with Fusion

Last reviewed April 2026. We keep this honest — if you spot something wrong, email hello@nubepilot.com.

Simple, honest pricing

Compare to Toad for Oracle at $1k–2k/yr or DataGrip at $99/yr. All plans include the 30-day free trial.

Free

$0 forever

For occasional users + trial runs

  • 1 Fusion connection
  • 100-row export cap
  • Query history + snippets
  • Community support
Download
Most popular

Pro

$29 per user / month

For full-time Fusion analysts

  • Unlimited connections + rows
  • BI Publisher catalog editing
  • AI assistant (Anthropic key)
  • Snippet RC/approval workflow
  • Priority email support
Start 30-day trial

Team

$24 per seat / month (5+)

For teams sharing snippets + conventions

  • Everything in Pro
  • Git-backed team library
  • Centralised snippet approval
  • Slack/Teams integrations
  • Dedicated onboarding
Contact sales

Enterprise

Custom annual contract

For regulated orgs

  • Everything in Team
  • SSO (SAML / OIDC / IDCS)
  • On-prem backend option
  • Audit log export
  • SLA + dedicated support
Contact sales

Questions people actually ask

? How does it connect to my Fusion tenant?

Via the public SOAP / REST APIs Oracle already exposes (OTBI, BI Publisher, ERP Integration). You enter your Fusion URL + username + password once — credentials are stored in the OS keychain (Windows Credential Manager / macOS Keychain / Linux Secret Service), never in plain text on disk. No extra firewall rules, no agents.

? Do I need a Fusion admin to install this?

No. Fusion Forge runs entirely on your workstation and uses your own Fusion user credentials. If you can log into the Fusion web UI, you can use Fusion Forge. (SSO support is on the roadmap for enterprise customers who need it.)

? Is my query data sent anywhere?

No. Query execution happens directly between your laptop and your Fusion tenant — our servers never see it. Query history, snippets, and preferences are stored locally. The only data that touches our infrastructure is your account email + subscription state.

? Does the AI assistant see my data?

Only if you enable it and enter your own Anthropic API key. Your schema metadata + question text go to Anthropic under your account. Your query results stay local. You can turn off 'ground in history' if you don't want your past queries used as few-shot examples.

? What's the free tier limit?

Free tier: 1 Fusion connection, 100-row export cap, query history, snippet library, starter templates. Plenty for occasional users or evaluating the product. Pro unlocks unlimited connections + rows, BIP catalog editing, the AI assistant, and snippet approval workflow.

? Can I try Pro before paying?

Yes — every install gets a 30-day Pro trial with full features, no credit card. After the trial expires we drop you to Free tier until you enter a license key.

? Do I need to be online?

Licenses validate online once every ~30 days and cache locally, so day-to-day you can work offline indefinitely. Query execution obviously needs a connection to your Fusion tenant, but that's the only external thing the app talks to in normal use.

? Is there a macOS / Linux build?

Yes — Windows, macOS (Intel + Apple Silicon), and Linux (AppImage + .deb + .rpm) builds are all cut from the same release. Grab the right one from the Download page.

? How do updates work?

The app checks for updates on each launch (you can disable this in Settings). When one's available, you get a prompt; clicking Update downloads + installs + relaunches in the background. We sign all releases with Ed25519 so a malicious mirror can't trick the updater.

? Where's the source?

The Tauri + Rust backend is closed source today. We publish a detailed changelog + release notes on every version, and the built binaries include their git SHA for audit. If you're an enterprise customer that needs source access as part of your procurement process, contact us — we have an escrow arrangement for that case.

Something else on your mind? hello@nubepilot.com

Try it for 30 days. No credit card.

Full Pro features during the trial. If it doesn't save you hours a week on your first Fusion query, drop to Free and use the one-connection tier forever. No hassle either way.