{"id":42899,"library":"jones-mysql","title":"Jones-MySQL","description":"Jones-MySQL is a MySQL service provider for the Database Jones ORM framework, compatible with MySQL databases via the pure JavaScript mysql driver (felixge/node-mysql). Version 1.0.6 is the current stable release. It requires the database-jones package as a peer dependency and exposes connection properties for MySQL. The project is in maintenance mode with no recent updates.","status":"maintenance","version":"1.0.6","language":"javascript","source_language":"en","source_url":"https://github.com/mysql/mysql-js","tags":["javascript","mysql","orm","mapping"],"install":[{"cmd":"npm install jones-mysql","lang":"bash","label":"npm"},{"cmd":"yarn add jones-mysql","lang":"bash","label":"yarn"},{"cmd":"pnpm add jones-mysql","lang":"bash","label":"pnpm"}],"dependencies":[{"reason":"peer dependency required for ORM functionality","package":"database-jones","optional":false}],"imports":[{"note":"Package uses CommonJS, not ESM.","wrong":"import MySQLProvider from 'jones-mysql';","symbol":"MySQLProvider","correct":"const MySQLProvider = require('jones-mysql');"},{"note":"Subpath export, not included in main index.","wrong":"import { DefaultConnectionProperties } from 'jones-mysql';","symbol":"DefaultConnectionProperties","correct":"const DefaultConnectionProperties = require('jones-mysql/DefaultConnectionProperties');"}],"quickstart":{"code":"const DatabaseJones = require('database-jones');\nconst MySQLProvider = require('jones-mysql');\n\nconst db = new DatabaseJones.Database({\n  provider: MySQLProvider,\n  connection: {\n    host: process.env.MYSQL_HOST ?? 'localhost',\n    port: parseInt(process.env.MYSQL_PORT ?? '3306'),\n    user: process.env.MYSQL_USER ?? 'root',\n    password: process.env.MYSQL_PASSWORD ?? '',\n    database: process.env.MYSQL_DATABASE ?? 'test'\n  }\n});\n\n// Automatically creates tables and maps models\ndb.define('User', {\n  id: { type: 'int', primary: true, autoIncrement: true },\n  name: { type: 'string', length: 100 },\n  email: { type: 'string', length: 255 }\n});\n\ndb.sync().then(() => {\n  console.log('Database synchronized');\n}).catch(err => {\n  console.error('Sync failed:', err);\n});","lang":"javascript","description":"Shows how to initialize a Database Jones instance with the MySQL provider and sync a model."},"warnings":[{"fix":"Use require() instead of import.","message":"Package uses CommonJS; ESM imports will fail.","severity":"gotcha","affected_versions":">=1.0.0"},{"fix":"Install database-jones@1.x as a dependency.","message":"Requires peer dependency database-jones@1.x; incompatible with other major versions.","severity":"breaking","affected_versions":">=1.0.0"},{"fix":"Consider migrating to active MySQL ORMs like Sequelize or TypeORM.","message":"Package is in maintenance mode; no updates expected.","severity":"deprecated","affected_versions":">=1.0.0"}],"env_vars":null,"search_vec":"'1.0.6':30 'compat':18 'connect':49 'current':33 'databas':14,21,40 'database-jon':39 'depend':46 'driver':27 'expos':48 'felixge/node-mysql':28 'framework':17 'javascript':25,63 'jone':2,5,15,41 'jones-mysql':1,4 'mainten':57 'map':66 'mode':58 'mysql':3,6,9,20,26,52,64 'orm':16,65 'packag':42 'peer':45 'project':54 'properti':50 'provid':11 'pure':24 'recent':61 'releas':35 'requir':37 'servic':10 'stabl':34 'updat':62 'version':29 'via':22","created_at":"2026-06-05T16:57:12.068548+00:00","updated_at":"2026-06-05T16:57:12.068548+00:00","problems":[{"fix":"Run npm install jones-mysql database-jones@1.x","cause":"Package not installed or missing from node_modules.","error":"Cannot find module 'jones-mysql'"},{"fix":"Check MYSQL_USER and MYSQL_PASSWORD environment variables or connection config.","cause":"MySQL credentials are incorrect or user lacks privileges.","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":"http://github.com/mysql/mysql-js/","github":"https://github.com/mysql/mysql-js","docs":null,"changelog":null,"pypi":null,"npm":"jones-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}}