{"id":43445,"library":"node-norm-mysql","title":"node-norm-mysql","description":"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.","status":"active","version":"1.6.1","language":"javascript","source_language":"en","source_url":"https://github.com/reekoheek/node-norm-mysql","tags":["javascript"],"install":[{"cmd":"npm install node-norm-mysql","lang":"bash","label":"npm"},{"cmd":"yarn add node-norm-mysql","lang":"bash","label":"yarn"},{"cmd":"pnpm add node-norm-mysql","lang":"bash","label":"pnpm"}],"dependencies":[{"reason":"Core ORM/ODM framework required for manager, sessions, and query building","package":"node-norm","optional":false},{"reason":"MySQL driver for Node.js used internally for database connections","package":"mysql2","optional":false}],"imports":[{"note":"Package does not ship ESM; use CommonJS require().","wrong":"import adapter from 'node-norm-mysql';","symbol":"Adapter","correct":"const adapter = require('node-norm-mysql');"},{"note":"Correct destructuring from node-norm package.","wrong":"const Manager = require('node-norm').Manager;","symbol":"Manager","correct":"const { Manager } = require('node-norm');"},{"note":"Session is created via manager instance, not imported directly.","wrong":"const Session = require('node-norm').Session;","symbol":"Session","correct":"const session = await manager.createSession();"}],"quickstart":{"code":"const { Manager } = require('node-norm');\nconst manager = new Manager({\n  connections: [\n    {\n      adapter: require('node-norm-mysql'),\n      host: process.env.DB_HOST || 'localhost',\n      user: process.env.DB_USER || 'root',\n      password: process.env.DB_PASS || '',\n      database: process.env.DB_NAME || 'foo',\n    },\n  ],\n});\n\nasync function main() {\n  const session = await manager.createSession();\n  const users = await session.query('user').all();\n  console.log(users);\n}\n\nmain().catch(console.error);","lang":"typescript","description":"Initializes Norm manager with MySQL adapter, creates a session, and queries all users from the 'user' table."},"warnings":[{"fix":"Configure connection pooling via mysql2 options if needed.","message":"The adapter does not support connection pooling configuration directly; uses mysql2 defaults.","severity":"gotcha","affected_versions":"*"},{"fix":"Use require() or configure bundler to handle CommonJS.","message":"No built-in ESM support; using import will cause ERR_REQUIRE_ESM.","severity":"gotcha","affected_versions":"*"},{"fix":"Use backticks or different model name.","message":"The 'user' property is reserved in MySQL; avoid using it as a model name without escaping.","severity":"gotcha","affected_versions":"*"}],"env_vars":null,"search_vec":"'1.6.1':17 'adapt':6 'allow':18 'configur':41 'connect':21,38 'current':15 'databas':24,59 'differenti':51 'direct':32 'ecosystem':56 'familiar':27 'framework':11 'frequenc':49 'integr':31,53 'interfac':29 'javascript':60 'key':50 'low':47 'mainten':48 'manag':36 'minim':40 'mysql':4,5,23,58 'node':2,13 'node-norm':12 'node-norm-mysql':1 'norm':3,9,14,19,34,55 'odm/orm':10 'pool':39 'provid':25 'queri':28 'releas':43 'requir':42 'seamless':52 'stabl':45 'version':16","created_at":"2026-06-05T16:59:50.189360+00:00","updated_at":"2026-06-05T16:59:50.189360+00:00","problems":[{"fix":"npm install node-norm","cause":"node-norm not installed as a peer dependency.","error":"Cannot find module 'node-norm'"},{"fix":"Update mysql2 to latest version: npm install mysql2@latest","cause":"Old mysql2 version incompatible with MySQL 8+ authentication.","error":"Client does not support authentication protocol requested by server; consider upgrading MySQL client"},{"fix":"Verify DB_HOST, DB_USER, DB_PASS environment variables match your MySQL server configuration.","cause":"Incorrect credentials or host restrictions.","error":"Error: ER_ACCESS_DENIED_ERROR: Access denied for user 'root'@'localhost'"}],"ecosystem":"npm","meta_description":null,"install_score":null,"quickstart_score":null,"quickstart_tag":null,"pypi_latest":null,"cli_name":null,"cli_version":null,"type":"library","homepage":"https://github.com/reekoheek/node-norm-mysql#readme","github":"https://github.com/reekoheek/node-norm-mysql","docs":null,"changelog":null,"pypi":null,"npm":"node-norm-mysql","openapi_spec":null,"status_page":null,"smithery":null,"categories":["database"],"base_url":null,"auth_type":null,"provenance":{"verified_status":null,"verified_at":null,"last_verified":"2026-06-05","next_check":"2026-09-03","install_tag":null}}