{"id":41560,"library":"mysql-build","title":"mysql-build","description":"mysql-build is a code generation tool (v0.9.29) that reads a MySQL database schema and produces a corresponding mjs module with CRUD functions (post, delete, put, get, equal) and a query method. It is a Node.js port of a Ruoyi feature, with no recent updates or clear release cadence. Compared to ORMs or Prisma, it is simpler but lacks schema migrations, type safety, and active maintenance.","status":"active","version":"0.9.29","language":"javascript","source_language":"en","source_url":null,"tags":["javascript","mysql","build"],"install":[{"cmd":"npm install mysql-build","lang":"bash","label":"npm"},{"cmd":"yarn add mysql-build","lang":"bash","label":"yarn"},{"cmd":"pnpm add mysql-build","lang":"bash","label":"pnpm"}],"dependencies":[{"reason":"MySQL database driver","package":"mysql","optional":false}],"imports":[{"note":"Package is ESM-only (default export) — CommonJS require will fail.","wrong":"const build = require('mysql-build')","symbol":"build","correct":"import build from 'mysql-build'"},{"note":"Named import is incorrect; only a default export exists.","wrong":"import { build } from 'mysql-build'","symbol":"build (default import)","correct":"import build from 'mysql-build'"},{"note":"When using dynamic import, access the default property.","wrong":"import('mysql-build').then(m => m(...))","symbol":"build (dynamic import)","correct":"import('mysql-build').then(m => m.default(...))"}],"quickstart":{"code":"import build from 'mysql-build';\n\nbuild({\n  host: 'localhost',\n  port: '3306',\n  user: 'root',\n  password: process.env.MYSQL_PASSWORD ?? '',\n  database: 'my_database',\n  useUnicode: 'true',\n  characterEncoding: 'utf8'\n});\n\n// The generated 'my_database.mjs' file will be placed in the current directory.\n// Example usage of the generated file:\n// import { query, get, equal, post, put, del } from './my_database.mjs';\n// const rows = await query('SELECT * FROM users');","lang":"javascript","description":"Connects to a MySQL database, generates CRUD functions, and demonstrates usage of generated query method."},"warnings":[{"fix":"Add a setTimeout to exit after generation, or wrap in a callback if supported.","message":"The build function does not return a promise; it relies on a timeout to exit the process.","severity":"gotcha","affected_versions":">=0.0.0"},{"fix":"Use JSDoc comments or create a custom .d.ts file.","message":"Package has no TypeScript declarations; all types are implicit.","severity":"gotcha","affected_versions":">=0.0.0"},{"fix":"Use mysql2 instead, but note compatibility is not guaranteed.","message":"The package uses the old mysql driver which is not actively maintained; consider using mysql2.","severity":"deprecated","affected_versions":">=0.0.0"}],"env_vars":null,"search_vec":"'activ':69 'build':3,6,73 'cadenc':53 'clear':51 'code':9 'compar':54 'correspond':22 'crud':26 'databas':17 'delet':29 'equal':32 'featur':45 'function':27 'generat':10 'get':31 'javascript':71 'lack':63 'mainten':70 'method':36 'migrat':65 'mjs':23 'modul':24 'mysql':2,5,16,72 'mysql-build':1,4 'node.js':40 'orm':56 'port':41 'post':28 'prisma':58 'produc':20 'put':30 'queri':35 'read':14 'recent':48 'releas':52 'ruoyi':44 'safeti':67 'schema':18,64 'simpler':61 'tool':11 'type':66 'updat':49 'v0.9.29':12","created_at":"2026-06-04T18:53:00.224352+00:00","updated_at":"2026-06-04T18:53:00.224352+00:00","problems":[{"fix":"Add \"type\": \"module\" to package.json or rename file to .mjs.","cause":"Package is ESM-only, but project is not configured for ESM.","error":"SyntaxError: Cannot use import statement outside a module"},{"fix":"Run: npm install mysql","cause":"The mysql dependency is not installed.","error":"Error: Cannot find module 'mysql'"}],"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":null,"github":null,"docs":null,"changelog":null,"pypi":null,"npm":"mysql-build","openapi_spec":null,"status_page":null,"smithery":null,"categories":["database","devops"],"base_url":null,"auth_type":null,"provenance":{"verified_status":null,"verified_at":null,"last_verified":"2026-06-04","next_check":"2026-09-02","install_tag":null}}