There’s a certain fatigue that sets in when you open a database tool and spend the first two minutes figuring out which panel to click before you can see a single row of data. Tools like pgAdmin and DBeaver are genuinely capable, but they carry a lot of weight. Most developers working on a side project or debugging a staging environment don’t need that weight. They need a connection, a table view, and a query box.
That’s exactly the niche SimplePostgreSQL is filling. Built by Petizoutils, it’s a Mac desktop client for PostgreSQL that strips the experience down to the tasks you actually repeat every day: browsing tables, editing rows, running SQL, and moving data in and out via CSV. Nothing more, and that restraint is a deliberate choice.
What also stands out is the privacy angle. Your database credentials never leave your machine. The app connects directly from your Mac to whatever PostgreSQL server you’ve configured, with no credentials passing through a third-party API. For anyone managing production databases, that matters.
Key Features of SimplePostgreSQL
Table Browser and Direct Row Editing
The sidebar gives you a clear path through databases, schemas, and tables. Rows load in pages of 50, which keeps things fast. When you need to make a change, the editing controls are primary-key-aware, so you’re not guessing which row you’re updating. Explicit save and cancel buttons mean no accidental writes.
SQL Editor with Schema-Aware Autocomplete
The query interface includes autocomplete for tables and columns, which saves time on any schema you haven’t memorized. You can cancel running queries and page through results. It’s not trying to be a full IDE. It just needs to work well for the queries you run frequently.
CSV Import and Export
You can import a CSV file directly into a selected table or export the current visible page to CSV. One early user on Product Hunt noted that the CSV import handled an unusual timestamp format on the first try, which suggests the parsing is more forgiving than you might expect from a lightweight tool.
Saved Connection Profiles
Connection details for local and remote PostgreSQL servers are stored in the app’s local data directory on your Mac. They’re not synced to any server. You can save as many connections as you need, covering local dev, staging, and production, and switch between them from one sidebar. All plans include unlimited saved connections.
Marco’s Tuesday Morning: A Real Use Case
Marco is a backend developer at a small SaaS company in Lisbon. At 9:15 on a Tuesday morning, he got a Slack message from a colleague: a batch of user records had been imported overnight with a malformed status field, and the affected rows needed to be corrected before the daily report ran at 10:00.
Marco opened SimplePostgreSQL, switched from his local connection to the staging profile in the sidebar, and located the users table in about fifteen seconds. He ran a quick SELECT query to confirm which rows were affected, using the autocomplete to fill in the column names without switching to another window. Then he moved to the Data view, filtered down to the relevant rows, and corrected the status field directly by clicking into the cell, typing the correct value, and hitting save.
The whole task took under eight minutes. No terminal, no ORMs, no fumbling through nested menus. He exported the corrected page as a CSV to attach to the Slack thread as confirmation, then switched back to his local connection to continue his actual morning work. The report ran on time.
That’s the kind of workflow SimplePostgreSQL is built around. Fast, focused, and finished.
How SimplePostgreSQL Works From First Launch
Step 1: Download and Connect
Download the Apple Silicon or Intel build for macOS 12 or later. On first launch, you create a connection profile by entering a host, port, username, database name, and optional SSL settings. You can paste a full connection URI to fill the fields automatically. Hit Test, then Save.
Step 2: Browse Your Schema
The sidebar populates with your databases, schemas, and tables. Click any table to load the first 50 rows in the Data view. Use the column visibility control to hide fields you don’t need right now.
Step 3: Edit, Query, or Export
Switch between the Data tab for direct row editing and the Query tab for SQL. Write your query, use autocomplete to avoid typos on column names, and run it. Results paginate. When you’re ready to export, the CSV option is one click from the current table view. Import works the same way in reverse: select your file and the target table.
Pricing
SimplePostgreSQL offers two plans, and both include every feature with no feature gating between tiers:
- Monthly: $7 per month, billed monthly, cancel any time through the billing portal.
- Yearly: $59 per year, which works out to $4.92 per month and saves $25 compared to the monthly rate.
A 14-day free trial is available before you choose either plan. No credit card is required to start.
Who Should Try SimplePostgreSQL
If you’re a Mac developer who works with PostgreSQL regularly and finds the heavier GUI tools more distracting than helpful, SimplePostgreSQL is worth the 14-day trial. It’s especially well-suited for solo developers, freelancers, and anyone managing a handful of PostgreSQL connections across different environments. You can download it and start the free trial at simplepostgresql.com. No credit card, no commitment, just a cleaner way to work with your data.
