Released, in the open.

SSH tunnels

RSA keys, welcome aboard.

SSH tunnels now accept RSA private keys alongside ed25519 and ECDSA — including the classic AWS-style .pem files. Authentication uses modern rsa-sha2-256 / rsa-sha2-512 signatures, so tunnels work with current OpenSSH servers that have retired the legacy ssh-rsa algorithm. Closes issue #42.

MySQL

Two paper cuts, gone.

• mysql_native_password support. The native-password authentication plugin now ships inside the app, so connecting to older servers — or newer ones with legacy accounts — works without any client-side setup.
• Correct default schema. Creating a table on MySQL now defaults to the database you're connected to instead of suggesting a schema that doesn't exist.

OpenObserve

Always fresh.

Stream queries now always bypass the server-side result cache, so browsing an OpenObserve stream reflects the data as it is right now — not as it was a few minutes ago.

The premise

A database client that feels like your code editor.

DevTables 1.0 is built around one idea: developers who live in PostgreSQL, MySQL, and SQLite every day shouldn't have to leave the keyboard to use their database tool. A command palette (⇧⌘P) runs every action by name, a quick-switcher (⌘P) jumps to any table by typing, and every shortcut is rebindable in Settings → Keymap.

Connections

• Saved connections on a fast start page — open, edit, duplicate, delete, and test before saving. Passwords are stored in the macOS Keychain.
• TLS and SSH tunnels for PostgreSQL and MySQL, with password and private-key authentication.
• Multi-window workspaces — each window owns its session and tabs; all share the connection list.
• Resilient sessions — optional launch restore, visible connection progress with cancel, a configurable timeout, and tap-to-reconnect that keeps your tabs when a connection drops.
• SQLite, sandboxed properly — files (including WAL sidecars) reopen reliably after relaunch.

Browsing

• Object browser for tables, views, indexes, triggers, and schemas, with search.
• Instant table switching — open tables keep a live grid; page, sort, scroll, and selection are restored when you return.
• Pagination-first grids with a safe default row limit, per-table WHERE filters, native sorting, column resizing, and multi-row selection.
• Persistent views — column show/hide choices and filters are remembered per table, per connection.

SQL editor

• Schema-aware autocomplete — live table, view, and typed-column suggestions driven by the current statement, ranked above keywords.
• Run Current (⌘↩) and Run All (⇧⌘↩) with one result tab per statement and an execution log.
• Per-connection query history grouped Today / Yesterday / older, plus a saved-query library with folders and favorites.
• Beautify / uglify formatting that preserves -- comments and statement boundaries.

Editing & structure

• Transactional row editing — insert, update, duplicate, and delete staged as dirty cells and committed atomically with ⌘S.
• Review Changes — the exact SQL a commit will run, shown before it runs.
• Inline schema editing — columns, types, nullability, defaults, comments, indexes, and foreign keys (PostgreSQL & MySQL).
• Table and database management — create, rename, drop; truncate behind a guarded dialog.
• User management for PostgreSQL and MySQL with a compact permissions matrix.

Import, export & settings

• CSV import with per-header mapping, preview, and validation warnings — cancellable, off the main thread.
• CSV / JSON export for tables and query results, streamed in pages with progress.
• Run .sql files directly in an editor tab; lightweight SQLite backup and restore.
• Settings — appearance and accent color, per-section fonts, per-token syntax colors with live preview, NULL/boolean display, destructive-query confirmation, and the full rebindable keymap.
• OpenObserve as a read-only source — streams browse like tables through the _search API.