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.
MySQLProvider
✓ const MySQLProvider = require('jones-mysql');
✗ import MySQLProvider from 'jones-mysql';
Package uses CommonJS, not ESM.
DefaultConnectionProperties
✓ const DefaultConnectionProperties = require('jones-mysql/DefaultConnectionProperties');
✗ import { DefaultConnectionProperties } from 'jones-mysql';
Subpath export, not included in main index.
Shows how to initialize a Database Jones instance with the MySQL provider and sync a model.
const DatabaseJones = require('database-jones');
const MySQLProvider = require('jones-mysql');
const db = new DatabaseJones.Database({
provider: MySQLProvider,
connection: {
host: process.env.MYSQL_HOST ?? 'localhost',
port: parseInt(process.env.MYSQL_PORT ?? '3306'),
user: process.env.MYSQL_USER ?? 'root',
password: process.env.MYSQL_PASSWORD ?? '',
database: process.env.MYSQL_DATABASE ?? 'test'
}
});
// Automatically creates tables and maps models
db.define('User', {
id: { type: 'int', primary: true, autoIncrement: true },
name: { type: 'string', length: 100 },
email: { type: 'string', length: 255 }
});
db.sync().then(() => {
console.log('Database synchronized');
}).catch(err => {
console.error('Sync failed:', err);
});
Errors
Common errors & fixes
Cannot find module 'jones-mysql'
Package not installed or missing from node_modules.
fixRun npm install jones-mysql database-jones@1.x
ER_ACCESS_DENIED_ERROR: Access denied for user 'root'@'localhost'
MySQL credentials are incorrect or user lacks privileges.
fixCheck MYSQL_USER and MYSQL_PASSWORD environment variables or connection config.
Audit
Dependencies
database-jonesrequiredpeer dependency required for ORM functionality