RazorSQL

Query, Edit, Browse, and Manage Databases

Redshift Database Query Tool Features

RazorSQL is a database client that supports the Amazon Redshift database. AWS Redshift uses thePostgreSQL database as its database implementation, and RazorSQL includes many featuresfor working with PostgreSQL databases. It providesa customRedshift database browser tailoredto Redshift, aRedshift SQL editor with Redshift specific features and syntax highlighting, custom Redshift GUI tools,and Redshift specific databaseadministration tools. Listed below are more details on these features.

Redshift GUI Tools

Redshift Import Tool andRedshift Export Tool forimporting data into tables, or exporting data from single tables orall tables in a database
A GUIRedshift create table tool
Redshift Database Backup Tools for backing up entire PostgreSQL / Redshift schemas or single tables.
Tools for creating Redshift views and indexes
ARedshift create function tool for generating the SQL to create PostgreSQL / Redshift functions
ARedshift create trigger toolfor generating the SQL to create PostgreSQL / Redshift triggers
ARedshift alter table tool for generating the SQL toalter Redshift tables
SQL Drop Tools for droppingtables,views,indexes,functions and,triggers, for Redshift
A visualedit table tool for visually editingRedshift tables in a spreadsheet format
Tools for editingfunctions,andtriggers for Redshift.
A Generate DDL Tool for Redshift for generatingRedshift table, view, and index DDL.

Redshift Database Browser

Displays information in a tree format for schemas, tables, views,functions, triggers, indexes, constraints, users, and roles
Displays Redshift table information such as column name, column type, column length,column nullability, and primary and foreign key information
Easily view table contents or database object information via the View Contents and Show Info context menu options

Redshift SQL Editor

Edit SQL scripts. Run SQL queries. Auto column and auto table lookup. Supports over 20 programming languages including SQL, PHP, HTML, XML, Java, and more.

Redshift Database Convertion Tools Redshift Database Conversion Tools

Convert database tables from PostgreSQL / Redshift to other database types and from other database types to PostgreSQL.

Below is a screen shot of the RazorSQL AWS Redshift GUI Tool