If you’re looking to edit or modify your Postgresql database without using the terminal, you need a GUI client.
Open Source Postgres Client for Ubuntu
Beekeeper Studio is an open source Postgres GUI client for Ubuntu, Linux in general, Mac, and Windows.
Actually, I built Beekeeper Studio using Ubuntu. As a 15 year Linux user, I was excited to make a first-class Postgres client for Ubuntu, rather than getting second-class versions of Mac or Windows software.
Back in the day I was a big user of Sequel Pro for MySQL for the Mac, and I spent 10 years waiting for something that good to come along for Ubuntu. It never did, so I made my own.
Beekeeper Studio also supports MySQL, SQL Server, CockroachDB, Redshift, and SQLite, so no matter what database you use on Ubuntu, we’ve got you covered.
Postgres Client for Ubuntu Features
I’m a big user of Postgres, so I care about what a good Postgres client should be. Here are some of our awesome features:
- Modern and easy to use Postgres GUI client - We sweat the details. There are no 'tabs within tabs', cryptic buttons, or old-school Java swing interfaces.
- Tabbed Interface - Open a bunch of queries and tables all alongside each other.
- Open Multiple Postgres Connections At Once - give each connection a color, and run them all at once if you wish. </li>
- Save SQL Queries For Later - Our built in data store lets you save queries for when you need them.
- Postgres Table Creation and Editing - We have a built-in, easy to use GUI interface.
- Edit Postgres Data - Edit database records in Postgres in-line with only a couple of clicks.
- Postgres SQL Auto Completion - A useful autocomplete editor that doesn't get in your way.
- Pinned Tables - Keep your most-used tables and views at the top of the sidebar for easy reference.
- Postgres Run History - Beekeeper Studio keeps track of the SQL queries you run, so you can find the magical code from last week that 'just worked'.
- Share Postgres connections and queries - Optionally upgrade to a Team Workspace to share queries and connections with your colleagues.
- Not Just for Postgres - Beekeeper Studio supports MySQL, PostgreSQL, MariaDB, SQLite, CockroachDB, Redshift, and SQL Server.
- Community Strength - Many features were built by our amazing community of contributors.
Start Using The Best Postgres Client for Ubuntu
We provide DEB, Snap, and AppImage packages for use in Ubuntu, so there’s really no excuse :-)