PostgreSQL Client

The PostgreSQL GUI Client for Mac.

A fast, native PostgreSQL GUI client for Mac. Connect to local Postgres, RDS, Supabase, Neon, or any libpq-compatible host. Browse schemas, edit rows, run queries with EXPLAIN visualization. Starts in under a second, idles at 80 MB. Free and open source.

Download for Mac Read the docs

TablePro connected to a PostgreSQL database showing the data grid and SQL editor

Features

Built for PostgreSQL.

Inline Cell Editing

Edit cells in a real spreadsheet. Add and delete rows. Review every change before commit. Full undo and redo.

SSH Tunnel Built In

Reach a remote Postgres through SSH from the connection form. Password, key, or agent auth.

Schema-Aware Autocomplete

Suggests tables, columns, aliases, Postgres functions, JSON path expressions, and CTEs. Reads schema on connect.

EXPLAIN Visualization

Render query plans as a tree. Spot full table scans, missed indexes, and costly joins at a glance.

JSONB Tree Viewer

Click any JSONB cell to open a tree view. Edit nested values. Convert dot-notation paths to JSON path expressions.

AI SQL Assistant

Ask in English, get SQL. Explain or rewrite slow queries. Works with Claude, OpenAI, and local Ollama.

Data Grid

Browse and edit data.

Sort, filter, and edit PostgreSQL data in a spreadsheet-like grid. Click any cell to edit. Insert and delete rows. Review changes before saving.

TablePro data grid showing PostgreSQL table rows with inline editing

SQL Editor

Write queries faster.

Tree-sitter syntax highlighting, schema-aware autocomplete, multi-tab, Vim mode, and full-text query history. AI assistant can write, explain, or optimize your SQL.

TablePro SQL editor with PostgreSQL query and autocomplete

Capabilities

What you can do.

Browse databases, schemas, tables, views, and materialized views
Run multiple queries in tabs with separate result sets
Filter and sort rows without writing SQL
Edit table structure including check constraints and partitions
View pg_stat_activity in the server dashboard
Stream-export huge tables to CSV, JSON, or SQL
Full-text search across query history
Safe mode blocks DELETE without WHERE

Connect

Get connected in seconds.

# Connect with TablePro
Host: 127.0.0.1
Port: 5432
User: postgres
Database: mydb

# Or via terminal
psql -h 127.0.0.1 -p 5432 -U postgres -d mydb

Supported versions

PostgreSQL 12+, including cloud providers (RDS, Cloud SQL, Azure, Supabase, Neon)

Connection types

TCP/IP
Unix Socket
SSH Tunnel
SSL/TLS (verify-full, verify-ca, require, prefer)

Default port

5432

How to

Connect to PostgreSQL in four steps.

1
Install TablePro
brew install --cask tablepro, or grab the DMG from tablepro.app/download.
2
Open New Connection
Click New Connection. Pick PostgreSQL.
3
Fill in the credentials
Host 127.0.0.1, port 5432, user postgres, password, database. SSH tab for remote.
4
Connect
Click Test, then Connect. Your schemas appear in the sidebar.

FAQ

Common PostgreSQL questions.

Is TablePro free for PostgreSQL?

Yes. AGPLv3 open source. The Postgres driver ships built in.

Does it work with Supabase, Neon, and RDS?

Yes. Any libpq-compatible host. Use the connection string they give you.

How does it compare to pgAdmin?

pgAdmin is web-based and runs in a browser. TablePro is a native Mac app. Faster start, native shortcuts, no Python runtime.

Can I edit JSONB inline?

Yes. Click any JSONB cell to open a tree editor. Add or remove keys, change types.

Does the AI run locally?

If you pick Ollama, yes. Cloud providers (Claude, OpenAI) only send what you ask them to.

Try TablePro for free.

Free and open-source. macOS 14+. Apple Silicon and Intel.

Download for Mac Setup guide