github TableProApp/TablePro linux-v0.1.0-beta.4
TablePro for Linux 0.1.0-beta.4

pre-release2 hours ago

Added

  • Open SQLite files from the file manager's Open With, or with tablepro file.sqlite3. (#3413)
  • Saved connections with groups, colours and TLS options, and passwords kept in the system keyring. (#3464)
  • Keyboard navigation of the grid, and names and states for screen readers. (#3464)
  • Table grid with filters, sorting and paging, editing in place, new and deleted rows, and undo until you save. (#3464)
  • SSH tunnels through the system OpenSSH client, with your agent, ~/.ssh/config, jump hosts and host key checks. (#3464)
  • Desktop notification when a query, save or export finishes in a tab you are not looking at. (#3464)
  • Query history with full-text search, and saved queries. (#3464)
  • SQL Server sign-in with Kerberos, using the ticket from kinit. (#3464)
  • Structure tab to change columns, indexes and foreign keys, with the SQL shown before it runs. (#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)
  • Export to CSV, JSON, SQL, Excel, Markdown, HTML and XML, and import CSV. (#3464)
  • SQL editor with completion, formatting, find and replace, a result per statement, and Stop. (#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)
  • Find text in SQL results and key tabs with Ctrl+F. (#3836)
  • Each table keeps its column order, hidden columns and widths, set from the header or the Columns dialog. (#3836)
  • Filter a table by a cell's value, or exclude it, from the cell's menu. (#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)
  • Ubuntu 22.04 and 24.04 and other distributions install TablePro and its updates from a signed Flatpak repository. (#4046)
  • Betas install from their own PPA and COPR project, and each GitHub release carries the .deb, .rpm and a Flatpak bundle. (#4046)
  • Searching the app grid or a software centre for MariaDB, Postgres or MSSQL finds TablePro. (#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)
  • TablePro shares usage data with its developers, as on macOS; Preferences > General > Privacy turns it off. (#4053)
  • 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)
  • 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)
  • Switch between Data and Structure from a table tab’s bottom bar while keeping unsaved changes in each view. (#4108)
  • A table tab's Structure view shares the tab's bottom bar instead of stacking a second one. (#4111)
  • Row Details marks a primary key field with a key, and a field holding an unsaved edit with a pencil. (#4112)
  • Search Row Details by field name or value, or show only fields with unsaved edits. (#4113)
  • The sidebar has a Favorites scope listing the saved queries of the connection in front. (#4114)
  • A favorite is renamed or deleted from the Favorites list, with a right click, F2 or Delete. (#4115)
  • The sidebar toggle stays in the header while the sidebar shows, so it collapses from there. (#4117)
  • The bottom bar has a Columns button that opens the column chooser. (#4118)
  • A table tab's paginator says how long the page took to read. (#4119)
  • Open Quickly (Ctrl+Shift+O) finds tables and views across the connection’s schemas. (#4121)
  • A table tab's bottom bar has a JSON view of the rows on screen. (#4122)
  • The header has a lock that shows the connection's Safe Mode level and changes it. (#4124)
  • Refresh the current table, key or diagram from the header. (#4125)
  • The header has Save Changes for table edits, table structure and editable query results. (#4126)
  • Highlight Rules in the bottom bar colour the rows or cells that meet a condition. (#4127)
  • The data grid draws in the colours of the editor's style scheme. (#4128)
  • Highlight Rules are kept for each table across restarts, including database files and other databases. (#4129)
  • Organize saved queries in folders in the Favorites sidebar. (#4130)
  • Row Details marks foreign key fields and announces their key roles to screen readers. (#4131)
  • Open Quickly finds saved queries by name and opens them in a new editor tab. (#4133)
  • Data grid preferences set whether rows are numbered, how tall a row is and what a NULL shows. (#4134)
  • The data grid has its own cell font setting in Preferences under Data Grid. (#4135)
  • Preferences can set the format Copy writes when several rows are selected, as TSV, JSON, CSV or Markdown. (#4137)
  • Preferences can open the row details pane whenever a row is selected. (#4138)
  • Session Menu puts database commands beside the workspace, with app commands in Main Menu. (#4139)
  • Preferences can sort a table by its primary key or first column when it opens, ascending or descending. (#4140)
  • Cells and value fields mark zero-width, control and special space characters, which Preferences can turn off. (#4141)
  • Preferences can show dates and timestamps in cells as ISO, US or EU dates, with or without the time. (#4142)
  • Open Quickly finds successful past queries by their SQL and opens them in a new editor tab. (#4144)
  • A tablepro command runs queries, lists and describes tables, exports them and prints shell completions. (#4145)
  • Database links such as postgresql:// open in TablePro once you confirm them. (#4145)
  • The sidebar has an Add button below the tree for a new table, schema or database in the connection in front. (#4146)
  • Import from Another App reads the connections and saved SQL of DBX; its passwords stay in the system keyring. (#4147)
  • The sidebar's Schemas button chooses which schemas it lists, and remembers the choice for each connection. (#4150)
  • The sidebar can be widened by dragging its edge or with the arrow keys, and every window keeps that width. (#4155)
  • Each field in the row details has a button that copies its whole value. (#4156)
  • Each field in the row details has its own menu to set it to NULL, DEFAULT or empty, or copy it. (#4158)
  • Set to Default on a saved MongoDB row removes the field. (#4208)
  • Preferences > MCP lists AI clients, shows whether each one reaches TablePro, and sets it up or copies its setup. (#4211)
  • Share Result masks the columns that look sensitive before a link is made, with Keep, Mask or Remove for each column. (#4253)
  • Share a query or a result as a public link, and open shared links in TablePro. (#4253)
  • Import SQL File loads PostgreSQL COPY blocks in CSV or with options, and large blocks load faster. (#4258)

Changed

  • Saved queries keep their folder, keyword, and order when replaced. (#4116)
  • Set to Empty, NULL, DEFAULT or an expression changes every selected row in one undo step. (#4136)
  • The software center listing says TablePro works without an account or a license, and when it asks you to buy one. (#4152)
  • Row details edit a field in its own row instead of in an editor under the list. (#4157)
  • The sidebar lists a schema's views, sequences, routines and triggers in a row for each kind, above its tables. (#4159)
  • A query run stops keeping rows once they pass 256 MB, and the banner over a result says when that cut it short. (#4201)
  • SQL editor queries on PostgreSQL and table pages wait on the server fewer times, which shows on slow links. (#4224)

Fixed

  • Preferences > Account called the Pro plan Starter. (#4082)
  • The device limit dialog says TablePro keeps working here if you remove no device. (#4082)
  • The app icon was a placeholder grid instead of TablePro's logo. (#4085)
  • Connecting with a saved password in the Flatpak no longer hangs when the keyring is locked or missing. (#4091)
  • Remember Password failed silently when the keyring could not save the password, as with no default keyring. (#4105)
  • Picked editor schemes could differ from their previews and make code blocks and value placeholders hard to read. (#4109)
  • Row numbers scrolled out of view when columns were scrolled sideways. (#4110)
  • Dragging the results up no longer hides the query: the editor keeps a few lines. (#4120)
  • The sidebar could select the wrong database after a query tab changed databases. (#4132)
  • Opening a database link showed its password on a page saying the file was not on this computer. (#4145)
  • tablepro --new-window with files dropped the files when TablePro was already running. (#4145)
  • A long right-click menu, such as a table's in the sidebar, was cut short with a scrollbar in the middle of the screen. (#4149)
  • Software centers showed no screenshots for TablePro from the TablePro Flatpak repository. (#4152)
  • A change to connections.json made outside TablePro while it ran was undone on the next connect. (#4176)
  • A ClickHouse login whose profile sets readonly=1 could not connect. (#4176)
  • Exporting a MySQL or MariaDB editor query that matched no rows wrote a file without its header. (#4180)
  • A MySQL or MariaDB query that matched no rows showed as a command, without its column headers. (#4180)
  • Connecting to a host whose first address did not answer timed out instead of trying its next address. (#4180)
  • An MCP client that gave up on a row count or a table lookup left it running and holding the connection. (#4180)
  • On MySQL and MariaDB, SELECT ... INTO OUTFILE in the editor wrote only as many rows as the editor's row limit. (#4180)
  • An MCP client reading rows with very large values could make TablePro use gigabytes of memory. (#4180)
  • CSV export put a single quote before values starting with =, +, - or @ by default, which then stayed in imports. (#4185)
  • Editing a number in a MongoDB collection could change its stored type, such as saving an int as a long. (#4201)
  • The banner over a PostgreSQL result cut at the row limit said the statement ran no further than the rows shown. (#4201)
  • Editing a MongoDB field that holds more than one number type changed the edited value's type. (#4202)
  • Exporting a MongoDB collection left out fields that none of its first 1,000 documents held. (#4202)
  • A MongoDB DNS seed list logged in to admin instead of the database its TXT record names. (#4202)
  • MongoDB UUID fields opened as JSON instead of UUID columns. (#4202)
  • A read-only MongoDB connection let validate with repair through. (#4202)
  • New MongoDB documents got an explicit null for every field left empty, which sparse and partial indexes count. (#4202)
  • With Safe Mode off, MongoDB index, user and role drops, $out and other collection replacements ran without asking. (#4202)
  • After a reconnect, MongoDB fields of mixed types showed as plain values and an edit could change their type. (#4202)
  • Stopping a MongoDB statement on an Atlas free or Flex cluster did not stop it. (#4202)
  • MongoDB statements from Copy As or an export stored values such as NumberLong as nested documents in mongosh. (#4208)
  • Duplicating, pasting or importing MongoDB rows wrote null for fields the source documents did not have. (#4208)
  • With Safe Mode off, a MongoDB $merge into the collection it reads ran without asking. (#4208)
  • The MCP page copied the access token without its Bearer scheme, and offered no Regenerate while the server was off. (#4211)
  • Scrolling a table with highlight rules was slow when its rows had many columns. (#4224)
  • Deleting thousands of pasted rows at once froze the table tab. (#4224)
  • Locked-keyring errors omitted the steps to create a default keyring. (#4234)
  • The keys pointing at a table could miss a table while another program changed the SQLite file's schema. (#4291)

Security

  • tablepro export printed control codes stored in the database to the terminal, where they could run. (#4145)
  • While a connection was reconnecting, Safe Mode read SQL by PostgreSQL's rules and could miss a write to ask about. (#4176)
  • The MCP server answers only programs running as your user, so a leaked access token does not work from another account. (#4211)
  • An MCP client could read or write any file through a DuckDB connection. (#4219)
  • Safe Mode missed a DuckDB statement hidden after a non-breaking or zero-width space. (#4239)
  • Safe Mode missed a PostgreSQL statement hidden after a routine named begin or one that names a begin column. (#4254)
  • At Read-Only, a function a query called could make a MySQL or MariaDB connection writable for the next query. (#4264)
  • Reading a table's keys or structure in a crafted SQLite or DuckDB file could take gigabytes of memory. (#4287)
  • A crafted SQLite file could make reading its structure take gigabytes of memory or minutes of CPU. (#4291)
  • Opening or browsing a DuckDB file with deeply nested constraints, defaults or views could crash the app. (#4293)

Don't miss a new TablePro release

NewReleases is sending notifications on new releases.