tpaw/Changelog

Changelog

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

Last updated 2026-03-24

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