Map Redshift Distribution and Sort Keys Visually

DbSchema gives Amazon Redshift teams a design-first workflow: import the existing schema as an interactive ER diagram, refine it visually, and ship every change as a reviewed SQL script.

Built for visual modeling, schema documentation, and deployment, with an offline model you can keep in Git, team collaboration, and documentation that developers, analysts, and stakeholders can navigate in minutes.

Download DbSchema See Amazon Redshift Features Download Amazon Redshift JDBC Driver · All drivers

Visualizing Redshift Distribution and Sort Key Design

Amazon Redshift's query performance depends heavily on distribution styles (KEY, ALL, EVEN) and sort keys — design decisions that are invisible in standard SQL query tools. DbSchema connects to Redshift and renders your full schema as an ER diagram, exposing table structures and FK relationships in a navigable canvas. Data engineers use this view to validate that the schema layout aligns with expected query join patterns before committing changes to a production cluster.

Download DbSchema Free See Amazon Redshift Features

Query Redshift Data Without Writing SQL

The visual query builder in DbSchema lets you join Redshift tables, add WHERE conditions, and specify aggregations through a point-and-click interface. The resulting SQL runs against your Redshift cluster and displays results inline, without opening the Redshift query editor or writing a line of SQL.

Synchronize Schema Between Redshift Clusters

DbSchema's schema synchronization tool compares the DDL state of two Redshift environments — for example, a development cluster and a production cluster — and generates the ALTER and CREATE statements required to bring them in sync. This eliminates manual diffing and reduces deployment errors when promoting schema changes across environments.

Auto-Generate Warehouse Schema Documentation

DbSchema exports your Redshift schema as browsable HTML documentation with embedded ER diagrams and table definitions. Teams use this to maintain an up-to-date reference for data consumers, report developers, and audit requirements without granting direct warehouse access.

How to Connect DbSchema to Amazon Redshift

Reaching a live cluster and getting a diagram on screen takes four steps:

1. Install DbSchema — no signup is needed to get the installer.
2. Create a new connection and select Amazon Redshift; DbSchema downloads the JDBC driver automatically, so no manual setup is required.
3. Supply the cluster endpoint, port 5439, database name, and credentials — the resulting URL looks like jdbc:redshift://cluster.region.redshift.amazonaws.com:5439/dbname.
4. Click connect, and the cluster's tables and FK relationships populate the diagram canvas.

Before connecting, confirm the cluster's VPC security group allows inbound TCP traffic on port 5439 from the machine running DbSchema. For Redshift Serverless deployments, use the workgroup endpoint in place of the cluster endpoint — the JDBC URL structure and port stay the same. IAM authentication is also supported by configuring the IAMAuth JDBC property.

What DbSchema Adds to an Amazon Redshift Workflow

• Visualize distribution styles and sort keys alongside FK relationships in one diagram
• Compare schemas between dev and production clusters and generate sync scripts automatically
• Run ad-hoc queries on warehouse data without opening the Redshift query editor
• Document the warehouse schema for data consumers and governance reviews
• Design schema changes locally and apply them through the synchronization workflow

Map out your warehouse's distribution and sort keys before the next migration — download DbSchema for free and load the ER diagram straight from your Redshift cluster.