{"id":43986,"library":"sqlpm","title":"sqlpm","description":"sqlpm (v1.7.3) is a SQL package manager that treats SQL code as reusable, versioned packages with dependency management, semantic versioning, and testing. It leverages JavaScript tooling (yarn, jest, Lerna) under the hood but focuses on SQL DDL management. It is still in alpha, with limited documentation and likely breaking changes. Differentiated by bringing npm-like workflows to SQL, supporting multiple SQL flavors, and mono-repo integration.","status":"active","version":"1.7.3","language":"javascript","source_language":"en","source_url":"https://github.com/erichosick/sqlpm","tags":["javascript","package manager","SQL DDL","SQL"],"install":[{"cmd":"npm install sqlpm","lang":"bash","label":"npm"},{"cmd":"yarn add sqlpm","lang":"bash","label":"yarn"},{"cmd":"pnpm add sqlpm","lang":"bash","label":"pnpm"}],"dependencies":[{"reason":"Used for package management under the hood","package":"yarn","optional":true},{"reason":"Used for testing SQL packages","package":"jest","optional":true},{"reason":"Used for mono-repo and semantic versioning","package":"lerna","optional":true}],"imports":[{"note":"sqlpm is a CLI tool, not a library. Use npx or global install.","wrong":"Not a library import, but CLI tool","symbol":"cli","correct":"npx sqlpm <command>"}],"quickstart":{"code":"npm install -g sqlpm\nsqlpm generate-project my-sql-project\ncd my-sql-project\nsqlpm add-dependency my-sql-package@1.0.0\nsqlpm run-scripts","lang":"javascript","description":"Install sqlpm globally, generate a new SQL project, add a dependency, and run SQL scripts."},"warnings":[{"fix":"Pin to a specific version and test upgrades.","message":"Alpha software: APIs and behavior may change without notice.","severity":"breaking","affected_versions":"<2.0"},{"fix":"Monitor sqlpm releases for migration to other tools.","message":"Uses yarn and lerna which may have their own deprecation notices.","severity":"deprecated","affected_versions":"*"},{"fix":"Ensure Node.js >=12 and npm/yarn are in PATH.","message":"Requires Node.js and npm/yarn installed globally.","severity":"gotcha","affected_versions":"*"}],"env_vars":null,"search_vec":"'alpha':44 'break':50 'bring':54 'chang':51 'code':12 'ddl':38,74 'depend':18 'differenti':52 'document':47 'flavor':64 'focus':35 'hood':33 'integr':69 'javascript':26,70 'jest':29 'lerna':30 'leverag':25 'like':49,57 'limit':46 'manag':8,19,39,72 'mono':67 'mono-repo':66 'multipl':62 'npm':56 'npm-like':55 'packag':7,16,71 'repo':68 'reusabl':14 'semant':20 'sql':6,11,37,60,63,73,75 'sqlpm':1,2 'still':42 'support':61 'test':23 'tool':27 'treat':10 'v1.7.3':3 'version':15,21 'workflow':58 'yarn':28","created_at":"2026-06-05T17:02:26.023438+00:00","updated_at":"2026-06-05T17:02:26.023438+00:00","problems":[{"fix":"Run: npm install -g sqlpm","cause":"sqlpm not installed globally or npx not used","error":"command not found: sqlpm"},{"fix":"sqlpm is a CLI tool; use npx sqlpm or global install.","cause":"Attempted to require sqlpm as a library","error":"Cannot find module 'sqlpm'"}],"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":"https://github.com/erichosick/sqlpm/tree/main/packages/sqlpm","github":"https://github.com/erichosick/sqlpm","docs":null,"changelog":null,"pypi":null,"npm":"sqlpm","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}}