Skip to main content
TablePro connects to Amazon Redshift using the same libpq driver as PostgreSQL, plus Redshift-specific metadata queries for distribution style, sort keys, and table size. The PostgreSQL page applies unless noted here.

​
Connection Settings

Fill in the form and click Save & Connect.
AWS IAM authentication is not available for Redshift connections (unlike MySQL and PostgreSQL). Use the cluster’s database username and password.

​
Connection URL

See Connection URL Reference.

​
Features

Schemas: like PostgreSQL, default schema public. Table metadata comes from svv_table_info: distribution style, sort keys, and table size. DDL: table definitions include DISTKEY, SORTKEY, DISTSTYLE, and ENCODE directives. Foreign keys display as informational; Redshift does not enforce them.
Redshift table info showing distribution style and sort keys

Distribution style and sort keys in table info

Backup & Restore: Backup Dump and Restore Dump run pg_dump and pg_restore for Redshift. See Backup & Restore. Import & Export: export to CSV, JSON, SQL, or XLSX. Import from CSV, JSON, or SQL. See Import & Export.

​
Structure Editing

TablePro disables the structure-editing UI for Redshift: no column, index, or key changes from the structure tab. Run ALTER TABLE statements in the SQL editor instead.

​
Limitations

Redshift is a columnar warehouse, not a general-purpose RDBMS.
  • No traditional indexes. Redshift uses DISTKEY and SORTKEY instead.
  • No enums, sequences, or triggers.
  • Foreign keys are informational. Redshift does not enforce them.
  • No Maintenance menu. Run VACUUM and ANALYZE from the SQL editor.

​
Troubleshooting

Connection refused: check the security group allows port 5439, the cluster is publicly accessible (or use an SSH tunnel), and the cluster is not paused. Auth failed: verify the master username and password in the AWS Console. Slow queries: check distribution with SELECT * FROM svv_table_info WHERE "table" = 'your_table', run ANALYZE to update stats, and match SORTKEY to your WHERE/JOIN predicates.