I was looking for a handy tool that supports multiple database types. Most software only support a single database type. Well, this could be a marketing trick to boost their sales or could be any other reasons. For example, Navicat have some great software such as Navicat for PostgreSQL and Navicat for MySQL. We have to purchase two different software if we want to connect to two different servers. Thankfully, there is Database Browser, a handy and useful tool that supports various database types in a single application.
Database Browser or DBrowser comes with a nice user interface. Most free software has bad look but DBrowser not. Its pretty easy to use it due to simple and intuitive user interface. Let’s have a look.
Database Browser Features
- Simple and easy to use
- Supports PostgreSQL, MySQL/MariaDB, MS SQL Server, Oracle, SQLite and some more
- Built-in table editor
- Multiple connections
- Data export to CSV
- Data Import
- SQL Builder
- Support SSL connection
Well, we got some great features on a free software. Why Not?
To use this software, first download the installer. It supports Windows 10, 8 and Windows 7. Extract the zip file and then install it as usual.
- Go to Connections | Add. The Add new connection window will open up.
- Select the Connection type from the list
- Type the connection name
- Provide the host name or you can use the server IP address instead
- Input your user name and password for the database
- Select the database
- Test the connection and Click OK.
Built-in SQL Editor
You can easily create your own SQL syntax against your database. And then export the query result to CSV format if you like. If you prefer the graphical way, Database Browser provide an intuitive SQL builder that supports drag and drop feature.
Table and Data Editor
Database Browser is not an ordinary database tool. You can edit your table as well as your data right away from this application. Add new record, edit record are available.
Well, there are some minus points about this software. You won’t be able to create new database, roles and tables. At least, you can’t do those tasks on PostgreSQL database. We haven’t tested it on Oracle and other databases.