{"id":8531332,"name":"sql-assert","ecosystem":"npm","description":"Assert identifiers (e.g. table/view names) before using them in SQL statements.","homepage":"https://github.com/PhilippSalvisberg/sql-assert","licenses":"Apache-2.0","normalized_licenses":["Apache-2.0"],"repository_url":"https://github.com/PhilippSalvisberg/sql-assert","keywords_array":["sql-injection","sql","assert","sanitise","sanitize","identifier","dbms_assert"],"namespace":null,"versions_count":5,"first_release_published_at":"2023-11-02T22:25:29.843Z","latest_release_published_at":"2023-11-28T15:05:15.823Z","latest_release_number":"1.0.4","last_synced_at":"2026-03-11T14:31:58.236Z","created_at":"2023-11-02T23:36:39.225Z","updated_at":"2026-03-11T14:31:58.236Z","registry_url":"https://www.npmjs.com/package/sql-assert","install_command":"npm install sql-assert","documentation_url":null,"metadata":{"funding":null,"dist-tags":{"latest":"1.0.4"}},"repo_metadata":{"id":205184361,"uuid":"712804513","full_name":"PhilippSalvisberg/sql-assert","owner":"PhilippSalvisberg","description":"Assert identifiers (e.g. table/view names) before using them in SQL statements.","archived":false,"fork":false,"pushed_at":"2023-11-28T15:12:36.000Z","size":232,"stargazers_count":0,"open_issues_count":0,"forks_count":0,"subscribers_count":1,"default_branch":"main","last_synced_at":"2025-08-25T14:41:27.166Z","etag":null,"topics":["javascript","sql-injection","typescript"],"latest_commit_sha":null,"homepage":"","language":"TypeScript","has_issues":true,"has_wiki":null,"has_pages":null,"mirror_url":null,"source_name":null,"license":"apache-2.0","status":null,"scm":"git","pull_requests_enabled":true,"icon_url":"https://github.com/PhilippSalvisberg.png","metadata":{"files":{"readme":"README.md","changelog":null,"contributing":null,"funding":null,"license":"LICENSE.txt","code_of_conduct":null,"threat_model":null,"audit":null,"citation":null,"codeowners":null,"security":null,"support":null,"governance":null}},"created_at":"2023-11-01T08:26:53.000Z","updated_at":"2023-11-02T22:32:30.000Z","dependencies_parsed_at":null,"dependency_job_id":"1d943846-c622-4cc0-b02d-c2f5e93d5bc4","html_url":"https://github.com/PhilippSalvisberg/sql-assert","commit_stats":null,"previous_names":["philippsalvisberg/sql-assert"],"tags_count":5,"template":false,"template_full_name":null,"purl":"pkg:github/PhilippSalvisberg/sql-assert","repository_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/PhilippSalvisberg%2Fsql-assert","tags_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/PhilippSalvisberg%2Fsql-assert/tags","releases_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/PhilippSalvisberg%2Fsql-assert/releases","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/PhilippSalvisberg%2Fsql-assert/manifests","owner_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners/PhilippSalvisberg","download_url":"https://codeload.github.com/PhilippSalvisberg/sql-assert/tar.gz/refs/heads/main","sbom_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/PhilippSalvisberg%2Fsql-assert/sbom","scorecard":null,"host":{"name":"GitHub","url":"https://github.com","kind":"github","repositories_count":277503778,"owners_count":25829273,"icon_url":"https://github.com/github.png","version":null,"created_at":"2022-05-30T11:31:42.601Z","updated_at":"2022-07-04T15:15:14.044Z","status":"online","status_checked_at":"2025-09-29T02:00:09.175Z","response_time":84,"last_error":null,"robots_txt_status":"success","robots_txt_updated_at":"2025-07-24T06:49:26.215Z","robots_txt_url":"https://github.com/robots.txt","online":true,"can_crawl_api":true,"host_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub","repositories_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories","repository_names_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repository_names","owners_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners"},"owner_record":{"login":"PhilippSalvisberg","name":"Philipp Salvisberg","uuid":"3883171","kind":"user","description":"Focused on database-centric development.","email":"","website":"https://www.salvis.com/blog/about/","location":"Winterthur, Switzerland","twitter":"phsalvisberg","company":"Accenture","icon_url":"https://avatars.githubusercontent.com/u/3883171?u=effaa5f8d65022d5c41c4c7e8dc6d1099b579efd\u0026v=4","repositories_count":40,"last_synced_at":"2024-04-17T01:07:19.056Z","metadata":{"has_sponsors_listing":false},"html_url":"https://github.com/PhilippSalvisberg","funding_links":[],"total_stars":79,"followers":96,"following":6,"created_at":"2022-11-12T19:44:58.209Z","updated_at":"2024-04-17T01:07:28.169Z","owner_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners/PhilippSalvisberg","repositories_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners/PhilippSalvisberg/repositories"},"tags":[{"name":"v1.0.4","sha":"7358106199be38a9c95ac31c2b199aaff2efa4e8","kind":"commit","published_at":"2023-11-28T15:03:52.000Z","download_url":"https://codeload.github.com/PhilippSalvisberg/sql-assert/tar.gz/v1.0.4","html_url":"https://github.com/PhilippSalvisberg/sql-assert/releases/tag/v1.0.4","dependencies_parsed_at":null,"dependency_job_id":null,"purl":"pkg:github/PhilippSalvisberg/sql-assert@v1.0.4","tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/PhilippSalvisberg%2Fsql-assert/tags/v1.0.4","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/PhilippSalvisberg%2Fsql-assert/tags/v1.0.4/manifests"},{"name":"v1.0.3","sha":"77b7688a437e431821ec432864b0170ff43e13a8","kind":"commit","published_at":"2023-11-09T17:47:44.000Z","download_url":"https://codeload.github.com/PhilippSalvisberg/sql-assert/tar.gz/v1.0.3","html_url":"https://github.com/PhilippSalvisberg/sql-assert/releases/tag/v1.0.3","dependencies_parsed_at":null,"dependency_job_id":null,"purl":"pkg:github/PhilippSalvisberg/sql-assert@v1.0.3","tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/PhilippSalvisberg%2Fsql-assert/tags/v1.0.3","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/PhilippSalvisberg%2Fsql-assert/tags/v1.0.3/manifests"},{"name":"v1.0.2","sha":"8973b87c9dfb38e456532dfe27adeb9d02fa8974","kind":"commit","published_at":"2023-11-03T06:23:28.000Z","download_url":"https://codeload.github.com/PhilippSalvisberg/sql-assert/tar.gz/v1.0.2","html_url":"https://github.com/PhilippSalvisberg/sql-assert/releases/tag/v1.0.2","dependencies_parsed_at":null,"dependency_job_id":null,"purl":"pkg:github/PhilippSalvisberg/sql-assert@v1.0.2","tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/PhilippSalvisberg%2Fsql-assert/tags/v1.0.2","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/PhilippSalvisberg%2Fsql-assert/tags/v1.0.2/manifests"},{"name":"v1.0.1","sha":"a913b4525884f1ad8991ee5ec272206f95f2006b","kind":"commit","published_at":"2023-11-03T00:07:29.000Z","download_url":"https://codeload.github.com/PhilippSalvisberg/sql-assert/tar.gz/v1.0.1","html_url":"https://github.com/PhilippSalvisberg/sql-assert/releases/tag/v1.0.1","dependencies_parsed_at":null,"dependency_job_id":null,"purl":"pkg:github/PhilippSalvisberg/sql-assert@v1.0.1","tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/PhilippSalvisberg%2Fsql-assert/tags/v1.0.1","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/PhilippSalvisberg%2Fsql-assert/tags/v1.0.1/manifests"},{"name":"v1.0.0","sha":"3ff6c267bef1fc69ef44f873b5546e9b79ca2c14","kind":"commit","published_at":"2023-11-02T22:20:32.000Z","download_url":"https://codeload.github.com/PhilippSalvisberg/sql-assert/tar.gz/v1.0.0","html_url":"https://github.com/PhilippSalvisberg/sql-assert/releases/tag/v1.0.0","dependencies_parsed_at":null,"dependency_job_id":null,"purl":"pkg:github/PhilippSalvisberg/sql-assert@v1.0.0","tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/PhilippSalvisberg%2Fsql-assert/tags/v1.0.0","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/PhilippSalvisberg%2Fsql-assert/tags/v1.0.0/manifests"}]},"repo_metadata_updated_at":"2025-11-04T21:51:32.551Z","dependent_packages_count":0,"downloads":4,"downloads_period":"last-month","dependent_repos_count":0,"rankings":{"downloads":11.675685441420926,"dependent_repos_count":36.27569069121032,"dependent_packages_count":52.06264797862777,"stargazers_count":20.972655323485494,"forks_count":15.43149453300609,"docker_downloads_count":null,"average":27.283634793550117},"purl":"pkg:npm/sql-assert","advisories":[],"docker_usage_url":"https://docker.ecosyste.ms/usage/npm/sql-assert","docker_dependents_count":null,"docker_downloads_count":null,"usage_url":"https://repos.ecosyste.ms/usage/npm/sql-assert","dependent_repositories_url":"https://repos.ecosyste.ms/api/v1/usage/npm/sql-assert/dependencies","status":null,"funding_links":[],"critical":null,"issue_metadata":null,"versions_url":"https://packages.ecosyste.ms/api/v1/registries/npmjs.org/packages/sql-assert/versions","version_numbers_url":"https://packages.ecosyste.ms/api/v1/registries/npmjs.org/packages/sql-assert/version_numbers","dependent_packages_url":"https://packages.ecosyste.ms/api/v1/registries/npmjs.org/packages/sql-assert/dependent_packages","related_packages_url":"https://packages.ecosyste.ms/api/v1/registries/npmjs.org/packages/sql-assert/related_packages","codemeta_url":"https://packages.ecosyste.ms/api/v1/registries/npmjs.org/packages/sql-assert/codemeta","maintainers":[{"uuid":"phsalvisberg","login":"phsalvisberg","name":null,"email":"philipp.salvisberg@gmail.com","url":null,"packages_count":1,"html_url":"https://www.npmjs.com/~phsalvisberg","role":null,"created_at":"2023-11-02T23:36:39.945Z","updated_at":"2023-11-02T23:36:39.945Z","packages_url":"https://packages.ecosyste.ms/api/v1/registries/npmjs.org/maintainers/phsalvisberg/packages"}]}