Searchlight
Native PostgreSQL Client for macOS
A lightweight, open-source native macOS client for PostgreSQL. Browse databases, write queries, and export data.
Features
Connection Management
Save and organize database connections. Supports SSH tunneling with key authentication for connecting through bastion hosts.
Database Browser
Browse tables, views, and schemas. Click foreign key values to navigate directly to referenced records.
Query Editor
Execute SQL with syntax highlighting. View results in a sortable, filterable table.
Data Export
Copy cells or rows as text, CSV, or SQL INSERT statements. Export query results to files.
Column Statistics
View value distributions and statistics for any column. Identify patterns and outliers in your data.
Foreign Key Lookup
Autocomplete foreign key values when editing rows. Hover over any reference to preview the linked record without leaving your table.
Overview
Searchlight is a native macOS application for connecting to and exploring PostgreSQL databases. It is built with Swift and SwiftUI, providing a fast, lightweight interface that integrates with macOS system features.
The application supports direct connections as well as SSH tunneling for accessing remote databases through bastion hosts. All connections can be secured with SSL/TLS encryption.
Technical Details
- Platform: macOS 12.0+
- Language: Swift, SwiftUI
- Database Protocol: PostgresNIO
- License: Open Source
Getting Started
Download the latest release from GitHub and open the .dmg file. On first launch, macOS may require you to approve the application in System Settings > Privacy & Security due to the developer signing certificate.