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 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/confighosts and SSH agent. -
A log of every statement
Everything sent to the server is logged, including the SQL generated by your edits.
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
Where it’s at
The beta browses, edits, queries and changes table structure. Backups come next.
-
Done:
Browse and edit
Connections, the grid, staged edits, filters and the statement log.
Done -
Done:
SSH tunnels and the command line
Remote servers through your SSH config, and a command line for queries, export, import and tunnels.
Done -
Done:
The query editor
Highlighting, autocomplete from your live schema, query history, EXPLAIN and several result sets.
Done -
Done:
Structure
Change columns, indexes, foreign keys and triggers, with the SQL shown before it runs.
Done -
Done:
Copy, export and import
Copy rows as CSV, JSON, INSERT statements or Markdown, and export or import whole tables.
Done -
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
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
- 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
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