Added
- Open SQLite files from the file manager's Open With, or with
tablepro file.sqlite3. (#3413) - SSH tunnels through the system OpenSSH client, with your agent,
~/.ssh/config, jump hosts and host key checks. (#3464) - Export to CSV, JSON, SQL, Excel, Markdown, HTML and XML, and import CSV. (#3464)
- Structure tab to change columns, indexes and foreign keys, with the SQL shown before it runs. (#3464)
- Saved connections with groups, colours and TLS options, and passwords kept in the system keyring. (#3464)
- Query history with full-text search, and saved queries. (#3464)
- Table grid with filters, sorting and paging, editing in place, new and deleted rows, and undo until you save. (#3464)
- SQL Server sign-in with Kerberos, using the ticket from
kinit. (#3464) - Troubleshooting in About TablePro, with the versions to paste into a bug report. (#3464)
- Open connections and their table, structure and SQL editor tabs reopen at the next launch. (#3464)
- Desktop notification when a query, save or export finishes in a tab you are not looking at. (#3464)
- SQL editor with completion, formatting, find and replace, a result per statement, and Stop. (#3464)
- Keyboard navigation of the grid, and names and states for screen readers. (#3464)
- Widen and narrow a grid column with Shift+Alt+Right and Shift+Alt+Left. (#3566)
- Commit and Roll Back beside an editor tab's open transaction, and a banner on the other tabs that names it. (#3697)
- Safe Mode per connection: Off, Confirm Writes or Read-Only. (#3706)
- TablePro is available in Vietnamese. (#3727)
- Open Referenced Row (Ctrl+J) and Show Referencing Rows in the cell menu open the rows a foreign key leads to. (#3797)
- Filters compare a binary column to a 0x hex value. (#3797)
- The SQL editor has Vim keybindings, turned on in Preferences, and :w, :e, :q and :wq act on the tab. (#3804)
- An MCP server lets AI clients on this computer use your saved connections, each with an External Clients level. (#3805)
- DuckDB files open from the connect dialog or a terminal, with tables to browse, edit and export. (#3806)
- Connect to Redis directly or through SSH, browse its keys by type and run its commands. (#3810)
- Connections take several named tags and an icon, and the connection list has a search that also matches tags. (#3811)
- Paste rows into a table with Ctrl+V or Paste in the cell menu, copied from a TablePro grid or a spreadsheet. (#3815)
- ER diagram of a schema's tables and foreign keys, with pan, zoom, movable tables and PNG and SVG export. (#3817)
- Connect to Apache Cassandra and ScyllaDB: browse keyspaces, page through tables and edit rows by their key. (#3818)
- Snippets in the SQL editor: built-in statements per engine and your own from a folder, with Tab between stops. (#3819)
- Connect to MongoDB directly, through SSH or by DNS seed list, browse collections in a grid and run shell statements. (#3820)
- Multiple cursors in the SQL editor, added with Ctrl+D, Ctrl+Shift+L, Shift+Alt+Up and Down, or Ctrl+click. (#3821)
- An AI assistant on Anthropic, OpenAI or Ollama that answers, explains, reviews and fixes SQL, and suggests as you type. (#3822)
- Filter a table by a cell's value, or exclude it, from the cell's menu. (#3836)
- Each table keeps its column order, hidden columns and widths, set from the header or the Columns dialog. (#3836)
- Find text in SQL results and key tabs with Ctrl+F. (#3836)
- Several connections open in one window, listed in a sidebar tree of groups, connections, schemas and tables. (#3856)
- Copy rows as a text table, JSON Lines, one row of SQL values, or INSERT statements without generated keys. (#3862)
- The data grid's row number header has a menu to select every row or choose the columns. (#3864)
- On MySQL and MariaDB, Structure sets the character set and collation of a table or column, and the next AUTO_INCREMENT. (#3866)
- Selecting rows shows the sum, average and count of the focused column, with every figure ready to copy. (#3877)
- The first launch after an update says so, with a What’s New button that opens About and its release notes. (#3878)
- Enum and set cells pick from a menu of the column's labels, in the grid and in Row Details. (#3880)
- Row Details sets a time, or a timestamp's time, from a clock beside the calendar. (#3881)
- Row Details shows a binary value as a hex dump, and an image as a picture above it. (#3882)
- Ctrl+E goes back to the tab shown before; hold Ctrl and press E again to go further back. (#3883)
- Importing connections first lists each one with its host, and nothing is saved until you choose Import. (#3892)
- An editor tab names its database, and its database menu moves the tab to another of the server's databases. (#3904)
- Open Database… on a PostgreSQL or SQL Server connection opens another of its databases beside it, with its own tabs. (#3905)
- Ctrl+Shift+O opens an overview of the window's tabs, where typing searches them and the menu closes them all. (#3930)
- Every other row of a data grid is shaded, with a switch in Preferences to turn it off. (#3932)
- Show or copy the CREATE INDEX statement for one index from the Indexes page of the structure tab. (#3964)
- The sidebar lists functions, procedures, sequences and triggers, and opening one shows its definition. (#3969)
- Move a grid column left or right from the keyboard with Alt+Left and Alt+Right, or from the cell and header menus. (#3974)
- A connection can set its own query timeout for the SQL editor in the connect dialog, in place of the one in Preferences. (#3977)
- A date, time or timestamp cell can be set to the database's current date or time, such as
NOW(). (#3982) - Favourite connections and the 5 opened last lead the connection list, and favourites can be reordered. (#4011)
- Connection groups nest up to 3 levels and can be renamed, deleted, and moved by drag and drop or from their menus. (#4011)
- SQL Server connections can use strict encryption (TDS 8.0), which servers set to Force Strict Encryption require. (#4012)
- Import connections and saved queries from another database app, after a review of what each one brings. (#4015)
- Searching the app grid or a software centre for MariaDB, Postgres or MSSQL finds TablePro. (#4046)
- Betas install from their own PPA and COPR project, and each GitHub release carries the .deb, .rpm and a Flatpak bundle. (#4046)
- Ubuntu 22.04 and 24.04 and other distributions install TablePro and its updates from a signed Flatpak repository. (#4046)
- Connect to PostgreSQL, MySQL and MariaDB on this computer through the server's Unix socket, with peer and socket logins. (#4048)
- Connect to a MongoDB replica set from its hosts and name, as a connection URL lists them. (#4048)
- Paste a connection URL at the top of a new connection to fill in its engine, server, login, database and TLS settings. (#4048)
- A .sql file opened from Files or the command line loads into an editor tab without running. (#4049)
- Before an update changes the format of saved connections, query history or tabs, the old file is kept beside it. (#4049)
- Truncate a table, and create or drop a database or schema, from the sidebar. (#4050)
- Export a whole database or schema to a .sql or .sql.gz file, and import a .sql or .sql.gz file, from the main menu. (#4052)
- After 30 days of use without a license, a message asks whether you would buy one. (#4053)
- Sign in to a TablePro account in Preferences > Account to see your plan, devices and teams, as on macOS. (#4053)
- TablePro shares usage data with its developers, as on macOS; Preferences > General > Privacy turns it off. (#4053)
- Rows of a query result that reads one table with its whole primary key can be edited and saved from the SQL editor. (#4055)
- Ctrl+Shift+E exports the results or rows shown in the tab in front. (#4066)