@tonyism1/db-utils

MySQL utilities with automatic table and column creation.

Features

• Auto-create missing tables & columns
• Full CRUD (insert, update, findOne, findAll, delete)
• Create and drop tables
• query(sql, params) for raw queries
• Auto snake_case mapping optional (keeps JS camelCase)
• Safe, parameterized queries to prevent SQL injection

Installation

npm install @tonyism1/db-utils

Usage Example

import { createDB } from "@tonyism1/db-utils";

const db = await createDB({
  host: "localhost",
  user: "root",
  password: "your_pass",
  database: "my_app"
});

// Insert a client (table & columns auto-created if missing)
const clientId = await db.insert("clients", {
  name: "Tony",
  email: "[email protected]",
  loyaltyLevel: 5,
  vip: true
});

// Update client
await db.update("clients", { loyaltyLevel: 6 }, { id: clientId });

// Delete client
await db.delete("clients", { id: clientId });

// Create a new table
await db.createTable("products", {
  name: "VARCHAR(255)",
  price: "DECIMAL(10, 2)"
});

// Drop a table
await db.dropTable("products");

// Get single client
const client = await db.findOne("clients", { id: clientId });
console.log(client);

// Get multiple clients
const vipClients = await db.findAll("clients", { vip: 1 }, { limit: 50 });
console.log(vipClients);