7 DB Admin tools

DBVisualizer Free

Database specific support for DB2 LUW, Informix, JavaDB/Derby, H2, Mimer SQL, MySQL, Netezza, NuoDB, Oracle, PostgreSQL, Redshift, SQL Server, SQLite, Sybase, and, Vertica. SQL editor with support for auto completion, parameterized SQLs, SQL formatter, visual query builder, explain plan, and, a command-line based interface.

DBVisualizer-Free

Tool Description as in http://www.dbvis.com/

Image Credit: https://dbvisualizer.en.softonic.com/

download-DBVisualizer

Adminer

Adminer is a database management tool that allows you to manage databases, tables, columns, relations, indexes, users, permissions, and more from a web-based user interface. It is packaged as a single PHP file (similar to phpMyAdmin) and has support for popular database management systems like MySQL, PostgreSQL, SQLite, MS SQL, Oracle and MongoDB. Different UI designs are available for you to download as CSS files.

Adminer

Tool Description as in https://techtalk.gfi.com/top-10-free-database-tools-for-sys-admins/

Image Credit: https://techtalk.gfi.com/top-10-free-database-tools-for-sys-admins/

download-Adminer

DBeaver

DBeaver is free and open source universal database tool for developers and database administrators. Usability is the main goal of this project, program UI is carefully designed and implemented. There is a set of plugins for certain databases (MySQL, Oracle, DB2, SQL Server, PostgreSQL, Vertica, Informix, MongoDB, Cassandra, Redis in version 3.x) and different database management utilities.

DBeaver

Tool Description as in http://dbeaver.jkiss.org/about/

Image Credit: https://techtalk.gfi.com/top-10-free-database-tools-for-sys-admins/

download-DBeaver

EMS SQL Manager Lite

EMS SQL Manager for SQL Server is a high performance tool for Microsoft SQL Server database development and administration. SQL Manager works with any MS SQL Server versions from 2000 to the newest one and supports the latest SQL Server features including sequences, columnstore and spatial indexes, FileTables, contained databases, custom server roles and other. It offers plenty of powerful SQL tools such as Visual Database Designer that allows designing SQL Server database in few clicks.

EMS-SQL-Manager-Lite

Tool Description as in https://www.sqlmanager.net/en/products/mssql/manager

Image Credit: https://techtalk.gfi.com/top-10-free-database-tools-for-sys-admins/

download-EMS-SQL-Manager-Lite

FlySpeed SQL Query

If you are looking for a proper tool to work with data and SQL queries with ad-hoc visual query builder, you must have a look at FlySpeed SQL Query. This Windows app connects to all modern database servers and works with all popular desktop databases and office file formats (CSV, Excel).

FlySpeed-SQL-Query

Tool Description as in http://www.activedbsoft.com/overview-querytool.html

Image Credit: http://www.activedbsoft.com/screenshots-querytool.html?screen=1

download-FlySpeed-SQL-Query

Firebird

The Firebird Project’s 2017 project is to translate into English the Firebird Developer Guide, a Russian-language work sponsored by IBSurgeon and Moscow Exchange, edit and review it and publish it in the project’s documentation library. For this project, as ever, we need funding. This is your opportunity to make it happen, by contributing whatever you can to our crowdfunding campaign.

Firebird

Tool Description as in http://www.firebirdsql.org/

Image Credit: http://razorsql.com/features/firebird_gui_tools.html

download-Firebird

SQuirrel SQL

SQuirreL SQL Client is a JAVA-based database administration tool for JDBC compliant databases. It allows you to view the database structure and issue SQL commands. It supports databases such as Firebird, IBM DB2, InterBase, Microsoft Access, Microsoft SQL Server, MySQL, Oracle, PostreSQL, and Sybase.

SQuirrel-SQL

Tool Description as in https://techtalk.gfi.com/top-10-free-database-tools-for-sys-admins/

Image Credit: https://techtalk.gfi.com/top-10-free-database-tools-for-sys-admins/

download-SQuirrel-SQL

Useful Videos

FlySpeed SQL Query

Source:Maurice Muteti

DBeaver

Source:drprventura

Adminer

Source:TemplateMonsterCo

Leave a Reply

Your email address will not be published. Required fields are marked *