An equivalent to SQL Server Management Studio for MySQL
You just don’t like phpMyAdmin or the experience with SQL Server Management Studio is so good that you want to find a similar GUI Client for MySQL too? A MySQL Management Studio?
Sadly, Microsoft doesn’t want to support MySQL, but you can try TablePlus instead.
TablePlus is a native database client that offers GUI tools to develop, manage and maintain multiple MySQL databases simultaneously.
- Everything is built natively. TablePlus has a native app for Mac, a native app for Windows, with native support for multiple drivers, native SSH more extra security. It’s insanely fast, and secure.
- Intuitive interface. TablePlus was built to around the most important database management tasks such as querying, browsing, updating data. It helps you navigate faster instead of being overwhelmed in a sea of features.
- It’s free. Nothing is required to download and use the app. No account, no email, no credit card, no time limit.
A modern, native GUI client for MySQL
1. A powerful data tool that helps you manipulate data easier without having to write queries.
- Design and manage database objects with GUI. Foreign keys are well supported too.
-
Browse, edit and update data inline in a spreadsheet-like interface. You can also edit the query results directly using this view.
-
Import CSV file to a table and export a data table/query result set into a CSV file.
- Filter data easily with multiple filters. You can select and apply each filter one by one, or apple multiple filters all at once.
2. A robust SQL query tool
-
A smart MySQL Code completion. It suggests as you type, instantly.
-
Code formatting to re-format your queries, including Beautify SQL and Uglify SQL.
-
SQL Syntax highlighting
-
Split query editor into multiple editors to work on simultaneously.
- Multiple queries can be executed in batch and multiple results tabs are supported too.
- History to log all queries and keyword binding favorite to quickly insert frequently used queries without having to rewrite.
- Streaming results and async loading. When your query returns a heavy set of results, TablePlus starts streaming results right off the bat instead off waiting. This is also a background task so it doesn’t block the UI. You can switch to another task and go back when the results are fully loaded.
If that sounds too good to be true to you…
You can learn more by visiting that special issue #489.
It can’t be perfect for everone but perhaps you should try it yourself and see if it’s good for your database management tasks. 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.