Feedback, UX Improvements, and Bug Reports

[lmalma]

Hello TablePlus team,

First, thank you for this excellent software. I am using TablePlus for Windows version 6.7.1 (Build 326).
I have compiled a list of suggestions, UX improvements, and a few bugs, categorized by the relevant section of the application.

General UI & Connections

1. Color Coding for Sidebar Tables: In addition to "Pin to top", it would be very helpful to allow changing the background/text color of specific tables name in the sidebar. This would make frequently used tables stand out visually.
2. Restore Session (Tabs & Filters): It would save a lot of time if we could restore the previous session (open tabs, active filters, and sorting) upon restart or via a shortcut like Ctrl+Shift+T.
3. Add Database from Workspace to Connections: When switching databases via Ctrl+K, we see all DBs in the current environment. Please add a Context Menu option (Right-Click) to these items to "Add to Connection List". This would allow creating a permanent shortcut without manually creating a new connection from scratch.
4. Database Discovery in Connection Setup: When creating a new connection and entering server credentials, please add a dropdown arrow next to the "Database" field that fetches and lists available databases on that server.
5. ** Bug: High DPI / Blurriness on Multi-Monitor:** The UI becomes blurry when moving the window between screens with different DPI scaling (e.g., Laptop screen vs. External 4K monitor). Currently, I have to restart the app on the target monitor to fix the resolution.
6. Copy Version Info: In the "About" screen, please allow Ctrl+C to copy the version number/build info to the clipboard.

Filtering System & Table View

7. Default Filter Operator: When creating a new filter in a table (via Ctrl+F), the operator field is often empty. Even though I have set a "Default filter operator" in settings, the new inline filter row does not always respect this. It should default to = (or the user's choice) instead of requiring manual selection.
8. Advanced Default Sort: The current "Default table sort" setting only supports PK. I would prefer a setting to define a default sort column (e.g., created_at) and direction (DESC/ASC) globally or per table, so I can always see the newest records first.
9. Filter Bar Height Limit: When many filters are active (e.g., 15+), the filter bar takes up the entire screen on a laptop. Please implement a max-height (e.g., 6 rows) with a scrollbar.
10. Filter Input History & Undo:
    • Add Ctrl+Z support inside the filter value input to undo changes.
    • Add "History" support using Up/Down arrow keys (similar to VS Code search or Terminal) to cycle through previously typed values.
11. ENUM Support: If a column is an ENUM, the filter value input should offer a dropdown list of the available enum options.
12. Undo Filter Deletion: If a filter row is accidentally removed (via Ctrl+Shift+I), allow Ctrl+Z to restore it.
13. Improvement to "Default Filter Column Sort": I see there is an option in Advanced Settings to sort filter columns "By Name". However, when this is active, the Primary Key (e.g., id) gets sorted alphabetically and ends up in the middle of the list.
    Suggestion: Please pin the Primary Key (PK) to the very top of the dropdown list, even when "By Name" is selected. It is the most frequently used column for filtering and should always be immediately accessible.

Quick Look Editor & JSON

14. UX Issue: Quick Look Filter Persistence: When clicking a Foreign Key (FK) cell to open the "Quick Look Editor", TablePlus applies a temporary filter (e.g., id = '71') to the target table.
    • The problem: These filters persist in the background. If I browse multiple FKs, the target table accumulates dozens of Row SQL filters. When I eventually open that table directly, I have to clean up all these auto-generated filters.
    • Suggestion: Filters created by Quick Look should be transient or cleared when the Quick Look window is closed.
15. JSON Viewer Improvements:
    • Sorting: Add a button to sort keys A-Z (ASC/DESC).
    • Copy Key: Allow copying the Key name, not just the Value.
    • Array Count: Display the number of items in an array next to the bracket, e.g., items [3].
16. ** Bug: JSON Raw View in Dark Mode:** When switching the JSON viewer to "Raw" mode, the syntax highlighting colors are optimized for Light Mode and are unreadable in Dark Mode. Please update the default colors for Dark Mode or allow custom theme overrides for this view.

Localization

17. I would love to help translate TablePlus into Hebrew. Is there a platform (like Crowdin) or a way to submit translations?

Thanks again for the great work on this tool!

[sonswift]

Hi @lmalma,

Thank you very much for your detailed and thoughtful feedback — we truly appreciate the time and effort you put into this.

We will carefully review all your suggestions, and we’ll investigate the reported issues to verify and address them in upcoming updates.

Thanks again for your support and for helping us improve TablePlus!