* structure.json
`json
{
"version": "1",
"tables": [
{
"name": "users",
"columns" : [
{"name": "id", "type": "INTEGER", "constraints": "auto_increment"},
{"name": "username", "type": "varchar(20)"},
{"name": "password", "type": "char(20)"}
],
"primary_key": "id"
}
]
}
`

* main.js
`js
const Database = require("sync-mysql-database").Database;
const auth = require("./auth.json");
const struct = require("./structure.json");

var sampleDatabase = new Database(auth, struct);

sampleDatabase.getTable("users").query().select("username", "password").insert("user1", "password");
console.log(sampleDatabase.getTable("users").query().get());
``

Reference