BUILD AND COMPARE / FROM A QUESTION TO SQL

Build the query.
See what changed.

Choose columns, preview a transformation and open the generated SQL in your editor. Capture a baseline when you need to compare results or table structure.

Query builder →Compare results →Compare schema →

Loaded-result comparison is included in Free. Live relational query building and schema comparison currently require Pro. · Public download coming soon

SQL Ocean query builder with selected business columns, a text transformation and SQL preview — Current development build · Harbour & Field Supply · Fictional demo records

A SELECT YOU CAN READ

Choose. Preview.
Open in the editor.

Build and compare brings a column picker, sort options, row limit and SQL preview into one dialog.

Find the right columns

Search the source table’s columns, select the ones you need or use All and Clear. Set the sorting and returned-row limit.

Transform the output

Trim whitespace, change text case or turn blank text into NULL. Keep the original column alongside the transformed value if useful.

Keep the SQL

Copy the highlighted statement or choose Open in SQL editor. Building the query does not execute it or change stored values.

KEEP A BASELINE

Which rows changed?

Capture the current loaded result, choose the columns that uniquely identify each row, then compare with another result in the same connection.

SQL Ocean result comparison showing changed totals between two queries of fictional customer records — Current development build · Harbour & Field Supply · Fictional demo records

Inspect added, removed and changed rows with before-and-after values.
Choose a complete unique key, including multiple columns when needed.
Export the differences as JSON, with the comparison scope included.

LOOK AT THE STRUCTURE

Compare definitions.
Review the difference.

Capture the visible schema catalogue and compare columns, types, nullability, primary keys and declared relationships.

A focused comparison

Use it to inspect changes in the definitions available to your database account. Indexes, triggers and permissions are outside this comparison.

An observation, not a migration

Comparison shows differences. It does not generate or execute a synchronisation job. Use Schema workbench to review a deliberate change.

Snapshots stay in memory until you switch connections. Keep up to ten snapshots; a result snapshot supports up to 10,000 loaded rows. Unread rows are excluded. A schema snapshot covers visible metadata, not a complete database backup.

Explore Schema workbench →

A clearer view starts here.

Free for everyday SQL. 40 days of Pro included automatically for new Windows users. Optional Pro is £7.50/month.

Check download availability ↗

Build the query.See what changed.

Choose. Preview.Open in the editor.