DbSchema lets you design, manage, and document Redshift databases. Create ER diagrams, define tables and columns, and generate SQL scripts - with or without a live database connection.
Use Git to share the design, compare it with the Redshift database, and deploy changes. DbSchema also includes a data editor, query builder, and HTML5 documentation - everything you need in one tool.
Choose "Connect to the database" or "New Model Connected to the Database" will let you select your database and open the Connection Dialog.
DbSchema automatically downloads the JDBC driver to connect to your database.
In the Connection Dialog window, select the JDBC URL you want to connect with. If your database is running in the cloud, choose Edit Manually and insert the JDBC URL from the cloud console.
Enter the host name, the authentication details, select your database as described in the Connection Dialog page.
In the AWS Console, go on Redshift Cluster / Configuration. There you can get the JDBC connection string.
Copy the JDBC URL in DbSchema 'JDBC URL' field, after ticking the 'Edit the JDBC URL' checkbox.
To be able to connect to the Redshift database in the cloud, is very important to make it public accessible and add it to a subnet with INBOUND access to the database port. Read below to understand how to set it.
Choose Redshift / Quick Launch Cluster / Switch to Advanced Settings
Customize Network Settings (don't use default) and choose the previous created security group and 'PUBLIC ACCESSIBLE'
You may also need to create rules for accessing the network
If you created a trial database, you can make it PUBLIC accessible from the Actions menu item
Copy the JDBC URL in DbSchema connection dialog. Enter credentials in the Connection dialog first tab.