Collimator is a JavaScript library that uses reflection techniques to introspect PostgreSQL databases:

• Enumerate table names and identify primary keys
• Generate JSON Schema v4 for a given table
• Extract table relationship information using foreign key constraints

Traditionally, programmers have defined their schema by writing model definitions in application code. Some kind of migration tool then transforms this schema into SQL, and applies it against a database.

Collimator allows this pattern to be reversed. The database now becomes the canonical source of your application's schema and relationship metadata.

Install as a dependency in your application with npm install --save collimator.

Enumerate table names and primary keys with collimator.tables(db).

Generate JSON Schema with collimator.schema(db, 'tableName').

Extract relationship information with collimator.relationships(db, 'tableName').

The top-level Collimator functions (tables, schema and relationships) accept a pg-promise Database instance as their first argument, and return a promise. For further guidance, please refer to the examples and API Documentation.

collimator.tables() also accepts a second optional options parameter. The following options are supported:

• looseNumbers - when true, then 'loose number' mode will be enabled. In this mode, numeric column types will be rendered to the JSON Schema document as {oneOf: [{type: 'number'}, {type: 'string', pattern: ...}]}.

  If the column is an integer or similar, then the regular expression ^\d+$ will be used. For decimals, ^[1-9]\d*(\.\d+)?$ will be used.

This project adheres to Semantic Versioning. For a list of detailed changes, please refer to CHANGELOG.md.

Please see CONTRIBUTING.md.

The approach to schema extraction is inspired by DDL.js. Collimator's implementation is currently not as robust as DDL.js, and only targets PostgreSQL (an intentional design decision, and unlikely to change). However, Collimator supports the extraction of relationship information.

collimator is released under the BSD 3-clause “New” License.