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
Two ways to sign in
Basic Auth (username/password) or SSO (sign in through your browser — no password stored, no password even entered in the extension)
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.
Enter a Connection name (e.g. ESFE Dev1) and the Base URL (e.g. https://fa-esfe-dev1.us1234.oraclecloud.com).
Choose an authentication method:
Basic Auth
Enter your Username and Password.
The password is stored encrypted in the Windows Credential Manager — never in settings.json.
SSO
No username or password is entered in the extension at all.
A browser window opens to your Fusion sign-in page — log in exactly as you normally would.
Once signed in, the extension automatically captures a session token and stores it encrypted in the Windows Credential Manager.
If your session later expires, the same browser window reopens automatically so you can sign in again — no need to re-add the connection.
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 and SSO session tokens are never stored in settings.json or plaintext files. They are encrypted and stored in Windows Credential Manager.
With SSO, your Fusion username/password are never seen or handled by the extension — you sign in directly on Oracle's own login page in a browser window.
All requests use HTTPS — HTTP connections are not supported.
