Nanobots Producing Megastructures


    1.0.3 • Public • Published

    AdonisJS Seeder Generator

    npm npm (scoped) NPM

    This package allows you easily generate seeder files for your AdonisJS app from existing Database table files!

    Currently Supported

    • MySQL
    • SQLite
    • PostgreSQL


    You can install the package via composer:

    npm install @shagital/adonisjs-seeder-generator

    Or with yarn

    yarn add @shagital/adonisjs-seeder-generator


    Open start/app.js and add @shagital/adonisjs-seeder-generator/src/Commands/SeederGeneratorCommand to the commands array

    • Note that you can replace the adonis with node ace if adonis is not installed globally on your system.

    Basic usage

    Will generate migration files for all tables in the DB set as default, and save files in database/seeds directory

    adonis seed:generate

    Specify tables to generate seeders for

    adonis seed:generate  --include=table1,table2

    Exclude specific tables

    adonis seed:generate  --exclude=table1,table2

    Specify DB connection to use

    NOTE: Connection type must have been specified in config/databases

    adonis seed:generate  --connection=mysql2

    Save seeders files in specified path

    NOTE: The package will attempt to create the specified directory if it doesn't exist

    adonis seed:generate  --path=/var/www/html/backups

    Truncate table before inserting.

    This option is suitable for an application that hasn't gotten to production

    #f03c15 NOTE: The table content will be wiped! ENSURE THE TABLE IS BACKED UP JUST IN CASE!!!

    adonis seed:generate --force

    Example Seeder file

    'use strict';
    | CitiesSeeder
    | Make use of the Factory instance to seed database with dummy data or
    | make use of Lucid models directly.
    const Database = use('Database');
    class CitiesSeeder {
        async run () {
           await Database.connection('mysql').table('cities').truncate();
            let data = [
            "id": 219,
            "name": "Kuçovë",
            "country_id": 3,
            "state_id": 629,
            "country_code": "AL",
            "state_code": "BR",
            "latitude": 40.80028,
            "longitude": 19.91667
            "id": 280,
            "name": "Çorovodë",
            "country_id": 3,
            "state_id": 629,
            "country_code": "AL",
            "state_code": "BR",
            "latitude": 40.50417,
            "longitude": 20.22722
            var i, j, temparray, chunk = 1000;
            for (i = 0,j = data.length; i < j; i += chunk) {
                temparray = data.slice(i, i+chunk);
                await Database.connection('mysql').table('cities').insert(temparray);
    module.exports = CitiesSeeder;


    Please see CHANGELOG for more information what has changed recently.


    If you have a feature you'd like to add, kindly send a Pull Request (PR)


    If you discover any security related issues, please email instead of using the issue tracker.



    The MIT License (MIT). Please see License File for more information.


    npm i @shagital/adonisjs-seeder-generator

    DownloadsWeekly Downloads






    Unpacked Size

    23.1 kB

    Total Files


    Last publish


    • djunehor