@ttoss/postgresdb-cli

@ttoss/postgresdb-cli

This package provides a CLI to interact with a PostgreSQL database using the sequelize library.

Installation

pnpm add -D @ttoss/postgresdb-cli

Usage

First, you need to create define the db object in your project using the @ttoss/postgresdb package. Check @ttoss/postgresdb documentation for more information. The CLI will use this object to load the models and interact with the database.

Second, you need to define the following environment variables to connect to the database:

• DB_NAME: database name
• DB_USERNAME: database username
• DB_PASSWORD: database password
• DB_HOST: database host
• DB_PORT: database port. Default: 5432

Sync

To sync the database schema with the models, you can use the sync command:

pnpm dlx @ttoss/postgresdb-cli sync

Options

• --db-path or -d: Path to the file where the db object is defined. Default: ./src/db.js.
• --alter: Alter the database schema to match the models. Default: false.

ERD (Entity-Relationship Diagram)

To generate an ERD of the database, you can use the erd command:

pnpm dlx @ttoss/postgresdb-cli erd

Options

• --db-path or -d: Path to the file where the db object is defined. Default: ./src/db.js.