Amazon Redshift Client

The Amazon Redshift GUI Client for Mac.

A fast, native Amazon Redshift GUI client for Mac. Connect to Redshift clusters, Redshift Serverless, and Spectrum endpoints. Browse schemas, run analytical queries, view EXPLAIN plans. Streams million-row results. Free and open source.

Download for Mac Read the docs

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

Features

Built for Amazon Redshift.

Streaming Result Sets

Million-row queries open in a streaming grid. Cancel cleanly. Memory stays flat.

SSH Tunnel Built In

Reach private Redshift in a VPC through a bastion. Password, key, agent.

Redshift-Aware Autocomplete

Suggests SORTKEY, DISTKEY, ENCODE types, COPY options, SUPER path expressions.

EXPLAIN Visualization

Render Redshift plans as a tree. Spot broadcasts and full table scans at a glance.

Streaming Export

Export million-row results to CSV, JSON, or XLSX without OOM.

AI SQL Assistant

Ask in English, get Redshift SQL. Explain plans, suggest sort and dist keys.

Data Grid

Browse and edit data.

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

TablePro data grid showing Amazon Redshift 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 Amazon Redshift query and autocomplete

Capabilities

What you can do.

Browse databases, schemas, tables, views
Run multiple queries in tabs with separate results
Connect to Redshift, Redshift Serverless, Spectrum
View sort keys, dist keys, column encodings
Stream-export million-row results
Auto-reconnect on dropped connection
Full-text search across query history
Safe mode blocks TRUNCATE in production

Connect

Get connected in seconds.

# Connect with TablePro
Host: my-cluster.abc123.us-east-1.redshift.amazonaws.com
Port: 5439
User: awsuser
Database: dev
SSL: Required

# Or via terminal
psql -h my-cluster.abc123.us-east-1.redshift.amazonaws.com -p 5439 -U awsuser -d dev

Supported versions

Amazon Redshift, Redshift Serverless, Redshift Spectrum

Connection types

TCP/IP
SSH Tunnel (password, key, agent)
SSL/TLS (required by AWS)

Default port

5439

How to

Connect to Amazon Redshift 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 Amazon Redshift.
3
Fill in the cluster endpoint
Host my-cluster.xyz.region.redshift.amazonaws.com, port 5439, user awsuser, database dev. SSL on.
4
Connect
Click Test, then Connect. Databases appear in the sidebar.

FAQ

Common Amazon Redshift questions.

Is TablePro free for Redshift?

Yes. AGPLv3 open source. The Postgres driver under the hood handles Redshift.

Does it work with Redshift Serverless?

Yes. Use the workgroup endpoint as the host. SSL is on by default.

Can I use IAM authentication?

Generate a temporary password with aws redshift get-cluster-credentials, paste into TablePro. SSO via federated identity is on the roadmap.

How do I connect through a bastion?

Open the SSH tab, fill bastion host, port, key. TablePro builds the tunnel and routes Redshift traffic through it.