Skip to content

TablePlus

TablePlus is a database client with a table browser, query editor and export tools. Its published database support includes PostgreSQL, MySQL and SQLite.

Visit TablePlus

What do you verify before opening a saved connection?

For a server database, match the database type, host and database name to your test copy and use a read-only login. The saved connection name is a label you choose. For a local SQLite file, check the full path to a disposable copy with made-up records and use read-only file protection where available.

TablePlus documents Safe Mode as an extra prompt for some changes. On a server, limit read access to the test records the account needs. With a local file, rely on the verified disposable copy and available file protections. If you cannot verify the test file path, stay on paper.

Which features should you check on your version?

The free version limits open tabs and windows. Check your operating system for filter availability. Paid device licenses are perpetual and include a year of updates. You can keep using the eligible installed version when the update period ends.

TablePlus documents exporting tables, views and query results to files such as CSV. Check the export dialog and inspect what comes out before sharing the file. Exported rows remain readable outside the client.

How can you rehearse choosing one connection and one export?

Draw two saved connections with similar display names. Use no real hostname, password or customer record.

  1. Read the destination
    Label one fictional destination a test copy and the other customer data. Choose the test copy using its host and database details.
  2. Draw only the results you need
    Mark the pretend order number and amount. Keep contact details out of the export sketch and write where the copy would be kept.