Features

Everything you need to query Oracle Cloud without the hassle.

• ⚡Only in CloudFish

  HCM REST Resource & SQL (ORDS / custom endpoint)

  Run HCM REST resources and SQL together—including ORDS and custom endpoints—in one tool. No other tool offers this.

• 🔐Enterprise

  Single Sign-On (SSO)

  Enterprise customers can use Single Sign-On—one login for your identity provider and CloudFish. Secure, seamless access for your team. Simply create an SSO connection in CloudFish, and when you connect, your organization's login window will handle authentication.

• ☁️

  Web-based, No Need To Download and install

  Access from anywhere. No client extensions or downloads.

• 🔌

  SQL in Oracle Cloud

  Run SQL against Oracle Cloud data—HCM, ERP, SCM, PPM—with one tool.

• 🌐

  Multiple connections

  Connect to several cloud instances at once and switch between them easily. Create Multiple Connections and rename them as you wish.

• 📊

  Export to Excel & CSV, DAT AND PDF formats

  Export results to .xls and .csv for reports and analysis.

• 🔍

  DB Browser – packages & code

  See all packages in the database and open any package to view its code. Browse Fusion tables and build queries with full visibility.

• 📋

  Search tables & columns, click to copy

  Search all available tables with column names. Click a table name and it copies straight into the query editor.

• 🤖

  AI Assistant to build query in natural language

  Describe what you need in plain English and get SQL generated for Oracle Cloud tables—no syntax memorization required.

• ✨

  Intellisense & Formatting

  Smart editor with auto-completion, SQL formatting, and code snippets.

• 📜

  SQL History

  CloudFish keeps all your queries for ready reference. Every query you run is automatically saved in your history, so you can always go back and find it.

• 💬

  Clear Oracle error messages

  Get clear, readable Oracle error messages so you can fix issues faster and code with less guesswork.