Changelog
What's new in DB Atelier.
Improved - 243 unit tests added
- PostGIS USER-DEFINED type handling
Fixed - Respect custom host/port for Oracle and ClickHouse extensions
- Sync extension connection config to top-level fields for display
- Handle geometry columns in DuckDB fetch_table_data
- Move INSTALL/LOAD spatial to DuckDB connection time
Fixed - Version bump for Oracle extension
New - Geospatial data visualization with MapLibre GL
- ScyllaDB / Cassandra extension
Improved - Map styling with design tokens and geo feature toggle
- MongoDB relaxed JSON and server-side schema inference
Fixed - Support rediss:// and mongodb+srv:// connection strings
- Oracle Instant Client library loading on hardened macOS apps
Improved - Complete extension list displayed in UI
- Oracle extension hardened
New - Home button to navigate back without disconnecting from the database
Fixed - Insert Row and Duplicate Row becoming unresponsive after switching databases
- Redis key browser not showing when database has no colon-prefixed keys
- Scroll not propagating to scrollable parents on Windows
- Missing column_reorder field in extension SchemaCapabilities
New - ClickHouse extension — connect to ClickHouse databases with full querying and schema browsing
- MongoDB extension — full document database support with schema context awareness
- Oracle database extension
- Dashboard Builder extension with per-database persistence
- MySQL EXPLAIN visualizer with tree and flamegraph views
- MySQL column reordering with drag-and-drop UI
- Excel-like cell-level keyboard navigation in DataGrid
- Read-only full cell value viewer in results table
- Pre-connect shell script feature for custom setup before connecting
- Linux build support
- New keyboard shortcuts — pane navigation, new tab, focus editor, find, and tab switching
Improved - Update flow now prompts for manual restart instead of auto-restarting
- Free extension limit increased to 3
Fixed - Table icons now display correctly for DuckDB and ClickHouse (were showing folder icons)
- Schema context correctly passed through execute_query for MongoDB
New - Redis extension — connect to Redis databases with full key browsing, value previews, and Redis command editor
- Hierarchical key browser — collapsible prefix tree in sidebar, paginated data grid for key browsing with filtering and sorting
- Redis syntax highlighting in query editor
- Extension-driven context menus and entity labels — UI adapts per database type
Improved - Schema browser supports tree mode for hierarchical namespaces
- Command palette and empty state text adapt to the connected database type
New - Table filter input in schema browser — instant search across tables and views
- MCP server available for all users (read-only without license, full access with license)
Improved - Delete pending insert rows via context menu without committing first
- MCP connection access UI with hover states and clearer read-only indicators
New - Multiple result sets and persistent query history
Improved - Smart SQL column completion — infers columns from FROM/JOIN clauses, with alias and CTE support
- Tab key inserts tab character in query editor
Fixed - Enter key now preserves indentation level in query editor
- Text selection in data grid and results table cells
New - EXPLAIN/ANALYZE visualization with tree and flame graph views
- SQL autoformat button in query editor toolbar
- DuckDB EXPLAIN/ANALYZE support
Fixed - MySQL stuck at "Loading schema..." upon editing tables
New - UI zoom setting (80%–150%) in Appearance settings
- CHECK constraint popover for entering and editing expressions
- Optimistic schema save — UI updates instantly without waiting for server round-trip
Improved - PK pill shows pending-drop state with strikethrough and undo
- Save button shows loading state and disables Discard during save
- Resizable columns in schema index table
Fixed - DuckDB TIME, DATE, and TIMESTAMP columns display as formatted values instead of raw numbers
- DuckDB extension handles null filter/sort params correctly
- Column resize guide no longer extends through the Add Column button
- CHECK constraint pills no longer double-wrap expressions
Improved - Connection form defaults username per database engine (root for MySQL, postgres for PostgreSQL, sa for SQL Server)
- Connection form updates port and username when switching database type
- Popup cell editor now triggers based on content length instead of column type
Fixed - Space key no longer toggles row checkbox when editing a cell inline
New - Extensions can now embed custom panels using HTML, CSS, and JavaScript via the Atelier SDK
- Windows support with native custom titlebar and window controls
New - Extension system — install third-party extensions (.dbaext) to add custom panels and tools
- User-configurable extension parameters with popover UI
Improved - Row navigation uses ctid for more reliable positioning in PostgreSQL
New - Schema table editor — edit columns, constraints, primary keys, and foreign keys inline
- Composite primary key support with capability-driven UI gating per database engine
- Inline FK badges and PK toggle in schema editor
- Resizable columns in schema table editor
- Foreign key quick peek — hover an FK cell to preview referenced rows
- FK peek pagination, row count, matched-column highlight, and jump to referenced row
- FK chain navigation — follow foreign keys across multiple tables in the peek popover
- Configurable FK peek page size in Settings
- Data font size setting
Fixed - DuckDB constraint grouping uses correct constraint index
- Schema change counter scoped to current table
- Context menu correctly differentiates views vs tables
- SQLite stale schema cache after saving foreign keys
New - SSH multi-jump — connect through bastion/jump servers
- Database-scoped saved queries with nested folder system
- MCP tools: get_schema_summary, get_erd, manage_query_folders, manage_saved_queries
- MCP tool: manage_query_tab — AI agents can create and open query tabs
- Granular MCP settings — control which tools are available to AI agents
- Deselect All button in data grid toolbar
Improved - MCP read-only enforced at database connection level instead of SQL keyword whitelist
- Open editor tabs stay in sync when saved queries change via MCP
Fixed - DuckDB shared database instances and read-only enforcement
New - MCP tools: manage_query_tab (open/create query tabs) and manage_saved_queries (list/get/update/delete)
New - MCP Server — let AI agents query your databases via the Model Context Protocol
- Import data from CSV/JSON files into any table
- View/Edit Row detail panel — right-click any row to inspect all fields
- Run selected SQL — select a block in the query editor and run just the selection
- Start/Stop MCP Server from Cmd+K command palette
- Running queries and pending changes count badges on bottom panel tabs
- Functions and saved queries sections in schema browser
Improved - Pending changes moved to bottom panel for better workflow
- MCP connections are pooled — parallel agent requests get isolated connections
- Reliable spinner and table reload when switching databases
- Schema browser accordion-style layout
Fixed - DuckDB no longer hangs when GUI and AI queries run concurrently
- Database connection leak on MCP server stop and disconnect
- Postgres metadata queries use simple query protocol (fixes edge cases)
- Deleting a table now closes its associated tabs
- MCP button no longer appears after license removal
New - Popup cell editor for JSON/JSONB/text columns
- Row focus highlight — click a row or navigate with arrow keys (Up/Down cycles through rows)
- Keyboard row selection — Space toggles checkbox on focused row
Improved - Improved rendering for large table
Fixed - Renaming a saved query from the sidebar now updates the tab title immediately
- Large JSON/JSONB cells no longer cause UI lag
New - ERD focus mode — click a node to highlight its connected neighbors as a subgraph
- ERD find node — Cmd+F to search and jump to any table in the ERD
Improved - ERD performance — viewport culling and batched schema loading
- ERD zoom-out capped to prevent memory issues on large schemas
New - Toggle to move DB password from/to OS keychain/encrypted config file
- Clickable breadcrumb. For some DB like PostgreSQL, users can switch database in the same connection (if there are multiple of them, sharing same credentials)
- Allow setting base_url for AI providers
Improved - Cmd+B for toggle expand allows keyboard navigation
- Ctrl+tab/ctrl+shift+tab to cycle through tabs within the active pane
- Smoother ERD rendering: loading and animated autolayout
- Allow editing, deleting, and disconnecting connection from connection selector in the main editor without navigating to home screen
Fixed - Unwanted autocapitalization and possibly autocorrect
New - Export to CSV and SQL, delete, and truncate. Accessible from right clicking on table name schema browser.
Fixed - Wrong placement of column resize handle highlight in views
Fixed - Traffic light repositioning for Tahoe
New - Initial closed beta release