PostgresGUI - A native PostgreSQL client for macOS

Features

• Connection Management
• SSL/TLS Support
• Database & Table Browsing
• SQL Query Editor
• Data Viewing & Editing
• Row Operations - View rows as json, edit row, select rows and delete
• Keyboard Shortcuts
• Native macOS Experience - Built with SwiftUI for a fast, responsive, and familiar interface

Getting Started

Creating Your First Connection

1. Launch PostgresGUI
2. Click "New Connection"
3. Enter your connection details:
   • Host (e.g., localhost or your server address)
   • Port (default: 5432)
   • Database name (default: postgres)
   • Username and password
4. Click "Test Connection" to verify
5. Save your connection profile

Keyboard Shortcuts

• Cmd+Return - Execute SQL query
• Space - View selected row in JSON format
• Delete - Delete selected row(s)

Building from Source

Build Steps

1. Clone the repository:

   git clone https://github.com/yourusername/postgresgui.git
   cd postgresgui

2. Open in Xcode:

   open PostgresGUI.xcodeproj

3. Build and run:

   • Select the PostgresGUI scheme
   • Press Cmd+R to build and run
   • Swift Package Manager will automatically resolve dependencies

All dependencies are managed through Swift Package Manager and will be downloaded automatically on first build.

Support

• Visit postgresgui.com/support for help and documentation
• Report bugs on GitHub Issues

Acknowledgments

PostgresGUI is built on the shoulders of giants. Special thanks to:

• The PostgresNIO team for the excellent PostgreSQL client library
• The Swift NIO project for the networking foundation