DBGlass

DBGlass is a super handy tool that gives you a fresh and modern workspace to work with your PostgreSQL databases. It's built on the Electron framework, which means it looks great and is easy to use. With DBGlass, you can not only view your database content but also edit it without any hassle.

Setting Up Your Connection

As soon as you open DBGlass, it asks you to set up a new PostgreSQL connection. All you need to do is enter the server address, the name of your database, and a valid username along with the right password. It’s pretty straightforward!

Flexible Connection Options

You can even tweak things like the default connection port or give your configuration a name so you can save it for later. Plus, DBGlass supports SSH tunneling! This means you can keep your connections secure by using either a password or an SSH key.

Viewing Your Data

The main window of DBGlass shows all the tables in list mode. You can easily visualize or filter their content, which is awesome if you're dealing with large tables. It makes navigating through data much simpler!

Editing Made Easy

Add new rows to your table quickly and even change the table structure if needed! You can add columns, choose data types for each one, and set default values too.

User-Friendly Widgets

DBGlass comes loaded with widgets that help tackle various tasks like adding constraints to columns or using Markdown for text formatting. It’s designed for convenience!

Real-Time Changes

You can see all changes in real-time but remember—you’ll need to save each modification you make. And while DBGlass lets you undo actions, keep in mind that once you've saved something, there's no going back.

The Bottom Line

In short, DBGlass provides a slick environment where you can visualize and query your PostgreSQL database while editing its contents too. It keeps your connection safe with SSH tunneling and even offers Markdown support so that filtering data doesn’t require writing complex queries manually.

If you're ready to get started with DBGlass, check out this link for download!