Postgres.app is a native macOS application that simplifies installing and running PostgreSQL database servers. It packages PostgreSQL binaries, extensions, and command-line tools into a self-contained Mac application. Users can start and stop database servers through a graphical interface without manually configuring a database service. Multiple PostgreSQL versions can run simultaneously for testing and development. Bundled extensions include PostGIS, pgRouting, pgvector, and additional database utilities. Developers can connect through standard PostgreSQL clients and programming libraries. Its command-line tools support database creation, administration, importing, exporting, and interactive SQL queries. Built with Swift, Postgres.app provides a convenient local database environment for application development, geospatial projects, and experimentation.
Features
- Self-contained PostgreSQL installation for macOS with database binaries, supporting libraries, and administration utilities
- Native graphical interface for starting, stopping, and managing local PostgreSQL database servers
- Simultaneous operation of multiple PostgreSQL versions for compatibility testing and application development
- Bundled database extensions including PostGIS, pgRouting, pgvector, wal2json, pldebugger, and JavaScript procedural languages
- Integrated PostgreSQL command-line tools for creating databases, executing SQL queries, and managing database backups
- Compatibility with standard PostgreSQL clients, programming frameworks, and local development environments on macOS