TeamSQL a alternative to DataGrip from JetBrains

Posted by Toguko on Fri 15 September 2017

I was look for a good Free or Open Source alternatives to replace the excellent, but paid, DataGrip to manage my PostgreSQL and MySQL servers. After a quick research I find some good contenders, TeamSQL, Adminer, Heidi and others.

Why TeamSQL ?

I did some tests and I choose TeamSQL for many reasons. Firstly, it is easy to install using a .deb package, the UI is intuitive. Secondly, it is fast to open, keep my history of query's, the Code Completion is good, etc. And finally, it is free for non-commercial use.

TeamSQL is free to non-commercial use and supports only PostgreSQL and MySQL databases in the free version. But in the Pro Plan, for just US$4.99, it will have a lot of others DBs like MariaDB, Microsoft SQL Server, AWS Aurora, Redis, etc.

The installation in Ubuntu and debian flavors is easy. Just download a .deb package from here and install with dkpg or your favorite package manager, and go to your menu and execute Temsql shortcut to open the app. Put your e-mail and password to create one account, and start to use the app, it's so simple!

As the name implies, TeamSQL can be a great, easy-to-use option for collaboration on queries.

Some Features:

  • Sharing: TeamSQL comes built-in with robust sharing tools. You can create teams to share queries with multiple people at once, or you can share queries to individuals.
  • History: Everything is automatically saved, and users can easily retrieve queries they've run using the search functionality.
  • Code Completion: You don't have to remember how to write queries from scratch unassisted.

For more information visit Here.

So I'll give TeamSQL a chance to see if it will be able to manage my databases in my day-by-day use without problems, like crashing, slow operations in query executions, etc.