The best SQL Editor for Mac & Windows
tl;dr: TablePlus offers a handy SQL query editor with:
- Highlight syntax
- Multiple databases support
- Autocomplete
- Multiple queries execution
- Streaming results row by row
- Query History and Keyword Binding Favorite
- Multiple results view
TablePlus is a modern, native client with intuitive GUI tools to create, access, query & edit multiple relational databases: MySQL, PostgreSQL, SQLite, Microsoft SQL Server, Amazon Redshift, MariaDB, CockroachDB, Vertica, Oracle, plus Cassandra and Redis.
Even though TablePlus allows users to browse and manipulate data effectively through an intuitive table tool with inline editing, import and export CSV, multiple filters, safe mode, code review…, writing queries is still an inevitable part of working with the database and having a good SQL query editor would save a lot of time and effort.
TablePlus provides a powerful SQL query editor that boost your productivity tremendously.
1. Highlight syntax and Autocomplete
Highlighting the syntax not only helps improve the readability and context of the queries but also prevents having some human errors such as typos.
SQL is the standard query language used in every relational database management system, however, it might vary as each database has its own extension and functionalities. TablePlus offers native support for a handful of drivers and the query editor supports each driver’s features and syntax correctly.
TablePlus’ SQL editor supports auto-completion and auto lookup. When typing an SQL query in the SQL editor, it will perform an auto suggestion for SQL keywords and database objects such as table, column, procedure, function…, to help you finish writing queries faster without having the hassle of remembering stuff.
2. Multiple queries execution
When writing multiple queries in the SQL Query editor, apart from selecting with cursor position and executing each query separately, you also have an option to execute all queries at the same time.
3. Streaming results row by row
The best part is that TablePlus supports streaming results row by row. When you have a slow connection or need to fetch a table containing megabytes of data each row, TablePlus will fetch and show them one by one.
The fetching progress is also a background task. That means it won’t block the UI, you can do other tasks while waiting for a long run query.
4. Query History and Keyword Binding Favorite
The query history feature will help you record all executed queries so that later you can come back and see if you made a mistake somewhere, or just to reuse.
There are some queries you want to reuse in different contexts or with different objects quite frequently. You can add it to favorite and assign a keyword for reference and call it quickly using that keyword later.
5. Multiple results view
When you have more than one query and need to execute them simultaneously, or you have a stored procedure with multiple select queries, TablePlus’ Query Editor can split the results into multiple tabs so you can view each separately.
If one editor is not enough, you can split the current editor into many different editors that run separately.
There’re more to it, but it’s better to try the app and feel it yourself. It’s free anyway.
Not on Mac? Download TablePlus for Windows.
On Linux? Download TablePlus for Linux
Need a quick edit on the go? Download TablePlus for iOS.