sqlocean.com
Download

A WORKSPACE WITH DEPTH

From a question
to your next discovery.

Write SQL with Ocean AI, inspect results, open a remote desktop and reach the files around your data. One workspace, with your choice of model and ten optional Fun experiences.

✧ Ocean AI

Schema-aware SQL help with OpenAI, Claude or your own local model. Review suggestions and summarise results.

Explore AI & BYOM →

▣ Remote access

RDP tabs and pop-outs, SSH and VNC launchers, plus local terminals alongside your queries.

Explore remote access →

⇣ Files & cloud

FTP, FTPS, SFTP and direct cloud-drive browsing. Download the files around your data.

Explore files & cloud →

01 / ASK BETTER QUESTIONS

Let the query
do the talking.

A Monaco-powered SQL editor gives your queries a proper home. Keep multiple query tabs open, save the ones you return to, and move between SQL and results.

  • Syntax highlighting and SQL formatting
  • Separate SQL and result state in each query tab
  • Saved queries organised locally per connection
  • Ctrl+Enter runs the SQL in the active editor
A LITTLE CLARITY GOES A LONG WAY
your_next_answer.sqlCtrl ↵
SELECT name, city, total_orders
FROM customers
WHERE total_orders > 10
ORDER BY total_orders DESC;
SQL Ocean / ocean-commerce⌘
FileEditViewQueryTableToolsReportsFun ✦
SQL editor
1 SELECT name, city, total_orders
2 FROM customers
3 WHERE total_orders > 10
4 ORDER BY total_orders DESC;
Results 4Sample data
#Aa nameAa city123 total_orders
1Alex MorganBristol42
2Sam TaylorManchester36
3Jordan LeeEdinburgh28
4Charlie EvansLondon19
✓   4 rows returnedIllustrative workspace preview

MORE THAN ONE ANSWER

One SQL batch.
Every result in view.

SQL batches and stored procedures can return more than one table. Each tabular result gets its own numbered tab and row count, with the selection remembered for that query editor.

  • Switch between results without rerunning the SQL
  • Export the selected result set
  • Choose Summarise to send a bounded sample to Ocean AI
  • Multiple result sets are read-only
Understand AI result sharing →
ILLUSTRATIVE RESULT TABS

Choose the result.
Keep the query.

Result 1 · 12 rowsResult 2 · 8 rowsResult 3 · 3 rows

The selected tab controls export and AI summarisation.

02 / GET INTO THE DETAIL

More than rows
and columns.

Browse a table, filter the rows you’ve loaded and open a record in the JSON inspector. When you make a change, stage it and review the pending edits before applying.

  • Table browsing with sorting and loaded-row filters
  • JSON inspection for a closer look at a record
  • Review or revert staged row changes
  • Copy a row as JSON or rows as CSV and Markdown

Editing capabilities depend on the database and data source.

THE DETAILS, ALL IN VIEW
customers / selected row{ "city": "Bristol" }
2 pending editsReview changes

03 / KEEP THINGS MOVING

Bring it in.
Take it with you.

Import CSV or Excel with a mapping preview. Export the rows you’re working with in a format that fits the next step, or explore database export and migration tools.

  • CSV and Excel import with mapping preview
  • Row exports as CSV, JSON or Markdown
  • Database export with object selection
  • Migration planning between connections

Available transfer operations vary by provider. Review the selected connection and import or migration plan before applying changes.

LESS COPYING. MORE POSSIBILITY.
.csv.xlsx.json.md

From a spreadsheet to your database.
From a query to the next conversation.

04 / FOLLOW THE STORY

Your daily edition.
Written in data.

Discover reporting ideas from your database, choose your sources and capture a readable newspaper edition. Compare the latest figures with an earlier day, or switch to the report dashboard.

  • Discover and select report sources
  • Newspaper and dashboard views
  • Locally saved editions, charts and historical trends
  • Report export and comparisons between editions
  • Read the latest saved brief on Teletext page 500

Reporting supports PostgreSQL, MySQL and SQLite. Automatic daily capture runs while the app is open on the active connection.

The Ocean Observer

Your chosen figures.
The changes worth a closer look.

NEWSPAPER · DASHBOARD · DAILY BRIEF

05 / MAKE YOURSELF AT HOME

Built around
your way of working.

Keep saved connections close, find commands quickly and give your workspace the right atmosphere. A focused default, with room for a little personality.

  • Command search with Ctrl+K
  • Saved connections and local SQLite file selection
  • Server overview and provider-specific administration
  • Shared tabs for SQL, reports, views, Fun workspaces and RDP
  • Query pop-out windows and adjustable panes
  • Text sizing, workspace colours and photo themes
Explore the database connections
KEEP YOUR HANDS IN THE FLOW
Ctrl KFind commands, tables and saved queriesCtrl ↵Run the active queryEscClose a menu or dialog

AND THEN THERE’S THE FUN MENU

A little nostalgia.
A whole new dimension.

Ten optional experiences. Classic desktops, glowing terminals, Teletext, Matrix Construct and Schema Raider 3D. All part of SQL Ocean.

Explore all ten experiences

Find your favourite
way to work.

90 days free. Then £5 per month.

Get SQL Ocean