AlgeriaCitiesData 🇩🇿 A simple CLI tool to import structured data of Algerian Wilayas, Dairas, and Communes into a PostgreSQL database.

Features:

• Automatically creates tables: wilaya, daira, communes
• Populates them with full official data from a structured JSON file
• Minimal setup – just provide your database credentials

Installation:

npm install -g algeriacitiesdata

Usage:

algeriacitiesdata

You will be prompted to enter your database connection:

DB_HOST: 127.0.0.1
DB_PORT: 5432
DB_USER: your_user
DB_PASSWORD: your_password
DB_NAME: your_database

If the connection is valid, the tool will:

• Create necessary tables if they don't exist
• Insert all wilayas, their dairas, and communes

Example Output:

✔ Tables created successfully  
✔ All data inserted successfully

Tables created:

• wilaya(id, code, name, name_ar)
• daira(id, name, name_ar, wilaya_id)
• communes(id, name, name_ar, wilaya_id, daira_id)

Author: Fares Djefaflia GitHub: https://github.com/faresdjefaflia

License: MIT