tpaw/Changelog

Changelog

New features, improvements, and bug fixes for every release.

Last updated 2026-05-12

v1.26.0

2026-05-12

Filter Popover Refresh

Feature
  • Column and operator pickers are now typeable comboboxes — start typing to filter the list, ↑↓ to navigate, Enter to pick
  • ⌘F opens the filter popover directly with the cursor ready for the column name
  • Tab moves cleanly between column → operator → value without losing focus to the sidebar

More Filter Operators

Feature
  • "does not contain" and "does not contain (ignore case)" join the operator list
  • "is one of" / "is none of" — type comma-separated values (e.g. alice, bob, charlie) to match multiple values at once

v1.25.0

2026-05-11

Background Save

Feature
  • Bulk UPDATE/DELETE in the data grid now runs in the background — the confirmation modal closes immediately and a status-bar badge tracks progress so you can keep working in other tabs
  • Completion toast confirms the save; on failure your unsaved changes stay intact for retry
  • Rows being saved are visually locked (dimmed + uninteractive) so they can't be accidentally re-edited mid-flight

Data Grid Interactions

Feature
  • ⌫ / Delete stages the selected rows for deletion (table must be unlocked)
  • Cell focus, modification, and error styles use rounded edges instead of hard 3px bars; modified rows get a small amber dot in the row-number gutter

Multi-Query Results

Fix
  • The first block of a multi-statement query (separated by `;`) used to render empty — fixed; blocks now size to their row count, capped at 300px

Command Bar

Refactor
  • Tables surface first in connection-level search so Enter jumps straight to the table
  • Fuzzy matching is slightly stricter (threshold 0.35) — fewer accidental hits

Editor & Settings

Feature
  • New "Editor font size" preset row in Settings → General (11 to 16 px, default 13); applies to the Monaco SQL editor on save
  • Bulk-save SQL preview wraps multi-statement batches in BEGIN; / COMMIT; to make the transaction explicit

Typography Tokens

Infrastructure
  • 8-step --font-* scale replaces 1,113 hard-coded font-size declarations across the app; future global typography tweaks are now a one-file change

v1.24.1

2026-05-08

Window Dragging

Fix
  • Drag the window from any non-button area of the global action bar — text labels, badges, and empty space are now all valid drag handles

v1.24.0

2026-04-14

Query Result Visibility

Feature
  • UPDATE result grid now pulls changed columns to the front so diffs are visible without horizontal scrolling

Keyboard Shortcuts

Fix
  • DML confirmation modal now responds to ⌘↵ (Cmd+Enter) — the Execute button is focused on open so the shortcut fires immediately

v1.23.0

2026-04-11

AI Metrics & Feedback

Feature
  • Define reusable business metrics (dimensions, measures, tables, filters) per connection
  • AI SQL generation now uses your metric definitions and learns from past successful queries
  • Rate generated SQL thumbs up/down with the new feedback bar to improve future results
  • AI responses include plain-language explanations and show which metric was used

Roles & Metrics Pages

Feature
  • Dedicated Roles page — create, edit, and manage PostgreSQL roles in one place
  • New Metrics sidebar section to browse and author metric definitions
  • Role creation modal with built-in password generation

Grid Popover & Filter Fixes

Fix
  • Filter and sort popovers position correctly at non-100% browser zoom (110%, 130%, etc.)
  • Cleaner confirmation dialog handling for unsaved edits when sorting, paginating, or refreshing
  • Filter handlers no longer trigger unintended side-effects during state updates

v1.22.0

2026-04-08

Column Reorder

Feature
  • Drag column headers to rearrange display order
  • Column order persists across tab switches
  • Visual drop indicator and column highlight during drag

v1.21.1

2026-04-06

Update Notifications

Refactor
  • Non-intrusive status bar badge replaces toast popups
  • Auto-show popover when update detected — click to download or dismiss

v1.21.0

2026-04-06

Auto-Update

Feature
  • App checks for updates on startup and notifies via toast
  • Download & install updates without leaving the app
  • Check for Updates button in Settings > About

v1.20.0

2026-04-05

Save All (⌘S)

Feature
  • Save every pending edit across open and closed tabs in one confirmation
  • Closed tabs keep their edits in the pending bar until you save or discard
  • Reopening the same table restores your edits where you left off
  • Unified ⌘S shortcut replaces per-tab save — works everywhere

Session Replay

Feature
  • Save All mutations now appear in session replay with full before/after data

Feedback

Feature
  • Send feedback or report bugs directly — opens a GitHub issue from the app

Enum Dropdown

Fix
  • Opens at the correct position on first click

v1.18.0

2026-03-30

Chart Visualization

Feature
  • Visualize query results as Bar, Line, Combo, or Pie charts
  • Smart defaults — auto-detects best chart type from column types
  • Inline toolbar for chart type, X/Y axis configuration
  • Grid/Chart toggle in results status bar

v1.17.0

2026-03-27

Data Grid

Feature
  • Duplicate row (⌘D) — opens insert modal pre-filled with all values from the selected or focused row

v1.16.0

2026-03-27

Command Bar

Feature
  • Fuzzy search in ⌘K command palette — type partial matches like "usr" to find "users"

v1.15.0

2026-03-27

Data Export

Feature
  • Export table data as CSV, JSON, or SQL from the toolbar

Settings

Feature
  • Open source licenses viewer in Settings — About

UI Fixes

Fix
  • Fixed broken focus ring on data grid scroll area
  • Sidebar settings button now matches other menu item sizes

v1.14.1

2026-03-26

Command Bar

Fix
  • Fixed search icon overlapping placeholder text in the home search bar

v1.14.0

2026-03-26

Mutation Result View

Feature
  • INSERT queries now show inserted rows in the results pane
  • UPDATE queries show a diff view — old values (strikethrough) and new values (green) side by side
  • DELETE queries show deleted rows before removal
  • Color-coded gutters: green for INSERT, blue for UPDATE, red for DELETE
  • Status bar shows rows affected, cells changed (UPDATE), and execution time

Session Replay

Fix
  • Accessed tables section now starts collapsed by default
  • Expandable with chevron toggle, scrollable list capped at 4 visible rows

v1.13.0

2026-03-24

Sidebar Enhancements

Feature
  • Collapsible group headers — click Workspace, Database, or Monitor to collapse/expand. State persists across restarts
  • Arc-style pinned favorites grid — up to 8 favorite tables shown as square cards below the search filter
  • Right-click a pinned favorite to remove it

Input & Select Consistency

Refactor
  • Migrated ~60 native inputs to StyledInput with hover glow effect
  • Migrated 7 native selects to StyledSelect with custom dropdown
  • StyledInput now supports size="lg" variant for prominent search bars
  • Added StyledToggle for SSH tunnel, safe mode, and backup schedule toggles

Command Bar

Fix
  • Escape now closes the command bar immediately from any level
  • Home search bar uses large input variant with hover glow

v1.12.0

2026-03-24

UI Zoom

Feature
  • Adjustable UI zoom (80%–130%) in Settings — scales the entire app proportionally via CSS zoom
  • Preset buttons for quick selection, instant preview while settings are open
  • Zoom persists across restarts with flash-free initialization

Onboarding Improvements

Feature
  • Fixed-height FirstRunModal (540px) with pinned footer buttons
  • URL parse warnings — missing database, username, or password detected and auto-expands manual fields
  • Unsupported database scheme detection (MySQL, MongoDB, etc.) with clear messaging
  • Large keyboard badge for ⌘K prompt with pulse animation
  • Safety step now advances to ⌘K experience instead of closing the modal
  • Walkthrough opens automatically after onboarding completes

Home Screen

Feature
  • Feature cards on empty state — Session Replay, Schema Diff, Explain Plan
  • Clicking a card opens the walkthrough to that specific category
  • Subtle radial gradient background for visual depth

Styled Components Migration

Refactor
  • Migrated ~60 native inputs to StyledInput across all forms and search fields
  • Migrated 7 native selects to StyledSelect with custom dropdown UI
  • Migrated toggle checkboxes to StyledToggle (SSH tunnel, safe mode, backup schedule)

Bug Fixes

Fix
  • Filter dropdowns now show columns when query returns zero rows
  • Error hints unified across FirstRunModal, ConnectionForm, and connect toasts
  • Fixed [object Object] in error display for Tauri IPC errors

v1.11.0

2026-03-23

Feature Discovery Panel

Feature
  • Raycast-style walkthrough — standalone modal with animated category cards and step-by-step feature guides
  • Comprehensive feature catalog covering Query Editor, Schema Browser, Data Grid, Session Replay, Dashboard, and more
  • Each feature shows keyboard shortcuts and quick tips in a focused detail view

Walkthrough Architecture

Refactor
  • Walkthrough extracted from Command Bar into a standalone modal component
  • Simplified useWalkthrough hook — removed step tracking, now manages open/close state only

Quality

Fix
  • Accessibility improvements — focus trap, aria labels, keyboard navigation in walkthrough
  • Reactivity fixes for category selection and detail view transitions

v1.10.0

2026-03-23

Query Safety

Feature
  • Per-connection statement timeout — tag-based presets: production 30s, staging 60s, development 120s
  • Auto row limit for SELECT queries — production default 1000, staging 5000. Configurable per connection
  • Dangerous query detection — DELETE/UPDATE without WHERE shows warning, DROP/TRUNCATE require typing the object name to confirm

Cloud Quick Connect

Feature
  • Paste a Supabase, Neon, Railway, or Render connection string and it auto-detects the provider, sets SSL to require, and fills the connection name

JSONB Tree Editor

Feature
  • Expand any JSON/JSONB cell to see a full tree view with color-coded types (string, number, boolean, null)
  • Inline editing: double-click values, add keys/items with +, delete with trash icon
  • Cmd+F search in tree mode auto-expands matching paths with yellow highlight
  • Tree/Raw toggle syncs edit state bidirectionally
  • Copy JSON path to clipboard from any node

Settings Panel

Refactor
  • New Query tab with per-connection timeout and row limit controls
  • Draft-based Save/Cancel pattern — changes are staged, not applied immediately
  • Toast notification on save showing what changed
  • Panel enlarged to 840×600

v1.9.1

2026-03-22

Explain Plan Insights

Feature
  • Typeless-inspired InsightsPanel redesign — elevated cards with rounded corners, subtle shadows, and severity icons
  • SQL suggestion blocks now have a copy-to-clipboard button (appears on hover)
  • Insights panel moved to scroll area, collapsed by default, auto-expands in fullscreen
  • Fullscreen mode no longer overlaps macOS traffic lights

Backup & Recovery

Fix
  • 1-hour scheduled backup interval option added
  • Schedule backup popover now renders above other UI elements
  • Backup & Restore temporarily disabled for reliability rework

UI Improvements

Refactor
  • Removed Focus Mode (sidebar collapse provides the same UX)
  • Activity Detail error area is now scrollable for long error messages

v1.9.0

2026-03-21

Interactive Onboarding

Feature
  • Read-only connections now get a guided onboarding: try ⌘+K to search tables, preview real data, and see session replay in action
  • Cmd+K step detects actual keypress — type to search, arrow keys to navigate, Enter to select
  • Preview step shows real data from the selected table in a compact mini-table
  • Replay step plays a live timeline with 22 mixed queries (SELECT/INSERT/UPDATE/DELETE) appearing as the playhead moves
  • Removed the "Create dedicated user" prompt from read-only connection onboarding

v1.8.1

2026-03-21

Keychain Password Storage

Feature
  • Connection passwords are now stored in the macOS Keychain instead of plaintext JSON
  • Automatic fallback to plaintext storage when keychain is unavailable (unsigned dev builds)
  • SSH tunnel passwords and key passphrases are also secured in the keychain
  • Existing connections migrate to keychain on next save (lazy migration)

Security

Fix
  • Lost keychain entries now show a clear "re-enter password" message instead of cryptic auth errors
  • Runtime codesign detection ensures keychain is only used with Developer ID signed builds

Build

Infrastructure
  • macOS minimum version set to 11.0 (Apple Silicon only)

v1.7.1

2026-03-20

Replay Page Redesign

Feature
  • Favorites-style page header with session count and refresh button
  • Intro card explaining session recording, query review, and rollback
  • Consistent layout matching all workspace pages

v1.7.0

2026-03-20

Schema Diff (Beta)

Feature
  • Inspect-first architecture — atlas schema inspect as primary path (always succeeds)
  • Object-level summary table with +/−/~ indicators for added, removed, modified objects
  • Chip filters (Added / Removed / Modified) and object search
  • Click any row to view per-object DDL diff in a compact modal
  • Full schema diff in near-fullscreen modal via "View Full Diff" button
  • Monaco DiffEditor with side-by-side DDL comparison
  • Optional migration SQL section when atlas schema diff succeeds
  • DDL sorted alphabetically (TYPE → TABLE → INDEX) for consistent diff alignment
  • All 4 themes supported (Midnight, Cursor, Ice Tiger, Ice Tiger Light)
  • ESC to close modals, word wrap in per-object view

Command K Integration

Feature
  • Schema Diff action available in command palette (⌘K)

UX Polish

Feature
  • Intro card explaining Source/Target and usage
  • Cmd+F focuses search input
  • Source → Target connection names shown in modal header
  • Sidebar: Schema Diff in Workspace section (after Replay)
  • Page layout matches Favorites/Recents/Saved/Variables style

Schema Diff Quality

Fix
  • isEmpty now trusts Atlas diff result over DDL string comparison
  • Whitespace-normalized comparison prevents false "modified" flags
  • DDL block splitting correctly assigns comments to their CREATE statement
  • Object DDL extraction matches only CREATE lines (not comments)
  • StyledSelect replaces native <select> in connection pickers

v1.5.2

2026-03-18

Session Replay — DataGrid Browse Tracking

Feature
  • Table browsing, filtering, sorting, and pagination in DataGrid are now recorded as session events
  • Events appear in the Replay timeline alongside query and mutation events
  • Silent reloads (post-mutation refresh) are excluded to keep the timeline clean

Auto-Reconnect on Startup

Feature
  • App automatically reconnects to the last active connection when restarted

Connection Stability

Fix
  • Fixed auto-connect race condition that could cause duplicate connection attempts
  • Last active connection is now cleared on disconnect to prevent stale reconnects

v1.5.1

2026-03-18

Connection Form UX

Feature
  • Inline validation — red border + error message on empty required fields when Save or Test is clicked
  • Database field is now optional (only Name, Host, Username are required)
  • Test button moved between Cancel and Save for better flow
  • Field hover background removed for cleaner look

Copy as URL

Feature
  • Right-click a connection to copy its PostgreSQL URL (includes password)

Connection String Fix

Fix
  • Empty database field no longer falls back to "postgres" in the connection string display

v1.5.0

2026-03-18

Multi-Query Results

Feature
  • Cmd+Shift+Enter runs all statements and shows each result in a collapsible block
  • Block header displays statement number, SQL keyword, row count, and execution time
  • On error, all previous results are preserved alongside the error block (stop-on-first-error)
  • Cmd+Enter single-statement execution remains unchanged

v1.4.0

2026-03-18

Notion-style Query Toolbar

Feature
  • Ghost buttons with Lucide icons — clean, minimal, hover-to-reveal
  • Group dividers between functional sections
  • Active state indicator on Saved toggle

Saved Queries Panel Redesign

Feature
  • Notion-inspired side panel with ghost inputs and icon entries
  • Description field — add optional notes when saving queries
  • Hover-reveal delete button with trash icon
  • Auto-focus on query name input when panel opens
  • Improved empty state with icon and hint message

Smart Tab Naming

Feature
  • Tabs opened from Saved, Favorites, or Recents show the query name as tab title
  • Subtitle shows "Saved Query" for context

v1.3.0

2026-03-18

Reserved Word Autocomplete

Feature
  • Tables with PostgreSQL reserved-word names (user, order, group, etc.) are schema-qualified in autocomplete
  • e.g. "user" inserts as public."user" to avoid parser conflicts
  • Reserved words are also double-quoted when used as identifiers

v1.2.0

2026-03-18

JSON Filter Operators

Feature
  • Filter JSONB columns with specialized operators
  • GIN index usage warnings for unindexed JSON columns

Autocomplete Connection Fix

Fix
  • Fixed autocomplete showing wrong connection's schema when switching between multiple connections
  • Completion provider now tracks active connection via module-level state

v1.1.0

2026-03-17

Focus Mode

Feature
  • ⌘⇧F to toggle distraction-free editing — hides sidebar and tab bar
  • Toggle button in the action bar with active state indicator

Connection Environment Badges

Feature
  • Colored tag dots on connection cards (prod/staging/dev/local)
  • Tag pill badge in connection detail header

Query History Tape

Feature
  • Date-grouped timeline (Today, Yesterday, This Week, etc.)
  • Execution time badges with color coding (green/yellow/red)
  • Success/error icons and inline error messages
  • Open in Editor action for query entries
  • Flat A-Z list when sorting by name

Visual EXPLAIN Visualizer

Feature
  • Explain button now outputs FORMAT JSON for structured data
  • Interactive plan tree with cost-colored nodes
  • Each node shows Node Type, Cost, Rows, and Actual Time
  • Summary bar with Planning Time and Execution Time

ERD Schema Graph

Feature
  • SVG-based table nodes with column list, PK/FK badges
  • Foreign key relationships as curved edge paths
  • Draggable nodes with scroll-aware coordinates
  • Schema-filtered view from schema detail (View Diagram button)
  • Error state with retry for failed schema loads

Saved Queries Enhanced

Refactor
  • Description and category fields for better organization
  • Snippets functionality merged into Saved Queries

Quality Improvements

Fix
  • Atomic file writes with mutex for saved queries
  • Calendar-based date grouping (midnight boundary fix)
  • Cross-schema FK edge routing in ERD
  • Error handling with retry for ERD and snippet loads
  • Focus mode auto-reset on Home navigation

v1.0.0

2026-03-16

First-Run Onboarding

Feature
  • URL-paste connection flow — paste postgres:// to auto-fill
  • Manual entry with SSH tunnel, SSL, environment tags
  • Smart error hints for common connection failures
  • Auto-generated connection names from host/database

Core Features

Feature
  • Schema browser — tables, views, sequences, enums, functions, extensions, roles
  • SQL editor with Monaco, multi-statement execution, query history
  • Data grid with in-cell editing, sorting, filtering, JSON expansion
  • Command palette (⌘K) — jump to tables, views, and schema objects
  • Dashboard — active queries, slow query detection, connection stats
  • Backup/restore with pg_dump integration
  • Session recording and replay

Infrastructure

Infrastructure
  • SSH tunnel support for remote connections
  • Read-only safe mode with dedicated user wizard
  • OS keychain credential storage
  • Multiple themes — Ice Tiger, OLED Black, Shades of Purple