PostgreSQL Client

Native PostgreSQL client for macOS

TablePro connects to PostgreSQL using libpq, the official C client library. It supports PostgreSQL 12+ and all major cloud providers (AWS RDS, Google Cloud SQL, Azure Database, Supabase, Neon). You get visual EXPLAIN plans, auto-generated ER diagrams, a table structure editor, and an SQL editor with schema-aware autocomplete that knows your tables, columns, and functions.

Download for Mac Read the docs

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

Features

Built for PostgreSQL.

Explain Visualization

Run EXPLAIN ANALYZE and see the query plan as a tree diagram or visual flow. Spot sequential scans, expensive joins, and missing indexes at a glance.

Table Structure Editor

Add columns, indexes, and foreign keys without writing DDL. Rename columns, change types, set defaults, and toggle nullability from a visual interface.

ER Diagrams

Auto-generated entity-relationship diagrams from your schema. See how tables connect through foreign keys. Export as image.

SSL & SSH

Connect with SSL certificates (verify-full, verify-ca, require, prefer) or through SSH tunnels with password or key auth.

Smart Autocomplete

Schema-aware autocomplete for tables, columns, CTEs, window functions, and PostgreSQL-specific syntax like RETURNING and ON CONFLICT.

Data Grid with Filtering

Sort, filter, and paginate large tables. Edit cells inline. Insert and delete rows. Export filtered results.

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 schemas, tables, views, functions, and sequences
Visual EXPLAIN ANALYZE with cost breakdown
Edit table structure (columns, indexes, constraints, triggers)
Auto-generated ER diagrams from foreign keys
Run multiple queries in tabs with history
Filter and sort data without SQL
Export to CSV, JSON, SQL, XLSX
Server dashboard with active connections and stats

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

Try TablePro for free.

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

Download for Mac Setup guide