{"library":"mgsql","type":"library","category":null,"description":"A lightweight SQL utility library for Node.js that normalizes PostgreSQL and MySQL query building and execution. Current version 0.2.21. Provides a unified API with schema-aware insert/update validation, query builders (SELECT, INSERT, UPDATE), auto-parameter conversion (? -> $1 for Postgres), and result formatting. Differentiators: automatic column validation against database schema, logging support, and a simple builder pattern. Released under the MIT license by MacLaurin Group.","language":"javascript","status":"active","version":"0.2.21","tags":["javascript"],"last_verified":"Fri Jun 05","install":[{"cmd":"npm install mgsql","imports":["const mgsql = require('mgsql')","const dbConn = mgsql.getPostgresWrap(pgConnect, 'schema1,schema2')","mgsql.assert.forMissing(data, 'field1,field2')"]},{"cmd":"yarn add mgsql","imports":[]},{"cmd":"pnpm add mgsql","imports":[]}],"homepage":"https://github.com/MacLaurinGroup/mgsql#readme","github":"https://github.com/MacLaurinGroup/mgsql","docs":null,"changelog":null,"pypi":null,"npm":"mgsql","openapi_spec":null,"status_page":null,"smithery":null,"compatibility":null}