> ## Documentation Index
> Fetch the complete documentation index at: https://ngquct-feat-721-compare-sync.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# Amazon Redshift

> Connect to Redshift clusters and Serverless over the PostgreSQL wire protocol, with DISTKEY and SORTKEY metadata display

TablePro connects to Amazon Redshift using the same libpq driver as [PostgreSQL](/databases/postgresql), plus Redshift-specific metadata queries for distribution style, sort keys, and table size. The PostgreSQL page applies unless noted here.

## Connection Settings

| Field        | Default | Notes                                                                          |
| ------------ | ------- | ------------------------------------------------------------------------------ |
| **Host**     | -       | Cluster endpoint, e.g. `my-cluster.abc123xyz.us-east-1.redshift.amazonaws.com` |
| **Port**     | `5439`  |                                                                                |
| **Database** | `dev`   | **Required**; every cluster has a `dev` database                               |

Fill in the form and click **Save & Connect**.

<Note>
  AWS IAM authentication is not available for Redshift connections (unlike MySQL and PostgreSQL). Use the cluster's database username and password.
</Note>

## Connection URL

```text theme={null}
redshift://user:password@my-cluster.abc123xyz.us-east-1.redshift.amazonaws.com:5439/dev
```

See [Connection URL Reference](/databases/connection-urls).

## 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.

<Frame caption="Distribution style and sort keys in table info">
  <img className="block dark:hidden" src="https://mintcdn.com/ngquct-feat-721-compare-sync/Px1jOVnHwSdgRuFN/images/redshift-table-info-sortkeys.png?fit=max&auto=format&n=Px1jOVnHwSdgRuFN&q=85&s=b15efaed586c99a573eda3cbdc7f59e7" alt="Redshift table info showing distribution style and sort keys" width="1560" height="960" data-path="images/redshift-table-info-sortkeys.png" />

  <img className="hidden dark:block" src="https://mintcdn.com/ngquct-feat-721-compare-sync/Px1jOVnHwSdgRuFN/images/redshift-table-info-sortkeys-dark.png?fit=max&auto=format&n=Px1jOVnHwSdgRuFN&q=85&s=b0def3f9cf28c8d36443111400dff138" alt="Redshift table info showing distribution style and sort keys" width="1560" height="960" data-path="images/redshift-table-info-sortkeys-dark.png" />
</Frame>

**Backup & Restore**: **Backup Dump** and **Restore Dump** run `pg_dump` and `pg_restore` for Redshift. See [Backup & Restore](/features/backup-restore).

**Import & Export**: export to CSV, JSON, SQL, or XLSX. Import from CSV, JSON, or SQL. See [Import & Export](/features/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](/databases/ssh-tunneling)), 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.