db-action-mysql

library0.19.2jsnpmunverified

db-action-mysql is a lightweight MySQL query builder and database action library for Node.js. Current stable version is 0.19.2. It provides a chainable API for building MySQL queries with parameterized inputs, supporting SELECT, INSERT, UPDATE, DELETE, and JOIN operations. Key differentiators include TypeScript support out of the box, minimal dependencies, and a focus on simplicity over ORM features. Releases are infrequent, focused on bug fixes.

database

npm install db-action-mysql

package ↗homepage ↗

INSTALL

IMPORT

SIG · DB-ACTION-MYSQL

db-action-mysql

databasejavascriptv0.19.2

harness data pending

Install & Compatibility

Where this runs

No compatibility data collected yet for this library.

Code

Verified usage

Verified import paths — ran on the pinned version, not inferred.

default

✓ import db from 'db-action-mysql'

✗ const db = require('db-action-mysql').default

Package exports default export for the main database class.

QueryBuilder

✓ import { QueryBuilder } from 'db-action-mysql'

✗ const { QueryBuilder } = require('db-action-mysql').default

Named export for query building utilities.

types

✓ import type { DbConfig, QueryResult } from 'db-action-mysql'

✗ import { DbConfig } from 'db-action-mysql' (const in value context)

TypeScript-only imports for configuration and result types.

Connects to a MySQL database, builds a SELECT query with a WHERE clause, and logs results.

import db from 'db-action-mysql'; const connection = db.createConnection({ host: process.env.DB_HOST ?? 'localhost', user: process.env.DB_USER ?? 'root', password: process.env.DB_PASS ?? '', database: process.env.DB_NAME ?? 'test' }); async function main() { const rows = await connection.query( db.select('users', ['id', 'name']).where({ active: true }) ); console.log(rows); } main().catch(console.error);

Debug

Known issues

breakingv0.19.0 changed the default export from a class to a factory function.

fix

Update imports: 'import db from ...' instead of 'import { Database } from ...'.

affects: >=0.19.0

deprecatedUse of direct require() with .default is deprecated in v0.18+.

fix

Switch to ES import syntax or use const db = require('db-action-mysql'); without .default.

affects: >=0.18.0

gotchaParameterized queries require using the query builder; raw strings may lead to SQL injection.

fix

Always use db.select(), db.insert(), etc., which handle escaping.

affects: all

gotchaConnection pooling not built-in; you must manage pool manually via mysql2.

fix

Use mysql2 pool and pass pool.getConnection() to db.createConnection()?

affects: all

Errors

Common errors & fixes

TypeError: db.createConnection is not a function

Using wrong import or require pattern after v0.19.0.

fix

Change to: import db from 'db-action-mysql'

Cannot find module 'db-action-mysql'

Package not installed or version mismatch.

fix

Run: npm install --save db-action-mysql

Property 'select' does not exist on type 'typeof import...'

Using TypeScript without importing the default export correctly.

fix

Use: import db from 'db-action-mysql'; then db.select()

Upgrade

Version history

0.19.2latest on npm

Audit

Dependencies

mysql2requiredUnderlying MySQL driver for database connections and queries

Agent activity

7 hits · last 30 days

node

Resources

packagedb-action-mysql ↗

homepagehttps://gitlab.com/itayronen/db-action-mysql ↗