To install emma on Ubuntu, run the following command in the Terminal or you can directly install it from Ubuntu Software Center. Some of the notable features in emma are SQL editor, create and modify MySQL databases on the go, syntax highlighting support, export to CSV, and many other features. It is an ideal tool for beginners in the field of database programming and database administration. EmmaĮmma is a simple and lightweight database management tool especially developed for Linux and its distro’s such as Ubuntu. SQuirrel SQL can be downloaded and installed directly from Ubuntu Software Center. And for some reason I now need to patch otherwise it wont compile (TRUE was not declared in this scope). It is simple and lightweight tool which you will find very reliable and useful. If you have any compliments or complaints to MSDN Support, feel free to contact. It is feature-rich SQL client which offers features such as full-fledge plug-in support, simultaneous sessions with multiple databases, user defined code templates, etc. SQuirreL SQL is a cross-platform database administration tool which offers code editor that comes with code compilation and syntax highlighting for SQL. It’s not like it has everything perfect because you may find errors in some functions on some occasions. Talking about the features, it offers connection to various data sources, visual query builder, metadata browser, ER diagrams, data and metadata search, and SQL editor. It comes with simple yet attractive user interface which is very easy to use. It is developed by open-source community especially for developers, SQL programmers, database administrators, and analysts.Īpart from MySQL, it supports other widely used database management tools such as PostgreSQL, SQLite, Firebird, Oracle and many other.

$ sudo apt-get install -y phpmyadmin DBeaverĭBeaver is a free and cross-platform SQL client and database administration tool.

Best mysql free client 2017