DataPaw 1.0.5

DataPaw is a desktop Salesforce client: browse orgs, write SOQL with
autocompletion, edit results in a grid, and run bulk jobs, without a browser
tab and without the setup a full IDE asks for.

Five new themes

The theme set was mostly ports of characterful editor palettes. These five are
the quiet ones: near-neutral backgrounds, low colour, one accent each.

Paper	warm near-white, dark ink, low glare
Mist	cool near-white, blue-grey, crisp
Graphite	neutral dark, no colour cast
Slate	cool dark, blue-grey
High Contrast	white on black, strong edges

High Contrast fills a real gap. Nothing in the previous set was built for a
bright room or for anyone who needs maximum legibility.

Every border in these is calculated rather than picked by eye: lightness is
walked away from that theme's own background, keeping its hue, until it reaches
a measured contrast target. Text sits at 14:1 or better against its background
in all five, and the status bar's text-on-accent pairing, the weakest point in
the older themes, is between 5.3:1 and 8.7:1 here.

Pick a theme from the Theme menu. There are 24 now.

What it does

• Query. A real SOQL editor with schema-aware autocompletion, multiple
  script tabs, and a results grid that sorts, filters, freezes columns and
  pages lazily through large tables rather than loading them whole.
• Edit. Change a cell in place, open any Id to inspect the record behind
  it, and drill through lookups. Writes go to the REST API directly, so nothing
  is mangled on the way.
• Move data. CSV import and export, Bulk API 2.0 jobs for
  insert/update/upsert/delete with a genuine before/after preview, and
  Copy Data From Another Org, which remaps every lookup to the target org's
  new Ids, so a sandbox can be seeded without a spreadsheet full of
  find-and-replace.
• Understand. An ER diagram of any set of objects, and Compare With
  Another Org for objects, fields, validation rules, Apex and flows, with
  flows diffed structurally, so moving a node on the canvas is not reported as
  a change.

Requirements

• macOS 11+ (Apple Silicon or Intel) or Windows 10/11
• The Salesforce CLI. If you do not have it, DataPaw offers to install a copy
  for itself on first run. No admin prompt, and your own sf is preferred if
  one is already on PATH.

Trial and licence

A 30-day free trial starts on first launch. No account, no card, no signup.
A licence is $49/year and covers every feature on two computers.

When a trial ends, your own work stays yours: saved SOQL scripts and local
CSV import/export keep working. Only the Salesforce org connections lock.

Manage a subscription (cancel, change card, download invoices, retrieve your
licence key) at
polar.sh/xen-shift-labs-llc/portal,
or in-app under Manage subscription.

Privacy

Analytics are off by default and are asked for once, plainly. Nothing is
transmitted unless you turn them on, and the app will show you the exact queued
payload before it goes anywhere. Org names, schema, query text and record data
are never collected. Full policy:
xenshift.com/legal/privacy.html

Downloads

Platform	File
macOS, Apple Silicon	DataPaw-1.0.5-arm64.dmg
macOS, Intel	DataPaw-1.0.5.dmg
Windows, installer	DataPaw-Setup-1.0.5.exe
Windows, portable	DataPaw-Portable-1.0.5.exe

The macOS builds are signed and notarized by Apple. The Windows builds are
signed with an Azure Trusted Signing certificate issued to XenShift Labs LLC.
SmartScreen reputation accrues per file over time, so early downloads may still
show a warning.

Questions, bugs, feedback: support@xenshift.com

DataPaw 1.0.4

DataPaw is a desktop Salesforce client: browse orgs, write SOQL with
autocompletion, edit results in a grid, and run bulk jobs — without a browser
tab and without the setup a full IDE asks for.

SELECT *

SOQL has no SELECT *. Salesforce leaves it out deliberately, and their own
partial answer — FIELDS(ALL) — is capped at 200 rows, which is no use to a
grid built to page past that. So DataPaw expands it for you: write
SELECT * FROM Account and it sends the real field list.

Cmd/Ctrl+Alt+E, or Expand SELECT * to Field List on the menu, rewrites it
in the editor rather than only on the way out — so what you copy into Workbench,
the Developer Console or an Apex class is real, portable SOQL.

It drops the fields SOQL will not accept, since a single one of them fails the
whole query rather than being skipped, and it says plainly when an object is
simply too wide to ask for in one go instead of failing with an opaque network
error.

It tells you when there is a new version

DataPaw now checks for a new release when it starts, and shows what changed
alongside a download link.

It stays quiet the rest of the time: no "you're up to date" every morning, and
nothing at all if you are offline. Skip this version silences one release
without silencing the next, and Check for Updates… on the menu still answers
on demand.

Updates are announced, not installed — applying one still means downloading the
installer. This is the first release that can announce the next one, so if
you update by hand today, this should be the last time.

Also in this release

• The expired-session breaker added in 1.0.3 now recognises a connection by the
  account behind it rather than by whichever name the calling code happened to
  use, so one connection can no longer be treated as two.
• Clicking a record Id no longer bypasses that breaker.
• Reconnecting takes effect immediately, instead of appearing to do nothing
  until the app was restarted.

What it does

• Query. A real SOQL editor with schema-aware autocompletion, multiple
  script tabs, and a results grid that sorts, filters, freezes columns and
  pages lazily through large tables rather than loading them whole.
• Edit. Change a cell in place, open any Id to inspect the record behind
  it, and drill through lookups. Writes go to the REST API directly, so nothing
  is mangled on the way.
• Move data. CSV import and export, Bulk API 2.0 jobs for
  insert/update/upsert/delete with a genuine before/after preview, and
  Copy Data From Another Org — which remaps every lookup to the target org's
  new Ids, so a sandbox can be seeded without a spreadsheet full of
  find-and-replace.
• Understand. An ER diagram of any set of objects, and Compare With
  Another Org for objects, fields, validation rules, Apex and flows — with
  flows diffed structurally, so moving a node on the canvas is not reported as
  a change.

Requirements

• macOS 11+ (Apple Silicon or Intel) or Windows 10/11
• The Salesforce CLI. If you do not have it, DataPaw offers to install a copy
  for itself on first run — no admin prompt, and your own sf is preferred if
  one is already on PATH.

Trial and licence

A 30-day free trial starts on first launch. No account, no card, no signup.
A licence is $49/year and covers every feature on two computers.

When a trial ends, your own work stays yours — saved SOQL scripts and local
CSV import/export keep working. Only the Salesforce org connections lock.

Manage a subscription — cancel, change card, download invoices, retrieve your
licence key — at
polar.sh/xen-shift-labs-llc/portal,
or in-app under Manage subscription.

Privacy

Analytics are off by default and are asked for once, plainly. Nothing is
transmitted unless you turn them on, and the app will show you the exact queued
payload before it goes anywhere. Org names, schema, query text and record data
are never collected. Full policy:
xenshift.com/legal/privacy.html

Downloads

Platform	File
macOS, Apple Silicon	DataPaw-1.0.4-arm64.dmg
macOS, Intel	DataPaw-1.0.4.dmg
Windows, installer	DataPaw-Setup-1.0.4.exe
Windows, portable	DataPaw-Portable-1.0.4.exe

The macOS builds are signed and notarized by Apple. The Windows builds are
signed with an Azure Trusted Signing certificate issued to XenShift Labs LLC —
SmartScreen reputation accrues per file over time, so early downloads may still
show a warning.

Questions, bugs, feedback: support@xenshift.com

DataPaw 1.0.3

DataPaw is a desktop Salesforce client: browse orgs, write SOQL with
autocompletion, edit results in a grid, and run bulk jobs — without a browser
tab and without the setup a full IDE asks for.

If you are on 1.0.2, please update. 1.0.2 tried to stop DataPaw retrying
expired Salesforce sessions, and did not fully succeed.

The expired-session fix, properly this time

An expired Salesforce session never recovers on its own — the refresh token has
been revoked or has passed its lifetime — so every retry is another failed
sign-in against your account, and enough failed sign-ins can lock a Salesforce
account.

1.0.2 added a circuit breaker to stop that. It worked for some paths and not
others, because it identified a connection by whatever name the calling code
happened to use: parts of the app refer to a connection by its alias
(Z360-Prod), others by its username. So one connection looked like two, each
got blocked separately, and each paid its own failed sign-in before it was.
A real diagnosis found six blocked records for three connections, with the same
org blocked twice seven seconds apart.

1.0.3 identifies a connection by the account behind it, so blocking it blocks
it everywhere. Alongside that:

• Clicking a record Id no longer bypassed the breaker. That path talked to
  Salesforce by a different route and was never covered.
• Restarting the app no longer re-checks every connection. The "have these
  sessions gone stale?" check signs in to every org — free when they are
  healthy, another failed sign-in when they are not. Its rate limit only lived
  in memory, so quitting and reopening reset it, and reopening is exactly what
  you do when something seems stuck. DataPaw now skips that check entirely when
  it already knows every connection is expired.
• The refresh button in the sidebar is rate-limited. In 1.0.2 it forced
  that same check every click, with no limit. It now tells you when it has
  checked recently instead of silently signing in again.
• Reconnecting takes effect immediately. Some results from a failed call
  were cached for the life of the process, so a successful reconnect appeared
  to fix nothing until the app was restarted.

If DataPaw has marked a connection with a red Reconnect chip, that is it
declining to use the connection on purpose, not a hang. If your Salesforce
account is currently locked, get it unlocked before reconnecting — signing in
against a locked account only adds failed attempts.

What it does

• Query. A real SOQL editor with schema-aware autocompletion, multiple
  script tabs, and a results grid that sorts, filters, freezes columns and
  pages lazily through large tables rather than loading them whole.
• Edit. Change a cell in place, open any Id to inspect the record behind
  it, and drill through lookups. Writes go to the REST API directly, so nothing
  is mangled on the way.
• Move data. CSV import and export, Bulk API 2.0 jobs for
  insert/update/upsert/delete with a genuine before/after preview, and
  Copy Data From Another Org — which remaps every lookup to the target org's
  new Ids, so a sandbox can be seeded without a spreadsheet full of
  find-and-replace.
• Understand. An ER diagram of any set of objects, and Compare With
  Another Org for objects, fields, validation rules, Apex and flows — with
  flows diffed structurally, so moving a node on the canvas is not reported as
  a change.

Requirements

• macOS 11+ (Apple Silicon or Intel) or Windows 10/11
• The Salesforce CLI. If you do not have it, DataPaw offers to install a copy
  for itself on first run — no admin prompt, and your own sf is preferred if
  one is already on PATH.

Trial and licence

A 30-day free trial starts on first launch. No account, no card, no signup.
A licence is $49/year and covers every feature on two computers.

When a trial ends, your own work stays yours — saved SOQL scripts and local
CSV import/export keep working. Only the Salesforce org connections lock.

Manage a subscription — cancel, change card, download invoices, retrieve your
licence key — at
polar.sh/xen-shift-labs-llc/portal,
or in-app under Manage subscription.

Privacy

Analytics are off by default and are asked for once, plainly. Nothing is
transmitted unless you turn them on, and the app will show you the exact queued
payload before it goes anywhere. Org names, schema, query text and record data
are never collected. Full policy:
xenshift.com/legal/privacy.html

Downloads

Platform	File
macOS, Apple Silicon	DataPaw-1.0.3-arm64.dmg
macOS, Intel	DataPaw-1.0.3.dmg
Windows, installer	DataPaw-Setup-1.0.3.exe
Windows, portable	DataPaw-Portable-1.0.3.exe

The macOS builds are signed and notarized by Apple. The Windows builds are
signed with an Azure Trusted Signing certificate issued to XenShift Labs LLC —
SmartScreen reputation accrues per file over time, so early downloads may still
show a warning.

Questions, bugs, feedback: support@xenshift.com

DataPaw 1.0.1

DataPaw is a desktop Salesforce client: browse orgs, write SOQL with
autocompletion, edit results in a grid, and run bulk jobs — without a browser
tab and without the setup a full IDE asks for.

It reuses the orgs you have already authenticated with the Salesforce CLI, and
can authenticate new ones from inside the app.

What it does

• Query. A real SOQL editor with schema-aware autocompletion, multiple
  script tabs, and a results grid that sorts, filters, freezes columns and
  pages lazily through large tables rather than loading them whole.
• Edit. Change a cell in place, open any Id to inspect the record behind
  it, and drill through lookups. Writes go to the REST API directly, so nothing
  is mangled on the way.
• Move data. CSV import and export, Bulk API 2.0 jobs for
  insert/update/upsert/delete with a genuine before/after preview, and
  Copy Data From Another Org — which remaps every lookup to the target org's
  new Ids, so a sandbox can be seeded without a spreadsheet full of
  find-and-replace.
• Understand. An ER diagram of any set of objects, and Compare With
  Another Org for objects, fields, validation rules, Apex and flows — with
  flows diffed structurally, so moving a node on the canvas is not reported as
  a change.

Requirements

• macOS 11+ (Apple Silicon or Intel) or Windows 10/11
• The Salesforce CLI. If you do not have it, DataPaw offers to install a copy
  for itself on first run — no admin prompt, and your own sf is preferred if
  one is already on PATH.

Trial and licence

A 30-day free trial starts on first launch. No account, no card, no signup.
A licence is $49/year and covers every feature on two computers.

When a trial ends, your own work stays yours — saved SOQL scripts and local
CSV import/export keep working. Only the Salesforce org connections lock.

Manage a subscription — cancel, change card, download invoices, retrieve your
licence key — at
polar.sh/xen-shift-labs-llc/portal,
or in-app under Manage subscription.

Connections tell you when they need attention

An expired Salesforce session used to be invisible until something failed deep
inside a feature — an object list that came back empty, a query that errored
for no stated reason. Connections whose session has lapsed are now marked in
the sidebar with a Reconnect button that signs you back in, and named once
at startup.

A sign-in opens your browser and can take a while, so it now says so, shows
which connection it is working on, and can be cancelled with Escape. Only one
runs at a time — Salesforce's login flow uses a single fixed callback port, and
a second sign-in would otherwise fail with an error about port 1717 that
explained nothing.

Anything that can fail says why

Several places reported an empty result where the truth was "this did not
work". The object picker in Copy Data From Another Org is the clearest case:
an unreachable org produced "No objects match that filter", sending you to fix
a filter that was never wrong. It now names the org, gives Salesforce's own
reason, and offers a retry.

Privacy

Analytics are off by default and are asked for once, plainly. Nothing is
transmitted unless you turn them on, and the app will show you the exact queued
payload before it goes anywhere. Org names, schema, query text and record data
are never collected. Full policy:
xenshift.com/legal/privacy.html

Downloads

Platform	File
macOS, Apple Silicon	DataPaw-1.0.1-arm64.dmg
macOS, Intel	DataPaw-1.0.1.dmg
Windows, installer	DataPaw-Setup-1.0.1.exe
Windows, portable	DataPaw-Portable-1.0.1.exe

The macOS builds are signed and notarized by Apple. The Windows builds are
signed with an Azure Trusted Signing certificate issued to XenShift Labs LLC —
SmartScreen reputation accrues per file over time, so early downloads may still
show a warning.

Questions, bugs, feedback: support@xenshift.com