Fusion Query Studio
Connect to Oracle Fusion Cloud, run SQL queries, and view the results in a rich panel — directly inside VS Code.
Features
| Feature |
Details |
| Multiple connections |
Store multiple Oracle Fusion environments; passwords are encrypted and stored in the Windows Credential Vault |
| Live results table |
Sortable columns, row numbering, null highlighting |
| Pagination |
Navigate large datasets with configurable row limits |
| Export CSV |
Save results to disk with one click |
| Query history |
Last 50 queries auto-saved; re-run with a single click |
| Resizable panes |
Drag the divider between editor and results |
| AI-Chat ready |
Ask VS Code's native AI Chat to build and execute the query through this extension |
| Upcoming Features |
SSO based authentication/login |
Getting Started
1. Install the extension from VS Code Marketplace
2. Launch the extension
3. Add a connection
- Click the Fusion Query Studio icon in the Activity Bar.
- Click the + button in the Connections panel.
- Follow the 4-step wizard:
- Connection name (e.g.
ESFE Dev1)
- Base URL (e.g.
https://fa-esfe-dev1.us1234.oraclecloud.com)
- Username
- Password (stored encrypted in the Windows Credentials Vault — never in settings.json)
4. Open the Query Panel
- Click ▶ Open Query Panel in the toolbar, or
- Run command:
Fusion Query Studio: Open Query Panel
5. Run SQL queries
- Write the desired query in the top panel and click Run button (or hit Ctrl+Enter)
- You can adjust the Number of records to be fetched by changing Limit value
- Please don't use a trailing semicolon (;) at the end of your query
- Click Cancel to stop the query mid-execution, if needed
6. AI Chat Capabilities
- You can interact with VS Code's standard AI Chat and ask it to build and run the desired query using this extension.
- It will ask which connection to use (from this extension), run the query, and show the results.
- It will also tell you the actual query that was executed.
Keyboard Shortcuts
| Shortcut |
Action |
Ctrl+Enter |
Run query |
Tab |
Insert 2 spaces in editor |
Security
- Passwords are never stored in
settings.json or plaintext files. They are encrypted and stored in Windows Credential Manager.
- All requests use HTTPS — HTTP connections are not supported.
Support
You can support me by buying a coffee :) - https://buymeacoffee.com/geek_bench
| https://www.geek-bench.com | amodjjoshi@gmail.com |
| |
