PostgreSQL Client

Name: PostgreSQL Client
Rating: 4.6 (153 reviews)
Author: Filippo Maguolo

Developer Tools

Free · In‑App Purchases · Designed for iPad

153 Ratings
Age Rating

4+
Years
Category

Developer Tools
Developer

Filippo Maguolo
Language

EN
English
Size

126.9
MB

DB Compass for PostgreSQL allows you to access your PostgreSQL database directly and without any server setup. You can manage your data with a clean and simple iOS user interface. FEATURES: • Connection over TLS encryption and/or SSH tunnel • Database authentication supported: plain, MD5, SASL (SCRAM-SHA-256 and SCRAM-SHA-256-PLUS) and OAuth (PostgreSQL 18+) • SSH authentication support Secure Enclave Key and U2F/FIDO NFC Key • Assisted table creation and alter structure • Explore, filter, sort, and quick search table data • Query script with A.I. assisted composition and plan analysis • Database objects (tables, views, procedures, etc.) • Database statistics, sessions manager, server status graphs • ER Diagram Viewer • Advanced data grid for browse, edit, conditional formatting • Blob field preview, import and export • Job Activity Monitor • User list and Privileges • Import and Export in multiple formats • iCloud Sync for SQL and JS scripts • SQL plan analysis • Execute queries with Shortcuts App • Charts & Widgets OpenAI, Gemini and Claude integration requires api key and is only available in allowed regions. Ollama and LM Studio integration requires your server to connect. Tested on PostgreSQL 9.5 to 18. -- This is a Premium app and some features may require an in-app lifetime unlock -- For feedback or suggestions contact info@dbcompass.net

Ratings & Reviews

4.6

out of 5

153 Ratings

Yup
05/02/2022
hallach
It works, as others have mentioned it’s not “perfect” but it gets the job done when you need to access your databases on the go. Displays a form entry for your stored proc’s arguments too which is nifty! It’s all better than trying to manipulate psql through a terminal app on iOS thats for sure. And for a good price too.
Yup
05/02/2022
hallach

It works, as others have mentioned it’s not “perfect” but it gets the job done when you need to access your databases on the go. Displays a form entry for your stored proc’s arguments too which is nifty! It’s all better than trying to manipulate psql through a terminal app on iOS thats for sure. And for a good price too.
Many imperfections; unbeatable price
11/26/2020
Tcabeen
Look, for the price, you’re not going to do better. The competition have enterprise-level subscription rates. This app has a fantastic hobbyist-level price. And that’s what I am, so it’s the only viable option for iPad as far as I can see.It works. It runs queries. It connects and reconnects beautifully. I’ve been creating tables, inserting data, parsing tens of thousands of records without trouble.It crashes sometimes (but brings all your saved queries right back up). The interface can’t run an individual query, only everything that’s in the current window. The query and the results are in different “tabs” but you can’t switch from the query tab to the results tab without exiting the tab because of the keyboard-helper bar along the bottom (the one that’s still there even when you’re on a hardware keyboard).So it lacks polish, sure, but it’s WAY faster and easier than typing out the queries from the CLI. And again, check out that outstanding price!

Developer Response
Thanks a lot for the feedback and feel free to contact me for more.I can add the you can select the text on the query windows to run only that part of sql.
Many imperfections; unbeatable price
11/26/2020
Tcabeen

Look, for the price, you’re not going to do better. The competition have enterprise-level subscription rates. This app has a fantastic hobbyist-level price. And that’s what I am, so it’s the only viable option for iPad as far as I can see.It works. It runs queries. It connects and reconnects beautifully. I’ve been creating tables, inserting data, parsing tens of thousands of records without trouble.It crashes sometimes (but brings all your saved queries right back up). The interface can’t run an individual query, only everything that’s in the current window. The query and the results are in different “tabs” but you can’t switch from the query tab to the results tab without exiting the tab because of the keyboard-helper bar along the bottom (the one that’s still there even when you’re on a hardware keyboard).So it lacks polish, sure, but it’s WAY faster and easier than typing out the queries from the CLI. And again, check out that outstanding price!
Developer Response 11/27/2020
Thanks a lot for the feedback and feel free to contact me for more.I can add the you can select the text on the query windows to run only that part of sql.
Very good. Redshift mostly works too
05/23/2019
Missing my tabs
Very good postgresql support. But I bought because it is one of the few solutions able to work with Redshift. Seems to support about 90%. Which is good enough for emergency support on the go. Hopefully this helps others.
Very good. Redshift mostly works too
05/23/2019
Missing my tabs

Very good postgresql support. But I bought because it is one of the few solutions able to work with Redshift. Seems to support about 90%. Which is good enough for emergency support on the go. Hopefully this helps others.
Lots of bugs but good idea
05/05/2021
Isleofgough
Until yesterday's update, time fields were incorrect. For example 13:30:00 would show 1:00 AM. That was fixed but now you cannot add a new record that has a date and time field. There are nice clocks and calendars but they will not actually fill in a field. I had to purchase another front end for anything more than viewing data.
Lots of bugs but good idea
05/05/2021
Isleofgough

Until yesterday's update, time fields were incorrect. For example 13:30:00 would show 1:00 AM. That was fixed but now you cannot add a new record that has a date and time field. There are nice clocks and calendars but they will not actually fill in a field. I had to purchase another front end for anything more than viewing data.

• Improved "data" chart type with more customizations • Improved AI assistant, added web-search tool and a compatible OpenAI api provider

Version 48.0 1d ago

Data Not Collected

The developer does not collect any data from this app.

Privacy practices may vary, for example, based on the features you use or your age. Learn More

Accessibility

Information

Seller: Filippo Maguolo
Size: 126.9 MB
Category: Developer Tools
Compatibility: Requires iOS 16.0 or later.

iPhone
Requires iOS 16.0 or later.

iPad
Requires iPadOS 16.0 or later.

Mac
Requires macOS 13.0 or later and a Mac with Apple M1 chip or later.

Apple Vision
Requires visionOS 1.0 or later.
Languages: English
Age Rating: 4+

4+

Learn More
In-App Purchases: Yes

PRO FEATURES $9.99

Learn More