node-norm-mysql

library1.6.1jsnpmunverified

MySQL adapter for the Norm ODM/ORM framework (node-norm). Current version 1.6.1. Allows Norm to connect to MySQL databases, providing a familiar query interface. It integrates directly with Norm's Manager and connection pooling. Minimal configuration required. Released as stable with low maintenance frequency. Key differentiator: seamless integration with Norm ecosystem for MySQL databases.

database

npm install node-norm-mysql

github ↗package ↗homepage ↗

INSTALL

IMPORT

SIG · NODE-NORM-MYSQL

node-norm-mysql

databasejavascriptv1.6.1

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.

Adapter

✓ const adapter = require('node-norm-mysql');

✗ import adapter from 'node-norm-mysql';

Package does not ship ESM; use CommonJS require().

Manager

✓ const { Manager } = require('node-norm');

✗ const Manager = require('node-norm').Manager;

Correct destructuring from node-norm package.

Session

✓ const session = await manager.createSession();

✗ const Session = require('node-norm').Session;

Session is created via manager instance, not imported directly.

Initializes Norm manager with MySQL adapter, creates a session, and queries all users from the 'user' table.

const { Manager } = require('node-norm'); const manager = new Manager({ connections: [ { adapter: require('node-norm-mysql'), host: process.env.DB_HOST || 'localhost', user: process.env.DB_USER || 'root', password: process.env.DB_PASS || '', database: process.env.DB_NAME || 'foo', }, ], }); async function main() { const session = await manager.createSession(); const users = await session.query('user').all(); console.log(users); } main().catch(console.error);

Debug

Known issues

gotchaThe adapter does not support connection pooling configuration directly; uses mysql2 defaults.

fix

Configure connection pooling via mysql2 options if needed.

affects: *

gotchaNo built-in ESM support; using import will cause ERR_REQUIRE_ESM.

fix

Use require() or configure bundler to handle CommonJS.

affects: *

gotchaThe 'user' property is reserved in MySQL; avoid using it as a model name without escaping.

fix

Use backticks or different model name.

affects: *

Errors

Common errors & fixes

Cannot find module 'node-norm'

node-norm not installed as a peer dependency.

fix

npm install node-norm

Client does not support authentication protocol requested by server; consider upgrading MySQL client

Old mysql2 version incompatible with MySQL 8+ authentication.

fix

Update mysql2 to latest version: npm install mysql2@latest

Error: ER_ACCESS_DENIED_ERROR: Access denied for user 'root'@'localhost'

Incorrect credentials or host restrictions.

fix

Verify DB_HOST, DB_USER, DB_PASS environment variables match your MySQL server configuration.

Upgrade

Version history

1.6.1latest on npm

Audit

Dependencies

node-normrequiredCore ORM/ODM framework required for manager, sessions, and query building

mysql2requiredMySQL driver for Node.js used internally for database connections

Agent activity

2 hits · last 30 days

node

Resources

githubhttps://github.com/reekoheek/node-norm-mysql ↗

packagenode-norm-mysql ↗

homepagehttps://github.com/reekoheek/node-norm-mysql#readme ↗