{"_id":"@ampsy/kysely-express-codegen","_rev":"7-23c2aae5a3f4434434a3b2a6f0c18f50","name":"@ampsy/kysely-express-codegen","dist-tags":{"latest":"0.0.7"},"versions":{"0.0.0":{"name":"@ampsy/kysely-express-codegen","version":"0.0.0","author":{"name":"Zane Ray"},"license":"ISC","_id":"@ampsy/kysely-express-codegen@0.0.0","maintainers":[{"name":"americano-psycho","email":"jonkofal@gmail.com"}],"bin":{"kysely-express-codegen":"bin/kysely-express-codegen.js"},"dist":{"shasum":"239d1f0211c7f97037e16909e6bb760e18feaa87","tarball":"https://registry.npmjs.org/@ampsy/kysely-express-codegen/-/kysely-express-codegen-0.0.0.tgz","fileCount":6,"integrity":"sha512-mmbKbl4caOeIXAoglIghudlBPOXZP6pZG3tTD9tGJj8yT/E45Y3rAABWGrUv1s3X8sSH61/VGd7faJ1/mACYIg==","signatures":[{"sig":"MEUCICR4JrmZEUyt3zh9ZTIceyhb8UBiHmLXOZ+bi6FtXDUnAiEA9AeQLDYNeWs2R2sJ0o9hGkrJ6RkNUNCYI0AQithu5u8=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":6985},"main":"bin/kysely-express-codegen.js","type":"module","gitHead":"79ac8232dc757d1c85735fc12051e0b18ab1ee22","scripts":{"dev":"export $(grep -v '^#' .env | xargs) && ./bin/kysely-express-codegen.js","build":"tsc"},"_npmUser":{"name":"americano-psycho","email":"jonkofal@gmail.com"},"repository":{"url":"git+ssh://git@github.org/jonkofal/kysely-express-codegen.git","type":"git"},"_npmVersion":"11.0.0","description":"npx function to dump a postgres database to express routes, using the kysely library","directories":{"doc":"doc","test":"test"},"_nodeVersion":"22.9.0","dependencies":{"pg":"^8.20.0"},"publishConfig":{"access":"public"},"_hasShrinkwrap":false,"devDependencies":{"tsx":"^4.22.0","express":"^5.2.1","@types/pg":"^8.20.0","typescript":"^6.0.3","@types/node":"^25.7.0","@types/express":"^5.0.6"},"_npmOperationalInternal":{"tmp":"tmp/kysely-express-codegen_0.0.0_1778928116884_0.9082247798401977","host":"s3://npm-registry-packages-npm-production"}},"0.0.2":{"name":"@ampsy/kysely-express-codegen","version":"0.0.2","author":{"name":"Zane Ray"},"license":"ISC","_id":"@ampsy/kysely-express-codegen@0.0.2","maintainers":[{"name":"americano-psycho","email":"jonkofal@gmail.com"}],"homepage":"https://github.com/jonkofal/kysely-express-codegen#readme","bugs":{"url":"https://github.com/jonkofal/kysely-express-codegen/issues"},"bin":{"kysely-express-codegen":"bin/kysely-express-codegen.js"},"dist":{"shasum":"11149771be4001da92b2a8969e2119b81894cc2b","tarball":"https://registry.npmjs.org/@ampsy/kysely-express-codegen/-/kysely-express-codegen-0.0.2.tgz","fileCount":7,"integrity":"sha512-gutBCBQ5pWZVtCj2MUTDVh6yvDFOfUaOgWrNoxvK5AapqwoeTZiaFtZMYtKiPq505jvv63/jD5Ne4BwJYrTyUA==","signatures":[{"sig":"MEUCIQCRdZFtjRJXUIgHUfQm9V8b8tPWgqD7qAQ1DuY5DLZ9XAIgfOVgnQiHJ/sqHiK781PrJV7ISyA1YoIWWDlYL26lEgU=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"attestations":{"url":"https://registry.npmjs.org/-/npm/v1/attestations/@ampsy%2fkysely-express-codegen@0.0.2","provenance":{"predicateType":"https://slsa.dev/provenance/v1"}},"unpackedSize":8448},"main":"bin/kysely-express-codegen.js","type":"module","gitHead":"f7b85a1528af987d4b95b52c2ec3b76384010f5e","scripts":{"dev":"export $(grep -v '^#' .env | xargs) && ./bin/kysely-express-codegen.js","build":"tsc"},"_npmUser":{"name":"GitHub Actions","email":"npm-oidc-no-reply@github.com","trustedPublisher":{"id":"github","oidcConfigId":"oidc:605d9687-1402-4554-9709-97968eb5c093"}},"repository":{"url":"git+https://github.com/jonkofal/kysely-express-codegen.git","type":"git"},"_npmVersion":"11.12.1","description":"npx function to dump a postgres database to express routes, using the kysely library","directories":{"doc":"doc","test":"test"},"_nodeVersion":"24.15.0","dependencies":{"pg":"^8.20.0","prompt":"^1.3.0","optimist":"^0.5.2"},"publishConfig":{"access":"public"},"_hasShrinkwrap":false,"devDependencies":{"tsx":"^4.22.0","express":"^5.2.1","@types/pg":"^8.20.0","typescript":"^6.0.3","@types/node":"^25.7.0","@types/express":"^5.0.6"},"_npmOperationalInternal":{"tmp":"tmp/kysely-express-codegen_0.0.2_1778932962487_0.43588762513573376","host":"s3://npm-registry-packages-npm-production"}},"0.0.3":{"name":"@ampsy/kysely-express-codegen","version":"0.0.3","author":{"name":"Zane Ray"},"license":"ISC","_id":"@ampsy/kysely-express-codegen@0.0.3","maintainers":[{"name":"americano-psycho","email":"jonkofal@gmail.com"}],"homepage":"https://github.com/jonkofal/kysely-express-codegen#readme","bugs":{"url":"https://github.com/jonkofal/kysely-express-codegen/issues"},"bin":{"kysely-express-codegen":"bin/kysely-express-codegen.js"},"dist":{"shasum":"dc37f0fd1b2239a4755f4895ce98ac2731389a91","tarball":"https://registry.npmjs.org/@ampsy/kysely-express-codegen/-/kysely-express-codegen-0.0.3.tgz","fileCount":9,"integrity":"sha512-T0GDvfpmNg6H2wLylz0nmcrJP34AkGfpcyfPphDJ3+hrrBOt8xEbd/37ppsN1m+g5+2x1EBYr+52dBtTMk0hkg==","signatures":[{"sig":"MEUCIQDi1x8VSMuWmu1yoIXn0mexEdOPPGudFTLWEDIjuLVcEAIgVX/4wo4D8vho9djtnc4pIYQ0BCrD89r0eRZZEZf1Wuo=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"attestations":{"url":"https://registry.npmjs.org/-/npm/v1/attestations/@ampsy%2fkysely-express-codegen@0.0.3","provenance":{"predicateType":"https://slsa.dev/provenance/v1"}},"unpackedSize":15544},"main":"bin/kysely-express-codegen.js","type":"module","gitHead":"423a3be9b7fb6cdafcc0588a6224d4c221d0f254","scripts":{"dev":"export $(grep -v '^#' .env | xargs) && ./bin/kysely-express-codegen.js","test":"node test/test.js","build":"tsc"},"_npmUser":{"name":"GitHub Actions","email":"npm-oidc-no-reply@github.com","trustedPublisher":{"id":"github","oidcConfigId":"oidc:605d9687-1402-4554-9709-97968eb5c093"}},"repository":{"url":"git+https://github.com/jonkofal/kysely-express-codegen.git","type":"git"},"_npmVersion":"11.12.1","description":"npx function to dump a postgres database to express routes, using the kysely library","directories":{"doc":"doc","test":"test"},"_nodeVersion":"24.15.0","dependencies":{"pg":"^8.20.0","prompt":"^1.3.0","optimist":"^0.5.2"},"publishConfig":{"access":"public"},"_hasShrinkwrap":false,"devDependencies":{"tsx":"^4.22.0","express":"^5.2.1","@types/pg":"^8.20.0","typescript":"^6.0.3","@types/node":"^25.7.0","@types/express":"^5.0.6"},"_npmOperationalInternal":{"tmp":"tmp/kysely-express-codegen_0.0.3_1778947040624_0.5980405674539717","host":"s3://npm-registry-packages-npm-production"}},"0.0.4":{"name":"@ampsy/kysely-express-codegen","version":"0.0.4","author":{"name":"Zane Ray"},"license":"ISC","_id":"@ampsy/kysely-express-codegen@0.0.4","maintainers":[{"name":"americano-psycho","email":"jonkofal@gmail.com"}],"homepage":"https://github.com/jonkofal/kysely-express-codegen#readme","bugs":{"url":"https://github.com/jonkofal/kysely-express-codegen/issues"},"bin":{"kysely-express-codegen":"bin/kysely-express-codegen.js"},"dist":{"shasum":"10d824fb125a0fd0e92c713c462b3dca0b17307e","tarball":"https://registry.npmjs.org/@ampsy/kysely-express-codegen/-/kysely-express-codegen-0.0.4.tgz","fileCount":14,"integrity":"sha512-Iqhz09QXTrN8SZWw2LdSGbIFuIje+XlOg4LppJgGG43eI4+Egb+YgwANgXNWeljmlyBi2I1/dtQFRXxF7Guc0g==","signatures":[{"sig":"MEUCIFUZ9UoRXZ7qgZ9fFDOWmN5IWpi+/k6dipfflH6aIMd+AiEA692s9wf74QKsVnxs17GdF8ukZdKN99s13+1tjaAcIDc=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"attestations":{"url":"https://registry.npmjs.org/-/npm/v1/attestations/@ampsy%2fkysely-express-codegen@0.0.4","provenance":{"predicateType":"https://slsa.dev/provenance/v1"}},"unpackedSize":17512},"main":"bin/kysely-express-codegen.js","type":"module","gitHead":"2321757f3ff974b7e0da24c4f3eeded744a66347","scripts":{"dev":"export $(grep -v '^#' .env | xargs) && ./bin/kysely-express-codegen.js","test":"node test/test.js","build":"tsc"},"_npmUser":{"name":"GitHub Actions","email":"npm-oidc-no-reply@github.com","trustedPublisher":{"id":"github","oidcConfigId":"oidc:605d9687-1402-4554-9709-97968eb5c093"}},"repository":{"url":"git+https://github.com/jonkofal/kysely-express-codegen.git","type":"git"},"_npmVersion":"11.12.1","description":"npx function to dump a postgres database to express routes, using the kysely library","directories":{"doc":"doc","test":"test"},"_nodeVersion":"24.15.0","dependencies":{"pg":"^8.20.0","prompt":"^1.3.0","optimist":"^0.5.2","handlebars":"^4.7.9"},"publishConfig":{"access":"public"},"_hasShrinkwrap":false,"devDependencies":{"tsx":"^4.22.0","express":"^5.2.1","@types/pg":"^8.20.0","typescript":"^6.0.3","@types/node":"^25.7.0","@types/express":"^5.0.6"},"_npmOperationalInternal":{"tmp":"tmp/kysely-express-codegen_0.0.4_1779025513814_0.1918608561893531","host":"s3://npm-registry-packages-npm-production"}},"0.0.5":{"name":"@ampsy/kysely-express-codegen","version":"0.0.5","author":{"name":"Zane Ray"},"license":"ISC","_id":"@ampsy/kysely-express-codegen@0.0.5","maintainers":[{"name":"americano-psycho","email":"jonkofal@gmail.com"}],"homepage":"https://github.com/jonkofal/kysely-express-codegen#readme","bugs":{"url":"https://github.com/jonkofal/kysely-express-codegen/issues"},"bin":{"kysely-express-codegen":"bin/kysely-express-codegen.js"},"dist":{"shasum":"d52112da3e8af203b4fd6b966e49244f27963dca","tarball":"https://registry.npmjs.org/@ampsy/kysely-express-codegen/-/kysely-express-codegen-0.0.5.tgz","fileCount":13,"integrity":"sha512-dwzs878QHnEwNCIScgv8yjWY9U4hGKn9Y6uF32QV2ygb7DP1IkMrVMjaKriqkSyx0L1WJj2dL/K9QuJhMNfQBA==","signatures":[{"sig":"MEUCIBKBA8ATVLVYO60ZP1u+ZTDChlf7rDQpdSbmlnZuBR7wAiEAnJlUBDxeeF68OCJYI263SBgz1UQmED5kv1xvU8pFDCs=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"attestations":{"url":"https://registry.npmjs.org/-/npm/v1/attestations/@ampsy%2fkysely-express-codegen@0.0.5","provenance":{"predicateType":"https://slsa.dev/provenance/v1"}},"unpackedSize":19452},"main":"bin/kysely-express-codegen.js","type":"module","gitHead":"fa6bbb95763f1ab5c964b1e4078ab09279b78722","scripts":{"dev":"export $(grep -v '^#' .env | xargs) && ./bin/kysely-express-codegen.js","test":"node test/test.js","build":"tsc"},"_npmUser":{"name":"GitHub Actions","email":"npm-oidc-no-reply@github.com","trustedPublisher":{"id":"github","oidcConfigId":"oidc:605d9687-1402-4554-9709-97968eb5c093"}},"repository":{"url":"git+https://github.com/jonkofal/kysely-express-codegen.git","type":"git"},"_npmVersion":"11.12.1","description":"npx function to dump a postgres database to express routes, using the kysely library","directories":{"doc":"doc","test":"test"},"_nodeVersion":"24.15.0","dependencies":{"pg":"^8.20.0","prompt":"^1.3.0","optimist":"^0.5.2","handlebars":"^4.7.9"},"publishConfig":{"access":"public"},"_hasShrinkwrap":false,"devDependencies":{"tsx":"^4.22.0","express":"^5.2.1","@types/pg":"^8.20.0","typescript":"^6.0.3","@types/node":"^25.7.0","@types/express":"^5.0.6"},"_npmOperationalInternal":{"tmp":"tmp/kysely-express-codegen_0.0.5_1779035590734_0.6759483611483965","host":"s3://npm-registry-packages-npm-production"}},"0.0.6":{"name":"@ampsy/kysely-express-codegen","version":"0.0.6","author":{"name":"Zane Ray"},"license":"ISC","_id":"@ampsy/kysely-express-codegen@0.0.6","maintainers":[{"name":"americano-psycho","email":"jonkofal@gmail.com"}],"homepage":"https://github.com/jonkofal/kysely-express-codegen#readme","bugs":{"url":"https://github.com/jonkofal/kysely-express-codegen/issues"},"bin":{"kysely-express-codegen":"bin/kysely-express-codegen.js"},"dist":{"shasum":"258b20a47a59337422459922ab980b9dbf1da2e9","tarball":"https://registry.npmjs.org/@ampsy/kysely-express-codegen/-/kysely-express-codegen-0.0.6.tgz","fileCount":13,"integrity":"sha512-s3g1l/CdOQ705XXL2RNrAGpTHCHMXavAOCOqoAs5f8l17S9A6xe6hJ7y4MkTm9frHM2euNju27c6RB2melm0iQ==","signatures":[{"sig":"MEUCIDvOq319L6QLAhZl3VpBt3ABt4eY/4ObSXoN0s3j7pLMAiEA6omMP8FBveGNFfRxqPcOr2JNQ3ie9m6+K+r4Obb6UHg=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"attestations":{"url":"https://registry.npmjs.org/-/npm/v1/attestations/@ampsy%2fkysely-express-codegen@0.0.6","provenance":{"predicateType":"https://slsa.dev/provenance/v1"}},"unpackedSize":19450},"main":"bin/kysely-express-codegen.js","type":"module","gitHead":"b30e4f3d10221c216a70154024e00a63e0392bc2","scripts":{"dev":"export $(grep -v '^#' .env | xargs) && ./bin/kysely-express-codegen.js","test":"node test/test.js","build":"tsc"},"_npmUser":{"name":"GitHub Actions","email":"npm-oidc-no-reply@github.com","trustedPublisher":{"id":"github","oidcConfigId":"oidc:605d9687-1402-4554-9709-97968eb5c093"}},"repository":{"url":"git+https://github.com/jonkofal/kysely-express-codegen.git","type":"git"},"_npmVersion":"11.12.1","description":"npx function to dump a postgres database to express routes, using the kysely library","directories":{"doc":"doc","test":"test"},"_nodeVersion":"24.15.0","dependencies":{"pg":"^8.20.0","prompt":"^1.3.0","optimist":"^0.5.2","handlebars":"^4.7.9"},"publishConfig":{"access":"public"},"_hasShrinkwrap":false,"devDependencies":{"tsx":"^4.22.0","express":"^5.2.1","@types/pg":"^8.20.0","typescript":"^6.0.3","@types/node":"^25.7.0","@types/express":"^5.0.6"},"_npmOperationalInternal":{"tmp":"tmp/kysely-express-codegen_0.0.6_1779036526347_0.9189268695519714","host":"s3://npm-registry-packages-npm-production"}},"0.0.7":{"name":"@ampsy/kysely-express-codegen","version":"0.0.7","description":"npx function to dump a postgres database to express routes, using the kysely library","repository":{"type":"git","url":"git+https://github.com/jonkofal/kysely-express-codegen.git"},"license":"ISC","author":{"name":"Zane Ray"},"type":"module","main":"bin/kysely-express-codegen.js","bin":{"kysely-express-codegen":"bin/kysely-express-codegen.js"},"directories":{"doc":"doc","test":"test"},"scripts":{"build":"tsc","test":"node test/test.js","dev":"export $(grep -v '^#' .env | xargs) && ./bin/kysely-express-codegen.js"},"dependencies":{"change-case":"^5.4.4","handlebars":"^4.7.9","optimist":"^0.5.2","pg":"^8.20.0","prompt":"^1.3.0"},"devDependencies":{"@types/express":"^5.0.6","@types/node":"^25.7.0","@types/pg":"^8.20.0","express":"^5.2.1","tsx":"^4.22.0","typescript":"^6.0.3"},"publishConfig":{"access":"public"},"gitHead":"726e63b781cdad80066329ce0c0a7f3409daf00c","_id":"@ampsy/kysely-express-codegen@0.0.7","bugs":{"url":"https://github.com/jonkofal/kysely-express-codegen/issues"},"homepage":"https://github.com/jonkofal/kysely-express-codegen#readme","_nodeVersion":"24.15.0","_npmVersion":"11.12.1","dist":{"integrity":"sha512-hG8QNoEcwadxPWoCtGPa1gEK/cnUGPHvJ0wzJlgkbBLwGEtpCyDTv9FXBacvi1lsVVlpPI4gyl7Mv55PkIFHHw==","shasum":"0e28bd53ff67293f1f62f09fac05f895195f270d","tarball":"https://registry.npmjs.org/@ampsy/kysely-express-codegen/-/kysely-express-codegen-0.0.7.tgz","fileCount":14,"unpackedSize":28382,"attestations":{"url":"https://registry.npmjs.org/-/npm/v1/attestations/@ampsy%2fkysely-express-codegen@0.0.7","provenance":{"predicateType":"https://slsa.dev/provenance/v1"}},"signatures":[{"keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U","sig":"MEYCIQDPmquSCbI83u2g7+HnZswRqYVqDdRyBRW1UEAftg2NWQIhAJhAvG45Gm9QZ8gUWmg/pEtqyw3CuPqHyj5Bb1zzGU1j"}]},"_npmUser":{"name":"GitHub Actions","email":"npm-oidc-no-reply@github.com","trustedPublisher":{"id":"github","oidcConfigId":"oidc:605d9687-1402-4554-9709-97968eb5c093"}},"maintainers":[{"name":"americano-psycho","email":"jonkofal@gmail.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages-npm-production","tmp":"tmp/kysely-express-codegen_0.0.7_1779135651537_0.3501516300162091"},"_hasShrinkwrap":false}},"time":{"created":"2026-05-16T10:41:56.747Z","modified":"2026-05-18T20:20:52.068Z","0.0.0":"2026-05-16T10:41:57.024Z","0.0.2":"2026-05-16T12:02:42.647Z","0.0.3":"2026-05-16T15:57:20.777Z","0.0.4":"2026-05-17T13:45:13.952Z","0.0.5":"2026-05-17T16:33:10.880Z","0.0.6":"2026-05-17T16:48:46.503Z","0.0.7":"2026-05-18T20:20:51.718Z"},"bugs":{"url":"https://github.com/jonkofal/kysely-express-codegen/issues"},"author":{"name":"Zane Ray"},"license":"ISC","homepage":"https://github.com/jonkofal/kysely-express-codegen#readme","repository":{"type":"git","url":"git+https://github.com/jonkofal/kysely-express-codegen.git"},"description":"npx function to dump a postgres database to express routes, using the kysely library","maintainers":[{"name":"americano-psycho","email":"jonkofal@gmail.com"}],"readme":"# @ampsy/kysely-express-codegen\n\nA NPX executable to query a Postgres database and generate Kysely Typescript definitions and an Typescript Express Router to expose the Postgres database tables with a\nREST API.\n\n## Usage\n\nRequires an accessible, running Postgres database.\n\nTo generate code\n\n`npx @ampsy/kysely-express-codegen`\n\n- generates Kysely code in $OUTPUT_DIR/db\n- generates Express code in $OUTPUT_DIR/routes\n\nTo feed values to the prompts, set the following Environment variables:\n\n\n- DATABASE_USERNAME=XXX\n- DATABASE_PASSWORD=YYY\n- DATABASE_NAME=ZZZ\n- DATABASE_HOST=localhost\n- DATABASE_PORT=5432\n- OUTPUT_DIR=./src\n\n## TODO\n\nEXPRESS\n- add pagination to gets\n\nJSON-SCHEMA\n- add schema generation\n\nVALIDATION\n- add validation (optional, options?)\n\nTEST\n- add build target to /dist ts->js\n- add typescript stuff for dev\n- add express for dev\n- add test index generation\n","readmeFilename":"README.md"}