{"id":43428,"library":"node-data-mapper-mysql","title":"node-data-mapper MySQL Driver","description":"MySQL driver for the node-data-mapper library, version 1.1.22. This package provides MySQL-specific implementation for database interactions using node-data-mapper. It wraps the mysql2 driver and supports CRUD operations, streaming, and parameterized queries. Note that this package appears to be in maintenance mode with no recent updates and very limited documentation. It is intended for use with the node-data-mapper framework and is not standalone. Last updated around 2018, with an engine requirement of Node >=6.9.1.","status":"maintenance","version":"1.1.22","language":"javascript","source_language":"en","source_url":"git://github.com/benbotto/node-data-mapper-mysql","tags":["javascript"],"install":[{"cmd":"npm install node-data-mapper-mysql","lang":"bash","label":"npm"},{"cmd":"yarn add node-data-mapper-mysql","lang":"bash","label":"yarn"},{"cmd":"pnpm add node-data-mapper-mysql","lang":"bash","label":"pnpm"}],"dependencies":[{"reason":"Required for MySQL database connectivity.","package":"mysql2","optional":false},{"reason":"Core library providing the base DataMapper class and utilities.","package":"node-data-mapper","optional":false}],"imports":[{"note":"This package is CommonJS-only; named export. Using default import will return an object.","wrong":"const MySQLDriver = require('node-data-mapper-mysql');","symbol":"MySQLDriver","correct":"const { MySQLDriver } = require('node-data-mapper-mysql');"},{"note":"ESM import works with a bundler or Node 12+ using --experimental-modules. Default import is incorrect.","wrong":"import MySQLDriver from 'node-data-mapper-mysql';","symbol":"MySQLDriver","correct":"import { MySQLDriver } from 'node-data-mapper-mysql';"},{"note":"DataMapper is from the core package, not the MySQL driver.","wrong":"const DataMapper = require('node-data-mapper-mysql').DataMapper;","symbol":"DataMapper","correct":"const { DataMapper } = require('node-data-mapper');\nconst { MySQLDriver } = require('node-data-mapper-mysql');"}],"quickstart":{"code":"const { DataMapper } = require('node-data-mapper');\nconst { MySQLDriver } = require('node-data-mapper-mysql');\n\nconst config = {\n  client: 'mysql',\n  connection: {\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 || 'test'\n  }\n};\n\nconst dm = new DataMapper(new MySQLDriver(config));\n\ndm.find('users')\n  .where({ id: 1 })\n  .execute()\n  .then(results => {\n    console.log('User:', results);\n  })\n  .catch(err => {\n    console.error('Error:', err);\n  });","lang":"javascript","description":"This example shows how to instantiate the DataMapper with a MySQL driver and perform a simple SELECT query."},"warnings":[{"fix":"Consider using a more modern ORM like Sequelize, TypeORM, or Knex.js.","message":"This package is no longer actively maintained. Last release in 2018.","severity":"deprecated","affected_versions":"*"},{"fix":"Update node-data-mapper-mysql or use a compatible Node version.","message":"Requires Node.js >=6.9.1. May not work on newer Node versions without updating dependencies.","severity":"breaking","affected_versions":">=12.0.0"},{"fix":"Create a .d.ts file or use @ts-ignore.","message":"No TypeScript typings are provided. Manual type declarations needed in TypeScript projects.","severity":"gotcha","affected_versions":"*"},{"fix":"Update mysql2 in your package.json or run npm audit fix.","message":"The mysql2 dependency may have security vulnerabilities if not updated. Check npm audit.","severity":"gotcha","affected_versions":"*"},{"fix":"Refer to node-data-mapper documentation for connection settings.","message":"Direct use of connection pooling from mysql2 is not exposed; configure via MySQLDriver options.","severity":"gotcha","affected_versions":"*"}],"env_vars":null,"search_vec":"'1.1.22':17 '2018':83 '6.9.1':90 'appear':50 'around':82 'crud':40 'data':3,13,31,73 'databas':26 'document':63 'driver':6,8,37 'engin':86 'framework':75 'implement':24 'intend':66 'interact':27 'javascript':91 'last':80 'librari':15 'limit':62 'mainten':54 'mapper':4,14,32,74 'mode':55 'mysql':5,7,22 'mysql-specif':21 'mysql2':36 'node':2,12,30,72,89 'node-data-mapp':1,11,29,71 'note':46 'oper':41 'packag':19,49 'parameter':44 'provid':20 'queri':45 'recent':58 'requir':87 'specif':23 'standalon':79 'stream':42 'support':39 'updat':59,81 'use':28,68 'version':16 'wrap':34","created_at":"2026-06-05T16:59:45.504227+00:00","updated_at":"2026-06-05T16:59:45.504227+00:00","problems":[{"fix":"Run 'npm install node-data-mapper-mysql'.","cause":"Package not installed.","error":"Cannot find module 'node-data-mapper-mysql'"},{"fix":"Ensure you use const { MySQLDriver } = require('node-data-mapper-mysql');","cause":"Incorrect import or require syntax.","error":"TypeError: MySQLDriver is not a constructor"},{"fix":"Check DB_HOST, DB_USER, DB_PASS, DB_NAME environment variables or config object.","cause":"Invalid database credentials.","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/benbotto/node-data-mapper-mysql#readme","github":"git://github.com/benbotto/node-data-mapper-mysql","docs":null,"changelog":null,"pypi":null,"npm":"node-data-mapper-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}}