If you’re looking to edit or modify your Postgresql database without using the terminal, you need a GUI client.
👋 Check out our easy to use desktop GUI for PostgreSQL
Beekeeper Studio is a truly cross-platform PostgreSQL GUI with a clean, uncluttered interface. Write SQL, edit data, alter tables, and more!
Available for MacOS, Linux, and Windows.
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 PostgreSQL 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 PostgreSQL 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.
- PostgreSQL Table Creation and Editing - We have a built-in, easy to use GUI interface.
- Edit PostgreSQL Data - Edit database records in PostgreSQL in-line with only a couple of clicks.
- PostgreSQL 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.
- PostgreSQL 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'.
- Not Just for PostgreSQL - 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 :-)
More Postgresql Articles
- How To Limit The Number Of Rows Returned In PostgreSQL
- PostgreSQL CREATE TABLE Walkthrough With Examples
- PostgreSQL How To Use Schemas
- PostgreSQL CONSTRAINT Walkthrough
- Running Postgres in Docker for Local Development
- 7 Must-Have Tools For Developers That Use PostgreSQL
- PostgreSQL - Change The Type Of A Column, A Walkthrough With Examples