Getting started

If you have a Postgres server running locally with a database called, say, acme, you can run Kanel by simply typing:

$ npx kanel -d postgresql://localhost:5432/acme -o ./src/models

This will create a folder called src/models and generate a typescript file for each table in the database in said folder. This is a way to try things out quickly to get a sense of what Kanel can do with your databse.

However, you will probably want to install Kanel as a devDependency in the project where you will be using it.

$ npm i -D kanel

..and then create a configuration file, typically called .kanelrc.js. Here is an example of such a file:

const path = require("path");

/** @type {import('kanel').Config} */
module.exports = {
  connection: {
    host: "localhost",
    user: "postgres",
    password: "postgres",
    database: "acme",
  },

  preDeleteOutputFolder: true,
  outputPath: "./src/schemas",

  customTypeMap: {
    "pg_catalog.tsvector": "string",
    "pg_catalog.bpchar": "string",
  },
};

Once you have that, you can run Kanel without any parameters:

$ npx kanel

The configuration section has details on how to configure Kanel.

---