{"library":"sql-generate","type":"library","category":null,"description":"CLI tool and API that inspects a MySQL, PostgreSQL, or MSSQL database and generates JavaScript definitions for the node-sql library. The current stable version is 1.5.0. It is released sporadically, with no fixed cadence. Key differentiator: it automates the creation of sql.define() statements by connecting directly to your database and introspecting tables and columns, saving manual schema mapping. Note: since v1.0.0, you must install the actual database drivers (mysql, pg, mssql) separately.","language":"javascript","status":"active","version":"1.5.0","tags":["javascript","sql","generate"],"last_verified":"Fri Jun 05","install":[{"cmd":"npm install sql-generate","imports":["const generateSqlDefinition = require('sql-generate');","node-sql-generate --dsn 'mysql://user:pass@localhost/db'","npx sql-generate --dsn 'mysql://user:pass@localhost/db'"]},{"cmd":"yarn add sql-generate","imports":[]},{"cmd":"pnpm add sql-generate","imports":[]}],"homepage":"https://github.com/tmont/node-sql-generate#readme","github":"https://github.com/tmont/node-sql-generate","docs":null,"changelog":null,"pypi":null,"npm":"sql-generate","openapi_spec":null,"status_page":null,"smithery":null,"compatibility":null}