PRO Markdown Preview

Columns that store markdown can now be viewed with a rendered preview in the row detail modal. A switch lets you toggle between plain text and the rendered view; You can treat any TEXT column as markdown by cycling its type in the column header (same gesture as for date/datetime). Declared types such as TEXT MARKDOWN or MDTEXT are recognized by default.

When you open a cell in a markdown column in VS Code, the file opens with a .md extension by default, so the editor uses markdown highlighting and tooling without relying on language detection.

Additions

• PRO Backspace now sets the focused column to NULL for all selected rows
• PRO In the row detail modal, date/time columns now show the same date display as in the table

Changes

• Resized textarea heights are now remembered for the duration of the session
• Opening a DB now selects the first table (not the first item, which could be a view)
• PRO All buttons that cycle properties now reset to their default value on right-click
• PRO Pragma Editor Optimize action now defaults to "Dry Run"
• PRO Date/raw toggle in modal is now per column

Fixes

• PRO Batch edit in row detail now updates all selected rows correctly
• PRO Fixed an issue where editing a cell via "Open in VS Code" could leave the selection stuck on "No row selected"
• Ctrl+A (Cmd+A) in sidebar inputs selects all text in that input only
• View row counts in the explorer show "∞" ("N/A") for unopened views instead of 0
• PRO Deprecated pragmas are no longer shown in the Pragma Editor

• Resolved visual artifacts that appeared during hover on fieldsets in certain themes
• PRO The "Collapse All" button for inlined foreign keys now collapses every expanded level

PRO Inline Foreign Keys in Row Detail

In the row detail modal (detail view), foreign key columns can now show the referenced row inline. You can expand or collapse each FK to see and edit the linked row without leaving the modal.

• Nested references are supported: expanding an FK can reveal further FKs in that row, each with its own expand/collapse.
• Editing works inline: you can change values in the referenced row and save; updates apply to the correct table.

Additions

• Primary key tooltips now list every table that references this column via foreign key
• The left sidebar now supports the same keyboard selection behavior as the main table
• Double-clicking a table or view in the left sidebar now expands or collapses it

Changes

• Changing focus in the main view no longer scrolls the corresponding value into view in the sidebar
• Fieldsets in the sidebar no longer display a visual active state
• PRO Input field placeholders for columns with default values now display the default value or expression instead of NULL
• PRO Input field placeholders for generated columns now display the generation expression
• PRO Input fields for generated columns are now disabled
• PRO The file extension for hex files was renamed from .hexblob to .hexdump

Fixes

• The right sidebar no longer loses its scroll position when it is (auto-)closed.
• No accept-drop state when dragging a column over another table (sidebar or header).
• PRO Add Column now accepts column types that contain spaces (e.g. TEXT MARKDOWN).
• PRO Various invalid foreign key/autoincrement/generated statements can no longer be created via the 'Add Column' UI

Additions

• PRO When adding columns to an empty table that references another table's composite primary key, the table now uses a single table-level FOREIGN KEY constraint instead of inline REFERENCES on each column

Fixes

• 'Without Row ID' and 'Strict' options in the table info panel are now disabled when using the Free Version
• PRO Add Table, Add Column, Drop Table, and drop column actions are now disabled when the database is read-only instead of throwing an error
• PRO Fixes a bug when adding a PRIMARY KEY column without specifying a column type
• PRO Dropping a column that is part of a composite primary key no longer fails
• PRO Fixed renaming of columns that are part of a composite primary key
• PRO Fixed reordering columns when renaming in an empty table
• PRO Fixed JSONB default values when adding or editing columns
• PRO Fixed over-escaping of quotes in generated SQL in certain instances

PRO Table and Column Creation

You can add columns to existing tables, drop columns or entire tables, and edit column definitions when the table is empty.

• Add column: New columns can be added to any table from the column header. Tables that already contain rows use ALTER TABLE ... ADD COLUMN; empty tables may be recreated to apply the change.
• Drop column: Columns can be removed from a table via the trash icon next to each column in the table info panel. Uses ALTER TABLE ... DROP COLUMN.
• Drop table: An entire table can be dropped from the database via the "Drop table" action in the table info panel.
• Edit column (empty tables): For tables with no rows, you can edit column name, type, and constraints (NOT NULL, UNIQUE, defaults, check, foreign key, etc.) and reorder columns. The table is recreated so all schema changes are applied.

PRO Antifreeze Update

Long-running SQLite operations are now automatically cancelled when you navigate to a different view, so the UI stays responsive. This frequently happened when sorting or filtering large tables.

Improved Keyboard Selection

You can now select multiple rows using the keyboard by holding down shift while moving up/down using arrow keys.

Pressing Enter while a cell is selected will trigger the same action as double clicking it. Pressing Escape will unselect all rows.

• PRO Pressing Backspace while a data cell is focused sets that cell to NULL via the same update path as the cell editor. Pressing Delete (or Cmd/Ctrl+Backspace) deletes the selected row(s).

Row Selection Undo History

Row selection now has a undo history. You can now use standard keyboard shortcuts to revert to a previous row selection. This should be useful when accidentally deselecting.

In order to avoid clogging up VS Code's undo history, the selection history is kept separate and cleared when a real document edit takes place.

PRO Text Input Undo History

Text fields in the app now have their own local undo and redo history. This means you can use standard shortcuts to undo or redo changes made while editing an input, independent of the database history.

Additions

• Now showing row numbers for each table in the table explorer
• PRO When deleting row(s) fails due to a foreign key constraint, the error toast now offers a button to enable defer foreign keys and retry the delete.
• PRO Added dedicated UI for inputting booleans
• PRO Added filter search box to the pragma editor
• PRO Can now insert empty rows iff all columns have default values or are nullable
• PRO Can now open empty files with the viewer and they will be initialized as a SQLite databases

Changes

• Any column type with "bool" in the name will now be interpreted as boolean
• PRO Database transaction now is closed (via COMMIT or ROLLBACK) when you return to the last saved state via undo/redo

Fixes

• Fixed an issue that prevented dialog modals from opening after clicking an external link
• When resizing columns, shrinking them no longer shrinks viewport along with it
• Fixed tabbing to 'Copy to Clipboard' button in text areas
• Fixed dropped tables showing up in the sidebar even after refresh
• PRO Fixed an issue related to undoing row inserts in tables that have Row IDs.
• PRO Fixed incorrect bindings in undo statements when deleting rows containing null values
• PRO Fixed issues relating to undo/redo after file save
• PRO Fixed an issue in instant commit mode that occurred when trying to redo operations that can't be undone

Theming

• Fixed selected row background color missing in certain themes like Catpuccin
• Using focusBorder as a fallback focus outline for themes that don't define list.focusOutline (e.g. Catpuccin)
• Fixed row selection borders missing in high contrast themes

Browse the complete changelog to see all features, bug fixes, and improvements across every version of SQLite Viewer PRO.