An utility module for Knex.js that generates TypeScript definitions (types) from a PostgreSQL database schema.

$ npm install knex
$ npm install knex-types --dev

const { knex } = require("knex");
const { updateTypes } = require("knex-types");

const db = knex(require("./knexfile"));

updateTypes(db, { output: "./types.ts" }).catch((err) => {
  console.error(err);
  process.exit(1);
});

Find an example of generated types in ./main.test.ts.

npm login # you need access to our kauza npm account
npm version <major|minor|patch>
npm publish

Copyright © 2021-present Kriasoft. This source code is licensed under the MIT license found in the LICENSE file.

^{Made with ♥ by Konstantin Tarkus (@koistya, blog) and contributors.}