Amazon Redshift is MPP Columnar Database offering from Amazon based on the ParAccel/PostGreSQL engine. It provides ODBC/JDBC Connectivity options but do not have an editor/query tool of its own. With my past experience of over a year with Redshift, I have used plethora of tools. Sqirrel, SQL Workbench etc to name a few. I found Aginity WorkBench to be the best tool to use with Redshift. You can register and get a full functional free version from their website. Pros : - Intelligent Typing - Scripting the objects - Nice grid for output Cons : - The DDL Script generated is not formatted. - The abort operation is not smooth