Database Credentials > Amazon Redshift

To connect Amazon Redshift to Draxlr, you need the cluster's endpoint (host), port, database name, and a database user and password.

Find Your Credentials

1: Open Your Cluster

In the AWS Console, go to Amazon Redshift → Clusters and select your cluster.

2: Copy the Endpoint

The General information panel shows the Endpoint, in the form:

my-cluster.abc123xyz.us-east-1.redshift.amazonaws.com:5439/dev

• Host: everything before the : (e.g., my-cluster.abc123xyz.us-east-1.redshift.amazonaws.com)
• Port: the number after the : (default 5439)
• Database Name: the part after the / (e.g., dev)

3: Get the Database User and Password

The Admin user name is shown under the cluster's Properties tab, in Database configurations.

If you don't have the password, select Modify on the cluster and set a new admin password—or create a dedicated read-only user by running:

CREATE USER draxlr PASSWORD 'YourStrongPassword1';
GRANT USAGE ON SCHEMA public TO draxlr;
GRANT SELECT ON ALL TABLES IN SCHEMA public TO draxlr;

Allow Draxlr's IP Address

Draxlr connects over the public internet, so the cluster must accept the connection:

1. In the cluster's Properties tab, under Network and security settings, ensure Publicly accessible is turned on.
2. Open the attached VPC security group and add an inbound rule allowing TCP port 5439 from 54.205.255.226/32.

Connect in Draxlr

Go to Add Database, select Redshift, and enter the credentials above. See the Setup guide for the full connection flow.