Fusion Query Studio

Desktop SQL IDE for Oracle Fusion Cloud with AI-powered query generation

---

Cross-platform desktop SQL IDE for Oracle Fusion Cloud (ERP, HCM, SCM). Run queries, export data, and generate SQL from natural language using OpenAI or Claude — all with just a URL, username, and password.

Features

• SQL Editor — CodeMirror with syntax highlighting and schema autocomplete
• Auto-pagination — Transparently fetches all rows beyond the 1000-row BIP limit
• Export — CSV and Excel with streaming auto-pagination (constant memory)
• AI SQL Generation — Natural language to SQL via OpenAI or Claude, with auto-retry on errors
• RAG Schema Cache — Extracts tables/columns/FKs to local SQLite for smart autocomplete and LLM context
• Connection Manager — Save multiple Oracle Fusion instances, test before save, auto-deploy proxy report
• Query History — Searchable history of all executed queries
• Dark/Light Theme — Toggle with one click
• Multi-language — English, Portuguese (BR), Spanish
• No web server — Pure desktop app, no localhost HTTP needed

Installation

pip install fusion-query-studio

Or from source:

git clone https://github.com/AleCyriaco/fusion-query-studio.git
cd fusion-query-studio
pip install -e .
fusion-query-studio

Quick Start

1. Launch the app: fusion-query-studio
2. Click New Connection — enter URL, username, password
3. Click Test Connection — auto-deploys proxy report to BIP
4. Save and start querying!

AI-Powered Queries

1. Open the AI panel (toolbar or View menu)
2. Type a question: "show all active employees hired in 2024"
3. The AI generates SQL using your schema context
4. SQL runs automatically — if it fails, AI corrects and retries (up to 3x)
5. Click Use this SQL to load it into the editor

Supports OpenAI (gpt-4o) and Claude (claude-sonnet) — configure API keys in Settings.

Architecture

Built on fusion-query — the universal Oracle Fusion Cloud SQL engine.

fusion-query-studio/
├── app.py                 # Application entry point
├── main_window.py         # Main window assembly
├── connection/            # Connection manager + dialog + SQLite store
├── editor/                # CodeMirror SQL editor via QWebEngineView
├── results/               # QTableView with sortable model
├── export/                # CSV + Excel with auto-pagination
├── schema_cache/          # RAG: extract tables/columns/FKs to SQLite
├── llm/                   # OpenAI + Claude providers, prompt builder, retry engine
├── history/               # Query history in SQLite
├── i18n/                  # EN, PT-BR, ES translations
├── theme/                 # Dark + light QSS themes
├── settings/              # Settings dialog
└── workers/               # QThread workers for async operations

License

MIT