DEV Community

Tung Thanh
Tung Thanh

Posted on • Edited on

2 1

Essential features of TablePlus - the best GUI tool for MySQL, PostgreSQL, SQLite and more

TablePlus helps you to be more efficient while working with multiple relational databases. You can connect to the server, create a new database, manipulate and save your data at a lightning speed, high-end secure guaranteed.

For now, TablePlus is available for macOS only, the windows version is going to be out soon.

Download the app from TablePlus' official website.

Basic features

Connect to the server

You can use TablePlus to create a connection to multiple databases: MySQL, PostgreSQL, SQLite, Microsoft SQL Server, Amazon Redshift, MariaDB, CockroachDB, Vertica, and even Redis.
You need to prepare host, port, username, and password to connect. For SQLite, you can double click on the database file (normally it has .db, .sqlite, or .sqlite3 file extension) to open with TablePlus.

Create a new connection
You can also import URL, just copy and paste, it saves tons of times for you.

Open anything

Hit Cmd + P and type the keyword, TablePlus will lookup from your database and open table, views, function, or snap, very convenient.

Open Anything

Edit Data

TablePlus has a spreadsheet-like interface for you to browse and edit data inline in the most intuitive way.

Edit Data

Remember to hit cmd + S to commit the change to the server after to edit.

SQL Query editor

To open the SQL editor, hit cmd + E.
You can write multiple queries and choose to run them simultaneously or only the query at the cursor. If you choose to run all, the results can be split and displayed in multiples tabs.

SQL Query Editor

Create new tables

Instead of running queries, you can create a new table from the GUI tool. Open the database and click on + new table button, just as easy as you create a new folder in macOS’ Finder.

Create a new table

Data Filter

Use this feature to quickly filter out the records you want to see. You can apply multiple filters at once, each filter contains three parts:

  • a dropdown list of the column names
  • common conditions such as equal, contain, IS NULL,…
  • one text box to fill the value.

Data Filter

Export/Import Data

You can import a table from a CSV file and export a table from your database to a CSV, JSON or SQL file.

Import Data

Export Data

Billboard image

The Next Generation Developer Platform

Coherence is the first Platform-as-a-Service you can control. Unlike "black-box" platforms that are opinionated about the infra you can deploy, Coherence is powered by CNC, the open-source IaC framework, which offers limitless customization.

Learn more

Top comments (0)

A Workflow Copilot. Tailored to You.

Pieces.app image

Our desktop app, with its intelligent copilot, streamlines coding by generating snippets, extracting code from screenshots, and accelerating problem-solving.

Read the docs

👋 Kindness is contagious

Dive into an ocean of knowledge with this thought-provoking post, revered deeply within the supportive DEV Community. Developers of all levels are welcome to join and enhance our collective intelligence.

Saying a simple "thank you" can brighten someone's day. Share your gratitude in the comments below!

On DEV, sharing ideas eases our path and fortifies our community connections. Found this helpful? Sending a quick thanks to the author can be profoundly valued.

Okay