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.

Download

Searchlight is free and open source. Releases are available on GitHub.

View Releases