Beta Version 1.0.0 · macOS 15 or later · Apple silicon

XenoSQL

A careful MySQL and SQLite client.

A native Mac database client for MySQL 8 and SQLite. Browse and filter tables, edit rows in the grid and commit them in one transaction, and reach remote servers through your own SSH config. Every statement XenoSQL runs for you, including the ones behind ⌘S, is shown under the grid and logged.

Signed & notarized · No account · No analytics or telemetry

What it does

What XenoSQL does

Browse, filter and edit, with every change visible.

  • Staged edits

    Changed cells turn amber, new rows get a green edge and deleted rows are struck through. Review the exact SQL from the pending edits, or press ⌘S to commit.

  • All or nothing

    Your changes run in one transaction and roll back completely if any statement fails. ⌘U undoes the window’s commits, newest first.

  • Production, clearly marked

    Flag a connection as production and its window turns red, with a Production badge. In Terminal, every query on it asks you to confirm.

  • Filters you can read

    Build filters with type-aware operators and AND/OR, see the WHERE clause, and edit it by hand. Values are always sent as parameters.

  • SSH tunnels

    Reach remote databases through your own ~/.ssh/config hosts and SSH agent.

  • A log of every statement

    Everything sent to the server is logged, including the SQL generated by your edits.

Command line

The same care from Terminal

The xenosql command-line tool runs a query, streams table data out as CSV, JSON or SQL and back in from CSV or JSON, and opens SSH tunnels, with the same --json and --dry-run conventions as every XenoTool.

  • Connection details stored on your Mac; secrets in the macOS Keychain
  • Queries on a production connection ask you to confirm
  • No cloud sync, no telemetry
Progress

Where it’s at

The beta browses, edits, queries and changes table structure. Backups come next.

  1. Done:

    Browse and edit

    Connections, the grid, staged edits, filters and the statement log.

    Done
  2. Done:

    SSH tunnels and the command line

    Remote servers through your SSH config, and a command line for queries, export, import and tunnels.

    Done
  3. Done:

    The query editor

    Highlighting, autocomplete from your live schema, query history, EXPLAIN and several result sets.

    Done
  4. Done:

    Structure

    Change columns, indexes, foreign keys and triggers, with the SQL shown before it runs.

    Done
  5. Done:

    Copy, export and import

    Copy rows as CSV, JSON, INSERT statements or Markdown, and export or import whole tables.

    Done
  6. 6

    Backups and XenoHost

    Back up a database to a SQL file and restore it with a preview first, export several tables at once, and XenoHost’s MySQL server listed with your connections.

    Next
XenoTools

Part of XenoTools

XenoSQL queries. Its sibling tools build, serve, ship, run and audit the same projects, and each one also works on its own.

Get XenoSQL

Beta Pricing announced at launch.

  • Buy version 1 once; every 1.x update included
  • Use it on 2 Macs
  • 50% off when you upgrade from the previous major
  • No subscription or yearly fee, no account

How licensing works →14-day free trial at launch

Payments by Stripe. Your license key arrives by email. Lost it? Recover it at licenses.xenoplexus.com/recover.

Requires
macOS 15 or later
Processor
Apple silicon
Download
10 MB, signed & notarized
Databases
MySQL 8 and SQLite

Questions about XenoSQL?

Ask about XenoSQL or the beta, or tell us about an app you need built. We’ll get back to you within 24 hours.

Need help with an app or a license? Open a support ticket →

We reply within 24 hours on business days.