{"id":2165194,"name":"pg-schema","ecosystem":"npm","description":"validate data against a postgreSQL table","homepage":"https://github.com/kessler/pg-schema","licenses":"MIT","normalized_licenses":["MIT"],"repository_url":"https://github.com/kessler/pg-schema","keywords_array":["postgreSQL","pg","postgre"],"namespace":null,"versions_count":3,"first_release_published_at":"2014-11-18T03:29:55.578Z","latest_release_published_at":"2016-08-03T15:26:39.920Z","latest_release_number":"1.0.1","last_synced_at":"2026-08-01T06:30:52.331Z","created_at":"2022-04-09T21:54:48.806Z","updated_at":"2026-08-01T06:31:09.484Z","registry_url":"https://www.npmjs.com/package/pg-schema","install_command":"npm install pg-schema","documentation_url":null,"metadata":{"funding":null,"dist-tags":{"latest":"1.0.1"},"contentPolicy":null},"repo_metadata":{"id":17299267,"uuid":"20069719","full_name":"kessler/pg-schema","owner":"kessler","description":"create a schema object by querying the metadata tables of postgresql/redshift","archived":false,"fork":false,"pushed_at":"2016-08-03T15:26:35.000Z","size":13,"stargazers_count":4,"open_issues_count":0,"forks_count":0,"subscribers_count":1,"default_branch":"master","last_synced_at":"2025-08-13T04:43:33.230Z","etag":null,"topics":[],"latest_commit_sha":null,"homepage":"","language":"JavaScript","has_issues":true,"has_wiki":null,"has_pages":null,"mirror_url":null,"source_name":null,"license":"mit","status":null,"scm":"git","pull_requests_enabled":true,"icon_url":"https://github.com/kessler.png","metadata":{"files":{"readme":"README.md","changelog":null,"contributing":null,"funding":null,"license":"LICENSE","code_of_conduct":null,"threat_model":null,"audit":null,"citation":null,"codeowners":null,"security":null,"support":null}},"created_at":"2014-05-22T17:08:29.000Z","updated_at":"2019-08-13T15:42:12.000Z","dependencies_parsed_at":"2022-07-26T16:32:04.764Z","dependency_job_id":null,"html_url":"https://github.com/kessler/pg-schema","commit_stats":null,"previous_names":[],"tags_count":6,"template":false,"template_full_name":null,"purl":"pkg:github/kessler/pg-schema","repository_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/kessler%2Fpg-schema","tags_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/kessler%2Fpg-schema/tags","releases_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/kessler%2Fpg-schema/releases","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/kessler%2Fpg-schema/manifests","owner_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners/kessler","download_url":"https://codeload.github.com/kessler/pg-schema/tar.gz/refs/heads/master","sbom_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/kessler%2Fpg-schema/sbom","scorecard":null,"host":{"name":"GitHub","url":"https://github.com","kind":"github","repositories_count":270892207,"owners_count":24663543,"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-08-17T02:00:09.016Z","response_time":129,"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":"kessler","name":"Yaniv Kessler","uuid":"147367","kind":"user","description":"","email":"","website":"http://blog.yanivkessler.com","location":"Israel","twitter":null,"company":null,"icon_url":"https://avatars.githubusercontent.com/u/147367?u=65e80c5c461bacbe1f21a1392b36948b81d5cafc\u0026v=4","repositories_count":197,"last_synced_at":"2025-08-13T04:40:24.550Z","metadata":{"has_sponsors_listing":false},"html_url":"https://github.com/kessler","funding_links":[],"total_stars":1797,"followers":187,"following":291,"created_at":"2022-11-03T06:05:10.500Z","updated_at":"2025-08-13T04:40:24.550Z","owner_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners/kessler","repositories_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners/kessler/repositories"},"tags":[{"name":"v0.2.0","sha":"a69efb090ad81f7e3bfc24b53539b544ba5d0b57","kind":"tag","published_at":"2015-05-05T23:26:38.000Z","download_url":"https://codeload.github.com/kessler/pg-schema/tar.gz/v0.2.0","html_url":"https://github.com/kessler/pg-schema/releases/tag/v0.2.0","dependencies_parsed_at":null,"dependency_job_id":null,"purl":"pkg:github/kessler/pg-schema@v0.2.0","tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/kessler%2Fpg-schema/tags/v0.2.0","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/kessler%2Fpg-schema/tags/v0.2.0/manifests"},{"name":"v0.1.0","sha":"03a256ebabf8dbb4ac7e3730dd55106beda3793e","kind":"tag","published_at":"2014-11-18T03:28:42.000Z","download_url":"https://codeload.github.com/kessler/pg-schema/tar.gz/v0.1.0","html_url":"https://github.com/kessler/pg-schema/releases/tag/v0.1.0","dependencies_parsed_at":null,"dependency_job_id":null,"purl":"pkg:github/kessler/pg-schema@v0.1.0","tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/kessler%2Fpg-schema/tags/v0.1.0","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/kessler%2Fpg-schema/tags/v0.1.0/manifests"},{"name":"v0.0.4","sha":"a0c6ba14f21d147ef82efaae7f013c01c113dcfe","kind":"tag","published_at":"2014-11-18T03:21:44.000Z","download_url":"https://codeload.github.com/kessler/pg-schema/tar.gz/v0.0.4","html_url":"https://github.com/kessler/pg-schema/releases/tag/v0.0.4","dependencies_parsed_at":null,"dependency_job_id":null,"purl":"pkg:github/kessler/pg-schema@v0.0.4","tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/kessler%2Fpg-schema/tags/v0.0.4","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/kessler%2Fpg-schema/tags/v0.0.4/manifests"},{"name":"v0.0.3","sha":"2033b976cefc5ac744dd95f3c7500bee56dcd337","kind":"tag","published_at":"2014-11-18T01:30:53.000Z","download_url":"https://codeload.github.com/kessler/pg-schema/tar.gz/v0.0.3","html_url":"https://github.com/kessler/pg-schema/releases/tag/v0.0.3","dependencies_parsed_at":null,"dependency_job_id":null,"purl":"pkg:github/kessler/pg-schema@v0.0.3","tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/kessler%2Fpg-schema/tags/v0.0.3","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/kessler%2Fpg-schema/tags/v0.0.3/manifests"},{"name":"v0.0.2","sha":"27d9077f3e557ee96cd26beaa797927e65090c73","kind":"tag","published_at":"2014-05-22T17:10:19.000Z","download_url":"https://codeload.github.com/kessler/pg-schema/tar.gz/v0.0.2","html_url":"https://github.com/kessler/pg-schema/releases/tag/v0.0.2","dependencies_parsed_at":null,"dependency_job_id":null,"purl":"pkg:github/kessler/pg-schema@v0.0.2","tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/kessler%2Fpg-schema/tags/v0.0.2","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/kessler%2Fpg-schema/tags/v0.0.2/manifests"},{"name":"v0.0.1","sha":"9cd0e86d2e58895d48dc7a309cc68af761a0c090","kind":"tag","published_at":"2014-05-22T16:43:00.000Z","download_url":"https://codeload.github.com/kessler/pg-schema/tar.gz/v0.0.1","html_url":"https://github.com/kessler/pg-schema/releases/tag/v0.0.1","dependencies_parsed_at":null,"dependency_job_id":null,"purl":"pkg:github/kessler/pg-schema@v0.0.1","tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/kessler%2Fpg-schema/tags/v0.0.1","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/kessler%2Fpg-schema/tags/v0.0.1/manifests"}]},"repo_metadata_updated_at":"2026-08-01T06:31:09.482Z","dependent_packages_count":4,"downloads":28,"downloads_period":"last-month","dependent_repos_count":3,"rankings":{"downloads":17.395910416943135,"dependent_repos_count":6.3697724016831225,"dependent_packages_count":4.5168178280449345,"stargazers_count":12.22307605144007,"forks_count":15.420301248910082,"docker_downloads_count":null,"average":11.18517558940427},"purl":"pkg:npm/pg-schema","advisories":[],"docker_usage_url":"https://docker.ecosyste.ms/usage/npm/pg-schema","docker_dependents_count":null,"docker_downloads_count":null,"usage_url":"https://repos.ecosyste.ms/usage/npm/pg-schema","dependent_repositories_url":"https://repos.ecosyste.ms/api/v1/usage/npm/pg-schema/dependencies","status":null,"funding_links":[],"critical":null,"issue_metadata":{"last_synced_at":"2025-07-16T17:19:12.508Z","issues_count":0,"pull_requests_count":0,"avg_time_to_close_issue":null,"avg_time_to_close_pull_request":null,"issues_closed_count":0,"pull_requests_closed_count":0,"pull_request_authors_count":0,"issue_authors_count":0,"avg_comments_per_issue":null,"avg_comments_per_pull_request":null,"merged_pull_requests_count":0,"bot_issues_count":0,"bot_pull_requests_count":0,"past_year_issues_count":0,"past_year_pull_requests_count":0,"past_year_avg_time_to_close_issue":null,"past_year_avg_time_to_close_pull_request":null,"past_year_issues_closed_count":0,"past_year_pull_requests_closed_count":0,"past_year_pull_request_authors_count":0,"past_year_issue_authors_count":0,"past_year_avg_comments_per_issue":null,"past_year_avg_comments_per_pull_request":null,"past_year_bot_issues_count":0,"past_year_bot_pull_requests_count":0,"past_year_merged_pull_requests_count":0,"issues_url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/repositories/kessler%2Fpg-schema/issues","maintainers":[],"active_maintainers":[]},"versions_url":"https://packages.ecosyste.ms/api/v1/registries/npmjs.org/packages/pg-schema/versions","version_numbers_url":"https://packages.ecosyste.ms/api/v1/registries/npmjs.org/packages/pg-schema/version_numbers","latest_version_url":"https://packages.ecosyste.ms/api/v1/registries/npmjs.org/packages/pg-schema/latest_version","dependent_packages_url":"https://packages.ecosyste.ms/api/v1/registries/npmjs.org/packages/pg-schema/dependent_packages","related_packages_url":"https://packages.ecosyste.ms/api/v1/registries/npmjs.org/packages/pg-schema/related_packages","codemeta_url":"https://packages.ecosyste.ms/api/v1/registries/npmjs.org/packages/pg-schema/codemeta","maintainers":[{"uuid":"kessler","login":"kessler","name":null,"email":"yanivk@gmail.com","url":null,"packages_count":149,"html_url":"https://www.npmjs.com/~kessler","role":null,"created_at":"2022-11-13T17:50:07.684Z","updated_at":"2022-11-13T17:50:07.684Z","packages_url":"https://packages.ecosyste.ms/api/v1/registries/npmjs.org/maintainers/kessler/packages"},{"uuid":"yaniv","login":"yaniv","name":null,"email":"yanivk@gmail.com","url":null,"packages_count":55,"html_url":"https://www.npmjs.com/~yaniv","role":null,"created_at":"2022-11-13T17:50:07.701Z","updated_at":"2022-11-13T17:50:07.701Z","packages_url":"https://packages.ecosyste.ms/api/v1/registries/npmjs.org/maintainers/yaniv/packages"}]}