Design and Manage Amazon Redshift Databases with DbSchema
Build a clearer workflow for Amazon Redshift: reverse engineer existing schemas into interactive ER diagrams, model changes visually, and generate reviewed SQL scripts before deployment.
DbSchema is built for visual modeling, schema documentation, and deployment. Keep an offline model in Git, collaborate across teams, and publish documentation that developers, analysts, and stakeholders can navigate in minutes.
Download DbSchema See Amazon Redshift Features Download Amazon Redshift JDBC Driver
What happens after you download?
Get to your first Amazon Redshift schema diagram in minutes. No account, no credit card.
Install in minutes
Download the installer for Windows, macOS, or Linux and launch DbSchema. No signup required.
Connect to Amazon Redshift or open a sample
Reverse engineer an existing Amazon Redshift database or open a sample model to explore tables, relationships, and indexes.
Design, document, and deploy
Edit schema visually, generate documentation, and prepare reviewed migration scripts for safer releases.
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.
Connecting DbSchema to Amazon Redshift
DbSchema downloads the Amazon Redshift JDBC driver automatically — no manual setup required. The JDBC URL follows the format jdbc:redshift://cluster.region.redshift.amazonaws.com:5439/dbname. Your Redshift cluster's VPC security group must allow inbound TCP traffic on port 5439 from the machine running DbSchema. For Redshift Serverless deployments, replace the cluster endpoint with the workgroup endpoint URL; the JDBC URL structure and port remain identical. IAM authentication is also supported by configuring the IAMAuth JDBC property.
Why Teams Use DbSchema with Amazon Redshift
- 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