Show HN: Searchlight – Open-source Postgres client for macOS
github.com
Over the past year, I’ve been building a native MacOS Postgres client for my personal use. While there are plenty of existing clients, I built this because: - No open-source Postgres client matched the smooth UX of tools like Sequel Pro/SequelAce (for MySQL). - I missed the satisfaction of long-term product ownership and iteration—recent work has me jumping between projects. - I’ve been using Postgres more lately and wanted to get hands-on to deepen my knowledge.
I also wanted a playground to experiment with client features that would help me on day-to-day. Some I have implemented already: - Hover over a foreign key column to see the linked record in a popover. - Autocomplete lookup for foreign key records when inserting/editing rows. - High-level stats pop-up when hovering over a column. - Contextual “sugar” features (e.g., UUID fields include a button to generate a UUID while editing). - On update/insert failures, it tries to highlight the issue on the problematic column, vs some generic error alert.
It’s still very bare-bones and I still use it alongside other tools for features I haven’t implemented (management features for tables/schemas/user), but I’m already using as my main client for 90% of what I work on.
I’m sharing here to get early feedback. Mostly trying to determine if more people find value in this project if I keep developing it.
ps.: I’m using my personal Apple developer account so I can’t notarize the app with Apple. If you try to install from the GitHub releases page MacOS will warn that it can’t verify the developer identity, so you will need to approve the install on Settings > Privacy, or build from source.