Utility to inspect an Amazon Redshift database DDL
Last updated 7 months ago by mrlannigan .
MIT · Repository · Bugs · Original npm · Tarball · package.json
$ cnpm install @goodwaygroup/redshift-ddl 
SYNC missed versions from official npm registry.


This module will query a Amazon Redshift database to produce information about it's DDL.

CLI Usage

$ redshift-ddl load > /tmp/ddl.json

$ redshift-ddl load --connection-string=postgres://localhost:5439/thedb > /tmp/ddl.json

$ PGCONNECTIONSTRING=postgres://localhost:5439/thedb redshift-ddl load > /tmp/ddl.json

CLI Help

$ redshift-ddl --help
Usage: redshift-ddl [options] [command]

  -V, --version   output the version number
  -v, --verbose   verbose debug output
  -h, --help      output usage information

  load [options]  load the ddl

$ redshift-ddl load --help
Usage: redshift-ddl load [options]

load the ddl

  -c, --connection-string <connection>  connection string, defaults to PGCONNECTIONSTRING
  -h, --help                            output usage information

Library Usage

const { loadDDL, processDDL } = require('@goodwaygroup/redshift-ddl');

const loadedDDL = await loadDDL();
const processedDDL = await processDDL(loadedDDL);


Configuration Options

This module uses pg and by default you can use the environment variables it reads to config how the connection is made to Redshift.

Connection Environment Variables

# Redshift connection information

# Redshift connection string (preferred if defined)

Existing Connection

If you already have a pg.Pool or pg.Client created, you can pass that to loadDDL.

const ddl = await loadDDL({ conn: alreadyExistingConn });

Make a new Connection with Explicit Configuration

This module exposes convenience methods to create instances of either pg.Pool or pg.Client.

const { createClient, createPool } = require('@goodwaygroup/redshift-ddl');

// Client
const connClient = createClient({
    options: {
        statement_timeout: 15000

// Pool
const connPool = createClient({
    options: {
        statement_timeout: 15000,
        connectionTimeoutMillis: 1000,
        max: 4


Processed DDL

Using processDDL with the result to loadDDL will produce a single object organized by schema. Each schema will contain all of it's tables, views, udfs, and external tables. This is the object returned by the command line tool from this module.

Running Tests

To run tests, just run the following:

npm test

All commits are tested on CircleCI


To run eslint:

npm run lint

To auto-resolve:

npm run lint:fix


Please read CONTRIBUTING.md for details on our code of conduct, and the process for submitting pull requests to us.


We use milestones and npm version to bump versions. We also employ auto-changelog to manage the CHANGELOG.md. For the versions available, see the tags on this repository.

To initiate a version change:

npm version


See also the list of contributors who participated in this project.


This project is licensed under the MIT License - see the LICENSE file for details



Current Tags

  • 0.1.1                                ...           latest (7 months ago)

2 Versions

  • 0.1.1                                ...           7 months ago
  • 0.1.0                                ...           7 months ago
Today 0
This Week 0
This Month 3
Last Day 2
Last Week 2
Last Month 0
Dependencies (5)
Dev Dependencies (6)
Dependents (0)

Copyright 2014 - 2016 © taobao.org |