# pgAdmin 4 Published January 1, 2026 · Updated August 10, 2026 PostgreSQL administration and management tool Category: Developer Tools · Free · Replaces TablePlus ($99) · [Official website](https://pgadmin.org) ## Install with Homebrew `brew install --cask pgadmin4` ## Quick take pgAdmin 4 is still the free, official admin console for PostgreSQL on Mac. v9.17 keeps security current (including CVE-2026-17351 on the AI Assistant read-only guard), ships practical UI fixes, and lets you wire BYO LLMs when you want them. It will not beat TablePlus or Postico for snappy native querying, and the Python web stack still costs RAM and patience on launch. Keep it for Explain diagrams, ERD, roles, backups, monitoring, pgAgent, and unlimited free access, especially if your team shares a server-mode instance. Pair it with a lighter query client for day-to-day editing. Best for: PostgreSQL DBAs and admins who need more than a query editor, Developers who want free unlimited connections and Explain visuals, Teams deploying shared server-mode pgAdmin, Students learning PostgreSQL administration concepts, Users who want optional BYO OpenAI/Anthropic/local LLM SQL help ## What is pgAdmin 4? pgAdmin 4 is the official open-source administration and development platform for PostgreSQL. It gives you a GUI to create and manage databases, write and run SQL, inspect execution plans, design schemas with an ERD tool, monitor server activity, manage roles, and run backup/restore workflows without memorizing every psql and pg_dump flag. The PostgreSQL community treats it as the reference admin tool, and many installers and cloud guides still point people to pgAdmin first. Latest release: pgAdmin 4 v9.17 (release date 2026-07-30; PostgreSQL news announcement 2026-08-04). macOS builds ship as arm64 and x64 DMGs from the official download mirrors, and Homebrew offers `brew install --cask pgadmin4`. Licensing is the PostgreSQL License: free and open source with no feature paywall. Architecturally, pgAdmin 4 is a Python/Flask web application wrapped as a desktop app (or deployable in server mode for teams). On a Mac it opens in an embedded or system browser window after a local web server starts. That cross-platform design is why it feels less Mac-native than TablePlus or Postico, and why the same skills transfer to Linux, Windows, and shared team deployments. Optional AI Assistant and AI Reports let you connect your own OpenAI, Anthropic, Ollama, Docker Model Runner, or custom OpenAI-compatible API URLs. Bring your own API keys; pgAdmin does not ship a proprietary model subscription. Version 9.17 hardened the AI Assistant’s read-only transaction guard (CVE-2026-17351) among several other security fixes. Use pgAdmin when you need official PostgreSQL administration depth for free; pair a snappier native client for everyday query typing if the web UI bothers you. ## Features - **AI Assistant and AI Reports (optional, BYO LLM).** Optional AI features generate or explain SQL and produce security and performance reports, plus design reviews via Tools → AI Reports. Configure providers under Preferences → AI after enabling LLM features in server config when required. Supported provider types include OpenAI, Anthropic, Ollama, Docker Model Runner, and custom OpenAI-compatible endpoints, you supply API keys or local URLs. No cloud LLM is required for normal admin work. v9.17 fixed a lexer-differential bypass of the AI Assistant read-only transaction guard (CVE-2026-17351). - **Query Tool with Explain Visualizer.** Write SQL with highlighting and autocomplete, run statements, and browse results in a grid. The graphical Explain / Explain Analyze visualizer turns plans into a cost-colored tree so you can spot sequential scans, nested loops, and missing indexes without parsing text-only EXPLAIN output. - **ERD Tool (Entity Relationship Diagram).** Design tables and relationships (with columns) visually, or reverse-engineer an existing database into a diagram for documentation. Export diagrams as images for wikis and onboarding docs. Purpose-built PostgreSQL ERD without needing a separate paid modeling product. - **Server Dashboard and Monitoring.** Real-time style dashboards surface connections, transactions, locks, blocking queries, and related activity. Useful for catching connection leaks on local Docker Postgres and for light DBA triage on shared servers before standing up full APM. - **Backup and Restore GUI.** Wraps pg_dump and pg_restore in forms: pick databases or tables, choose SQL/custom/tar/directory formats, toggle data-only or schema-only options, and restore into targets without memorizing flag matrices. Bundled utilities track current PostgreSQL major lines (v9.17 bundles 18.4 tools). - **User and Role Management.** Create and alter roles through forms: login rights, connection limits, membership, and grants on databases, schemas, tables, and functions. Faster onboarding for developers who know application ORMs better than GRANT/REVOKE grammar. - **pgAgent Job Scheduling.** Manage pgAgent jobs from the GUI. Schedule SQL or batch maintenance, reports, and cleanup on cron-like calendars. Turns PostgreSQL into a lightweight job host when you do not want a separate scheduler for database-centric tasks. - **Cross-Platform Desktop and Server Mode.** Run as a Mac desktop app or deploy the same codebase in server mode behind a reverse proxy for team access with pgAdmin login controls. Identical PostgreSQL workflows across macOS, Linux, and Windows reduce tribal knowledge splits. ## How to Install pgAdmin 4 on Mac Install pgAdmin 4 on macOS with Homebrew Cask or download arm64/x64 DMGs from pgadmin.org / PostgreSQL FTP mirrors. Target the current v9.17 line unless your org pins an older build. 1. **Install via Homebrew or DMG.** Run `brew install --cask pgadmin4`, or download the macOS DMG for your architecture from the official download page / FTP path for v9.17. Drag the app to Applications if using the DMG. 2. **Launch and set a master password.** Open pgAdmin 4. The bundled runtime starts a local web server and opens the UI. Set a master password to encrypt saved server credentials on first run. 3. **Register a PostgreSQL server.** Right-click Servers → Register → Server. Name it, then on Connection enter host (localhost for local), port (5432), maintenance database, username, and password. Configure SSL tabs for cloud providers (Supabase, Neon, RDS, etc.). 4. **Open Query Tool and optional AI preferences.** Select a database → Tools → Query Tool (or toolbar). For AI Assistant/Reports, enable LLM features per docs, then Preferences → AI to add your OpenAI, Anthropic, or custom provider credentials, never required for core admin tasks. ## Pros - Completely free with no feature gates, tab limits, or connection caps - Official PostgreSQL admin tool with deep coverage of roles, backups, monitoring, and DDL forms - Graphical Explain visualizer remains a standout for query tuning - Built-in ERD, dashboard, backup/restore GUI, and pgAgent management - Optional BYO AI Assistant/Reports via OpenAI, Anthropic, or custom LLM URLs - Identical workflows on macOS, Linux, Windows, plus shared server-mode deployments - Active 9.x releases with documented security hardening (including v9.17 CVE fixes) ## Cons - Web-based UI feels heavier and less Mac-native than TablePlus or Postico - Startup cost of launching the Python web stack (often a few seconds) - Busy tree navigation and dense menus create a learning curve for newcomers - Higher memory use than slim native clients (often hundreds of MB) - PostgreSQL-focused, not a multi-engine studio for MySQL/Mongo/Redis in one window ## How pgAdmin fits PostgreSQL admin work on Mac How the official admin tool fits among native Mac SQL clients, multi-database IDEs, and optional LLM-assisted workflows in the pgAdmin 4 9.x era. ## FAQ ### What is the latest pgAdmin 4 version on Mac? pgAdmin 4 v9.17 is the current line covered here. Release notes are dated 2026-07-30, with the PostgreSQL news post on 2026-08-04. macOS arm64 and x64 builds are published on the official download/FTP mirrors, and Homebrew’s pgadmin4 cask tracks desktop releases. Upgrade through brew or by installing the new DMG. ### Why does pgAdmin open like a web app? pgAdmin 4 is a Python/Flask application serving an HTML/JS UI. The Mac desktop build bundles a runtime, starts a local server, and renders that UI in a window. The benefit is cross-platform parity and server-mode deployment. The cost is less native feel and higher overhead than TablePlus-style clients. ### How does the AI Assistant work, and which models does it use? AI features are optional. You bring your own provider credentials or local endpoints. OpenAI, Anthropic, Ollama, Docker Model Runner, or custom OpenAI-compatible URLs configured under Preferences → AI (with LLM enabled in config when required). pgAdmin does not mandate a single vendor model name; pick whatever models your provider account exposes. Always review generated SQL. v9.17 fixed CVE-2026-17351 affecting the AI Assistant read-only transaction guard. ### Is pgAdmin better than TablePlus for writing SQL? For raw speed and Mac polish, TablePlus usually wins day-to-day editing. pgAdmin wins on free unlimited use and administrative depth: Explain visualizer, ERD, monitoring, role forms, backup/restore GUI, pgAgent. Many developers keep both. ### Can I connect to Supabase, Neon, RDS, or other managed Postgres? Yes. Any reachable PostgreSQL endpoint works. Register host, port, database, user, password, and SSL settings from your provider dashboard. Use SSH tunnels when the vendor requires them. ### Is it safe to use pgAdmin against production? Yes with discipline: separate server groups, read-only roles by default, Auto-Commit off for writes, and careful review of destructive DDL. If you run server mode, stay current on releases, v9.17 includes multiple security fixes beyond the AI guard issue. ### Does pgAdmin support PostGIS and other extensions? Yes. Extensions appear in the object browser where applicable, geometry viewers exist for spatial data, and the query tool runs any SQL PostgreSQL accepts, including extension functions. Keep server versions within the matrix documented for your pgAdmin release (v9.17 lists PostgreSQL 14-18). ### How do I install pgAdmin with Homebrew? Run `brew install --cask pgadmin4`. Confirm the cask version matches the release you expect after upgrades with `brew upgrade --cask pgadmin4`. Alternatively download DMGs from pgadmin.org/download or the PostgreSQL FTP mirror for v9.17 macOS builds. ## Sources - [pgAdmin Official Website](https://www.pgadmin.org/) - [pgAdmin Download](https://www.pgadmin.org/download/) - [pgAdmin 4 v9.17 Release Notes](https://www.pgadmin.org/docs/pgadmin4/latest/release_notes_9_17.html) - [PostgreSQL News: pgAdmin 4 v9.17 Released](https://www.postgresql.org/about/news/pgadmin-4-v917-released-3356/) - [pgAdmin 4 v9.17 macOS Downloads (FTP)](https://www.postgresql.org/ftp/pgadmin/pgadmin4/v9.17/macos/) - [pgAdmin 4 AI Reports / AI Tools Documentation](https://www.pgadmin.org/docs/pgadmin4/latest/ai_tools.html) - [pgadmin-org/pgadmin4 on GitHub](https://github.com/pgadmin-org/pgadmin4) - [Homebrew Cask: pgadmin4](https://formulae.brew.sh/cask/pgadmin4) ## Related - [Cursor](https://bundl.run/apps/cursor) - [Claude Code](https://bundl.run/apps/claude-code) - [ChatGPT](https://bundl.run/apps/chatgpt) - [Claude](https://bundl.run/apps/claude) - [Codex](https://bundl.run/apps/codex) - [Windsurf](https://bundl.run/apps/windsurf) - [pgAdmin 4 vs DBeaver Community](https://bundl.run/compare/pgadmin4-vs-dbeaver-community) - [Free alternative to TablePlus](https://bundl.run/https:/) ```json { "@context": "https://schema.org", "@graph": [ { "@type": "Organization", "@id": "https://bundl.run/#organization", "name": "Bundl.run", "url": "https://bundl.run", "logo": { "@type": "ImageObject", "url": "https://bundl.run/og-image.png", "width": 1200, "height": 630 }, "description": "The Ninite for Mac. Install all your essential Mac apps with one terminal command.", "sameAs": [ "https://github.com/abhiofficial/bundl-mac-setup", "https://x.com/bundlrun", "https://www.producthunt.com/products/bundl-run" ], "foundingDate": "2024", "contactPoint": { "@type": "ContactPoint", "contactType": "customer support", "url": "https://bundl.run/faq" } }, { "@type": "WebSite", "@id": "https://bundl.run/#website", "name": "Bundl.run", "url": "https://bundl.run", "description": "The Ninite for Mac. Install all your essential Mac apps with one terminal command.", "publisher": { "@id": "https://bundl.run/#organization" }, "inLanguage": "en-US" }, { "@type": "Person", "@id": "https://bundl.run/authors/alex-chen#person", "name": "Alex Chen", "jobTitle": "Senior Developer Tools Specialist", "url": "https://bundl.run/authors/alex-chen", "worksFor": { "@id": "https://bundl.run/#organization" }, "description": "Alex Chen has been evaluating developer tools and productivity software for over 12 years, with deep expertise in code editors, terminal emulators, and development environments. As a former software engineer at several Bay Area startups, Alex brings hands-on experience with the real-world workflows these tools are meant to enhance. Alex tests each application extensively on both Intel and Apple Silicon Macs, documenting performance metrics, integration capabilities, and workflow efficiency. When not reviewing software, Alex contributes to open-source projects and writes technical tutorials for the developer community.", "knowsAbout": [ "Code Editors & IDEs", "Terminal Emulators", "Version Control Tools", "DevOps & CI/CD", "API Development", "Performance Benchmarking" ], "image": "https://bundl.run/authors/alex-chen.svg" }, { "@type": "BreadcrumbList", "@id": "https://bundl.run/apps/pgadmin4#breadcrumb", "itemListElement": [ { "@type": "ListItem", "position": 1, "name": "Home", "item": "https://bundl.run" }, { "@type": "ListItem", "position": 2, "name": "Apps", "item": "https://bundl.run/apps" }, { "@type": "ListItem", "position": 3, "name": "pgAdmin 4", "item": "https://bundl.run/apps/pgadmin4" } ] }, { "@type": "WebPage", "@id": "https://bundl.run/apps/pgadmin4", "url": "https://bundl.run/apps/pgadmin4", "name": "pgAdmin 4 for Mac", "description": "PostgreSQL administration and management tool", "isPartOf": { "@id": "https://bundl.run/#website" }, "publisher": { "@id": "https://bundl.run/#organization" }, "inLanguage": "en-US", "datePublished": "2026-01-01T00:00:00Z", "dateModified": "2026-08-10T13:34:04.000Z", "author": { "@id": "https://bundl.run/authors/alex-chen#person" }, "mainEntity": { "@id": "https://bundl.run/apps/pgadmin4#software" }, "breadcrumb": { "@id": "https://bundl.run/apps/pgadmin4#breadcrumb" } }, { "@type": "SoftwareApplication", "@id": "https://bundl.run/apps/pgadmin4#software", "name": "pgAdmin 4", "description": "PostgreSQL administration and management tool", "applicationCategory": "DeveloperApplication", "operatingSystem": "macOS", "url": "https://bundl.run/apps/pgadmin4", "image": { "@type": "ImageObject", "url": "https://img.logo.dev/pgadmin.org", "caption": "pgAdmin 4 app icon for Mac" }, "sameAs": [ "https://pgadmin.org/", "https://formulae.brew.sh/cask/pgadmin4" ], "review": { "@type": "Review", "author": { "@id": "https://bundl.run/authors/alex-chen#person" }, "reviewBody": "pgAdmin 4 is still the free, official admin console for PostgreSQL on Mac. v9.17 keeps security current (including CVE-2026-17351 on the AI Assistant read-only guard), ships practical UI fixes, and lets you wire BYO LLMs when you want them. It will not beat TablePlus or Postico for snappy native querying, and the Python web stack still costs RAM and patience on launch. Keep it for Explain diagrams, ERD, roles, backups, monitoring, pgAgent, and unlimited free access, especially if your team shares a server-mode instance. Pair it with a lighter query client for day-to-day editing." }, "about": { "@type": "Thing", "name": "pgAdmin 4", "description": "PostgreSQL administration and management tool" }, "isPartOf": { "@id": "https://bundl.run/#website" } }, { "@type": "Article", "@id": "https://bundl.run/apps/pgadmin4#article", "headline": "pgAdmin 4 for Mac — Full Review & Installation Guide 2026", "description": "pgAdmin 4 is still the free, official admin console for PostgreSQL on Mac. v9.17 keeps security current (including CVE-2026-17351 on the AI Assistant read-only guard), ships practical UI fixes, and lets you wire BYO LLMs when you want them. It will not beat TablePlus or Postico for snappy native querying, and the Python web stack still costs RAM and patience on launch. Keep it for Explain diagrams, ERD, roles, backups, monitoring, pgAgent, and unlimited free access, especially if your team shares a server-mode instance. Pair it with a lighter query client for day-to-day editing.", "image": "https://img.logo.dev/pgadmin.org", "author": { "@id": "https://bundl.run/authors/alex-chen#person" }, "publisher": { "@id": "https://bundl.run/#organization" }, "datePublished": "2026-01-01T00:00:00Z", "dateModified": "2026-08-10T13:34:04.000Z", "mainEntityOfPage": { "@type": "WebPage", "@id": "https://bundl.run/apps/pgadmin4" }, "articleSection": "DeveloperApplication", "speakable": { "@type": "SpeakableSpecification", "cssSelector": [ "h1", ".key-facts" ] }, "about": { "@type": "SoftwareApplication", "name": "pgAdmin 4", "url": "https://bundl.run/apps/pgadmin4" }, "mentions": [ { "@type": "SoftwareApplication", "name": "TablePlus" } ] }, { "@type": "FAQPage", "@id": "https://bundl.run/apps/pgadmin4#faq", "mainEntity": [ { "@type": "Question", "name": "What is the latest pgAdmin 4 version on Mac?", "acceptedAnswer": { "@type": "Answer", "text": "pgAdmin 4 v9.17 is the current line covered here. Release notes are dated 2026-07-30, with the PostgreSQL news post on 2026-08-04. macOS arm64 and x64 builds are published on the official download/FTP mirrors, and Homebrew’s pgadmin4 cask tracks desktop releases. Upgrade through brew or by installing the new DMG." } }, { "@type": "Question", "name": "Why does pgAdmin open like a web app?", "acceptedAnswer": { "@type": "Answer", "text": "pgAdmin 4 is a Python/Flask application serving an HTML/JS UI. The Mac desktop build bundles a runtime, starts a local server, and renders that UI in a window. The benefit is cross-platform parity and server-mode deployment. The cost is less native feel and higher overhead than TablePlus-style clients." } }, { "@type": "Question", "name": "How does the AI Assistant work, and which models does it use?", "acceptedAnswer": { "@type": "Answer", "text": "AI features are optional. You bring your own provider credentials or local endpoints. OpenAI, Anthropic, Ollama, Docker Model Runner, or custom OpenAI-compatible URLs configured under Preferences → AI (with LLM enabled in config when required). pgAdmin does not mandate a single vendor model name; pick whatever models your provider account exposes. Always review generated SQL. v9.17 fixed CVE-2026-17351 affecting the AI Assistant read-only transaction guard." } }, { "@type": "Question", "name": "Is pgAdmin better than TablePlus for writing SQL?", "acceptedAnswer": { "@type": "Answer", "text": "For raw speed and Mac polish, TablePlus usually wins day-to-day editing. pgAdmin wins on free unlimited use and administrative depth: Explain visualizer, ERD, monitoring, role forms, backup/restore GUI, pgAgent. Many developers keep both." } }, { "@type": "Question", "name": "Can I connect to Supabase, Neon, RDS, or other managed Postgres?", "acceptedAnswer": { "@type": "Answer", "text": "Yes. Any reachable PostgreSQL endpoint works. Register host, port, database, user, password, and SSL settings from your provider dashboard. Use SSH tunnels when the vendor requires them." } }, { "@type": "Question", "name": "Is it safe to use pgAdmin against production?", "acceptedAnswer": { "@type": "Answer", "text": "Yes with discipline: separate server groups, read-only roles by default, Auto-Commit off for writes, and careful review of destructive DDL. If you run server mode, stay current on releases, v9.17 includes multiple security fixes beyond the AI guard issue." } }, { "@type": "Question", "name": "Does pgAdmin support PostGIS and other extensions?", "acceptedAnswer": { "@type": "Answer", "text": "Yes. Extensions appear in the object browser where applicable, geometry viewers exist for spatial data, and the query tool runs any SQL PostgreSQL accepts, including extension functions. Keep server versions within the matrix documented for your pgAdmin release (v9.17 lists PostgreSQL 14-18)." } }, { "@type": "Question", "name": "How do I install pgAdmin with Homebrew?", "acceptedAnswer": { "@type": "Answer", "text": "Run `brew install --cask pgadmin4`. Confirm the cask version matches the release you expect after upgrades with `brew upgrade --cask pgadmin4`. Alternatively download DMGs from pgadmin.org/download or the PostgreSQL FTP mirror for v9.17 macOS builds." } } ], "isPartOf": { "@id": "https://bundl.run/apps/pgadmin4" } } ] } ```