DB-SCOUT is a Node.js package designed to simplify PostgreSQL database schema migration by generating migration files based on an existing schema.

• Automatic Migration Generation: DB-SCOUT automatically generates migration files based on your existing PostgreSQL database schema.
• Database Agnostic: Works specifically with PostgreSQL databases.
• Customizable Configuration: Easily configure DB-SCOUT to suit your project's needs.

You can install DB-SCOUT via npm:

npm install db-scout

DB-SCOUT can be configured using a dbscout.json file in your project's root directory. Here's an example configuration:

{
  "sourceDbUrl": "YOUR_POSTGRESQL_SOURCE_DATABASE_URL",
  "destinationDbUrl": "YOUR_POSTGRESQL_DESTINATION_DATABASE_URL",
  "outputDirectory": "./migrations"
}

 sourceDbUrl: The URL of your PostgreSQL database.
 outputDirectory: The directory where migration files will be generated.

import { DbScout } from 'db-scout'
const dbScout= new DbScout({
 sourceDbUrl: "",
 outputDirectory: "",
 destinationDbUrl: ""
})

to get migration files use 

await dbScout.getMigration();

Your migration files will be created in a specified directory.

also to migrate generated migration files to destination url simply use

await dbScout.runMigrationWithTransaction() 
it will run migration in transaction so if any error occurred it will roll back.

This project is licensed under the MIT License.

DB-SCOUT is built using Node.js and PostgreSQL.

In the next version of DB-SCOUT, I plan to include support for additional databases, including MySQL, MariaDB, MongoDB, and others. Stay tuned for updates!