{"id":5802300,"name":"Azure/postgresql","ecosystem":"actions","description":"Deploy to Azure PostgreSQL database using SQL script files","homepage":null,"licenses":"mit","normalized_licenses":["MIT"],"repository_url":"https://github.com/Azure/postgresql","keywords_array":[],"namespace":"Azure","versions_count":5,"first_release_published_at":"2020-08-21T07:32:20.000Z","latest_release_published_at":"2022-08-05T18:05:09.000Z","latest_release_number":"v1.2.0","last_synced_at":"2026-04-12T14:15:43.391Z","created_at":"2023-01-04T13:40:05.065Z","updated_at":"2026-04-12T14:15:43.391Z","registry_url":"https://github.com/Azure/postgresql","install_command":null,"documentation_url":null,"metadata":{"name":"Azure PostgreSQL Action","description":"Deploy to Azure PostgreSQL database using SQL script files","inputs":{"server-name":{"description":"Server name of Azure DB for PostgreSQL. Example: fabrikam.postgres.database.azure.com","required":true},"connection-string":{"description":"The connection string, including authentication information, for the Azure PostgreSQL Server. Please provide psql connection string. Example: psql \"host={host} port={port} dbname={your_database} user={user} password={your_password} sslmode=require\"","required":true},"plsql-file":{"description":"Path to PL/SQL script file to deploy. To specify multiple files, use the regex syntax : *.sql or folder/x/\u003cregex\u003e.sql","required":true},"arguments":{"description":"Additional options supported by postgresql simple SQL shell. These options will be applied when executing the given file on the Azure DB for Postgresql. In case of multiple files, the same args will be applied for all files","required":false}},"runs":{"using":"node12","main":"lib/main.js"},"default_branch":"master","path":null},"repo_metadata":{"id":39625134,"uuid":"271788414","full_name":"Azure/postgresql","owner":"Azure","description":" Deploy to an Azure PostgreSQL database using PLSQL scripts.","archived":false,"fork":false,"pushed_at":"2023-11-17T11:21:14.000Z","size":78808,"stargazers_count":24,"open_issues_count":28,"forks_count":16,"subscribers_count":6,"default_branch":"master","last_synced_at":"2025-10-21T00:34:22.995Z","etag":null,"topics":[],"latest_commit_sha":null,"homepage":null,"language":"TypeScript","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/Azure.png","metadata":{"files":{"readme":"README.md","changelog":null,"contributing":null,"funding":null,"license":"LICENSE","code_of_conduct":"CODE_OF_CONDUCT.md","threat_model":null,"audit":null,"citation":null,"codeowners":".github/CODEOWNERS","security":"SECURITY.md","support":null,"governance":null,"roadmap":null,"authors":null,"dei":null,"publiccode":null,"codemeta":null}},"created_at":"2020-06-12T12:05:02.000Z","updated_at":"2025-09-18T20:14:22.000Z","dependencies_parsed_at":"2024-06-21T07:41:10.146Z","dependency_job_id":null,"html_url":"https://github.com/Azure/postgresql","commit_stats":{"total_commits":30,"total_committers":9,"mean_commits":"3.3333333333333335","dds":0.7666666666666666,"last_synced_commit":"f82d2b25075a9092d3ee987db9c77bcfc43fc6bc"},"previous_names":[],"tags_count":5,"template":false,"template_full_name":null,"purl":"pkg:github/Azure/postgresql","repository_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/Azure%2Fpostgresql","tags_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/Azure%2Fpostgresql/tags","releases_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/Azure%2Fpostgresql/releases","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/Azure%2Fpostgresql/manifests","owner_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners/Azure","download_url":"https://codeload.github.com/Azure/postgresql/tar.gz/refs/heads/master","sbom_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/Azure%2Fpostgresql/sbom","scorecard":{"id":18988,"data":{"date":"2025-08-11","repo":{"name":"github.com/Azure/postgresql","commit":"1d47d25bbb9375f1192ff806291f807dd2ce9e92"},"scorecard":{"version":"v5.2.1-40-gf6ed084d","commit":"f6ed084d17c9236477efd66e5b258b9d4cc7b389"},"score":4.5,"checks":[{"name":"Binary-Artifacts","score":10,"reason":"no binaries found in the repo","details":null,"documentation":{"short":"Determines if the project has generated executable (binary) artifacts in the source repository.","url":"https://github.com/ossf/scorecard/blob/f6ed084d17c9236477efd66e5b258b9d4cc7b389/docs/checks.md#binary-artifacts"}},{"name":"Security-Policy","score":10,"reason":"security policy file detected","details":["Info: security policy file detected: SECURITY.md:1","Info: Found linked content: SECURITY.md:1","Info: Found disclosure, vulnerability, and/or timelines in security policy: SECURITY.md:1","Info: Found text in security policy: SECURITY.md:1"],"documentation":{"short":"Determines if the project has published a security policy.","url":"https://github.com/ossf/scorecard/blob/f6ed084d17c9236477efd66e5b258b9d4cc7b389/docs/checks.md#security-policy"}},{"name":"Code-Review","score":7,"reason":"Found 10/13 approved changesets -- score normalized to 7","details":null,"documentation":{"short":"Determines if the project requires human code review before pull requests (aka merge requests) are merged.","url":"https://github.com/ossf/scorecard/blob/f6ed084d17c9236477efd66e5b258b9d4cc7b389/docs/checks.md#code-review"}},{"name":"Maintained","score":0,"reason":"0 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 0","details":null,"documentation":{"short":"Determines if the project is \"actively maintained\".","url":"https://github.com/ossf/scorecard/blob/f6ed084d17c9236477efd66e5b258b9d4cc7b389/docs/checks.md#maintained"}},{"name":"Token-Permissions","score":0,"reason":"detected GitHub workflow tokens with excessive permissions","details":["Warn: no topLevel permission defined: .github/workflows/ci.yml:1","Warn: no topLevel permission defined: .github/workflows/defaultLabels.yml:1","Warn: no topLevel permission defined: .github/workflows/issue-label-bot.yml:1","Info: no jobLevel write permissions found"],"documentation":{"short":"Determines if the project's workflows follow the principle of least privilege.","url":"https://github.com/ossf/scorecard/blob/f6ed084d17c9236477efd66e5b258b9d4cc7b389/docs/checks.md#token-permissions"}},{"name":"Packaging","score":-1,"reason":"packaging workflow not detected","details":["Warn: no GitHub/GitLab publishing workflow detected."],"documentation":{"short":"Determines if the project is published as a package that others can easily download, install, easily update, and uninstall.","url":"https://github.com/ossf/scorecard/blob/f6ed084d17c9236477efd66e5b258b9d4cc7b389/docs/checks.md#packaging"}},{"name":"Dangerous-Workflow","score":10,"reason":"no dangerous workflow patterns detected","details":null,"documentation":{"short":"Determines if the project's GitHub Action workflows avoid dangerous patterns.","url":"https://github.com/ossf/scorecard/blob/f6ed084d17c9236477efd66e5b258b9d4cc7b389/docs/checks.md#dangerous-workflow"}},{"name":"Pinned-Dependencies","score":0,"reason":"dependency not pinned by hash detected -- score normalized to 0","details":["Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:19: update your workflow using https://app.stepsecurity.io/secureworkflow/Azure/postgresql/ci.yml/master?enable=pin","Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/defaultLabels.yml:17: update your workflow using https://app.stepsecurity.io/secureworkflow/Azure/postgresql/defaultLabels.yml/master?enable=pin","Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/defaultLabels.yml:28: update your workflow using https://app.stepsecurity.io/secureworkflow/Azure/postgresql/defaultLabels.yml/master?enable=pin","Warn: npmCommand not pinned by hash: .github/workflows/ci.yml:23","Info:   0 out of   3 GitHub-owned GitHubAction dependencies pinned","Info:   0 out of   1 npmCommand dependencies pinned"],"documentation":{"short":"Determines if the project has declared and pinned the dependencies of its build process.","url":"https://github.com/ossf/scorecard/blob/f6ed084d17c9236477efd66e5b258b9d4cc7b389/docs/checks.md#pinned-dependencies"}},{"name":"CII-Best-Practices","score":0,"reason":"no effort to earn an OpenSSF best practices badge detected","details":null,"documentation":{"short":"Determines if the project has an OpenSSF (formerly CII) Best Practices Badge.","url":"https://github.com/ossf/scorecard/blob/f6ed084d17c9236477efd66e5b258b9d4cc7b389/docs/checks.md#cii-best-practices"}},{"name":"Fuzzing","score":0,"reason":"project is not fuzzed","details":["Warn: no fuzzer integrations found"],"documentation":{"short":"Determines if the project uses fuzzing.","url":"https://github.com/ossf/scorecard/blob/f6ed084d17c9236477efd66e5b258b9d4cc7b389/docs/checks.md#fuzzing"}},{"name":"Signed-Releases","score":-1,"reason":"no releases found","details":null,"documentation":{"short":"Determines if the project cryptographically signs release artifacts.","url":"https://github.com/ossf/scorecard/blob/f6ed084d17c9236477efd66e5b258b9d4cc7b389/docs/checks.md#signed-releases"}},{"name":"License","score":10,"reason":"license file detected","details":["Info: project has a license file: LICENSE:0","Info: FSF or OSI recognized license: MIT License: LICENSE:0"],"documentation":{"short":"Determines if the project has defined a license.","url":"https://github.com/ossf/scorecard/blob/f6ed084d17c9236477efd66e5b258b9d4cc7b389/docs/checks.md#license"}},{"name":"Branch-Protection","score":8,"reason":"branch protection is not maximal on development and all release branches","details":["Info: 'allow deletion' disabled on branch 'master'","Info: 'force pushes' disabled on branch 'master'","Warn: 'branch protection settings apply to administrators' is disabled on branch 'master'","Warn: 'stale review dismissal' is disabled on branch 'master'","Warn: required approving review count is 1 on branch 'master'","Info: codeowner review is required on branch 'master'","Info: 'last push approval' is required to merge on branch 'master'","Info: status check found to merge onto on branch 'master'","Info: PRs are required in order to make changes on branch 'master'"],"documentation":{"short":"Determines if the default and release branches are protected with GitHub's branch protection settings.","url":"https://github.com/ossf/scorecard/blob/f6ed084d17c9236477efd66e5b258b9d4cc7b389/docs/checks.md#branch-protection"}},{"name":"SAST","score":0,"reason":"SAST tool is not run on all commits -- score normalized to 0","details":["Warn: 0 commits out of 27 are checked with a SAST tool"],"documentation":{"short":"Determines if the project uses static code analysis.","url":"https://github.com/ossf/scorecard/blob/f6ed084d17c9236477efd66e5b258b9d4cc7b389/docs/checks.md#sast"}},{"name":"Vulnerabilities","score":0,"reason":"26 existing vulnerabilities detected","details":["Warn: Project is vulnerable to: GHSA-7r3h-m5j6-3q42","Warn: Project is vulnerable to: GHSA-968p-4wvh-cqc8","Warn: Project is vulnerable to: GHSA-67hx-6x53-jw92","Warn: Project is vulnerable to: GHSA-93q8-gq69-wqmw","Warn: Project is vulnerable to: GHSA-v6h2-p8h4-qcjw","Warn: Project is vulnerable to: GHSA-grv7-fg5c-xmjg","Warn: Project is vulnerable to: GHSA-3xgq-45jj-v275","Warn: Project is vulnerable to: GHSA-gxpj-cx7g-858c","Warn: Project is vulnerable to: GHSA-w573-4hg7-7wgq","Warn: Project is vulnerable to: GHSA-fjxv-7rqg-78g4","Warn: Project is vulnerable to: GHSA-896r-f27r-55mw","Warn: Project is vulnerable to: GHSA-9c47-m6qq-7p4h","Warn: Project is vulnerable to: GHSA-952p-6rrq-rcjv","Warn: Project is vulnerable to: GHSA-f8q6-p94x-37v3","Warn: Project is vulnerable to: GHSA-xvch-5gv4-984h","Warn: Project is vulnerable to: GHSA-5fw9-fq32-wv5p","Warn: Project is vulnerable to: GHSA-hj48-42vr-x3v9","Warn: Project is vulnerable to: GHSA-hrpp-h998-j3pp","Warn: Project is vulnerable to: GHSA-p8p7-x288-28g6","Warn: Project is vulnerable to: GHSA-c2qf-rxjj-qqgw","Warn: Project is vulnerable to: GHSA-jgrx-mgxx-jf9v","Warn: Project is vulnerable to: GHSA-72xf-g2v4-qvf3","Warn: Project is vulnerable to: GHSA-558p-m34m-vpmq","Warn: Project is vulnerable to: GHSA-cf4h-3jhx-xvhq","Warn: Project is vulnerable to: GHSA-j8xg-fqg3-53r7","Warn: Project is vulnerable to: GHSA-3h5v-q93c-6h6q"],"documentation":{"short":"Determines if the project has open, known unfixed vulnerabilities.","url":"https://github.com/ossf/scorecard/blob/f6ed084d17c9236477efd66e5b258b9d4cc7b389/docs/checks.md#vulnerabilities"}}]},"last_synced_at":"2025-08-14T16:23:40.767Z","repository_id":39625134,"created_at":"2025-08-14T16:23:40.767Z","updated_at":"2025-08-14T16:23:40.767Z"},"host":{"name":"GitHub","url":"https://github.com","kind":"github","repositories_count":280563531,"owners_count":26351731,"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-10-23T02:00:06.710Z","response_time":142,"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":"Azure","name":"Microsoft Azure","uuid":"6844498","kind":"organization","description":"APIs, SDKs and open source projects from Microsoft Azure","email":null,"website":"https://docs.microsoft.com/en-us/azure/","location":"United States of America","twitter":"Azure","company":null,"icon_url":"https://avatars.githubusercontent.com/u/6844498?v=4","repositories_count":2270,"last_synced_at":"2025-10-22T00:28:51.016Z","metadata":{"has_sponsors_listing":false},"html_url":"https://github.com/Azure","funding_links":[],"total_stars":207710,"followers":13341,"following":0,"created_at":"2022-11-02T16:20:18.910Z","updated_at":"2025-10-22T00:28:51.017Z","owner_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners/Azure","repositories_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners/Azure/repositories"},"tags":[{"name":"v1.1.0","sha":"59401b7890419c83f372819a1c37f5aecf57ac92","kind":"commit","published_at":"2022-08-05T18:05:09.000Z","download_url":"https://codeload.github.com/Azure/postgresql/tar.gz/v1.1.0","html_url":"https://github.com/Azure/postgresql/releases/tag/v1.1.0","dependencies_parsed_at":"2023-05-31T14:15:41.714Z","dependency_job_id":null,"purl":"pkg:github/Azure/postgresql@v1.1.0","tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/Azure%2Fpostgresql/tags/v1.1.0","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/Azure%2Fpostgresql/tags/v1.1.0/manifests"},{"name":"v1.2.0","sha":"59401b7890419c83f372819a1c37f5aecf57ac92","kind":"commit","published_at":"2022-08-05T18:05:09.000Z","download_url":"https://codeload.github.com/Azure/postgresql/tar.gz/v1.2.0","html_url":"https://github.com/Azure/postgresql/releases/tag/v1.2.0","dependencies_parsed_at":"2023-05-31T14:15:40.612Z","dependency_job_id":null,"purl":"pkg:github/Azure/postgresql@v1.2.0","tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/Azure%2Fpostgresql/tags/v1.2.0","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/Azure%2Fpostgresql/tags/v1.2.0/manifests"},{"name":"v1","sha":"59401b7890419c83f372819a1c37f5aecf57ac92","kind":"commit","published_at":"2022-08-05T18:05:09.000Z","download_url":"https://codeload.github.com/Azure/postgresql/tar.gz/v1","html_url":"https://github.com/Azure/postgresql/releases/tag/v1","dependencies_parsed_at":"2023-05-31T14:15:42.231Z","dependency_job_id":null,"purl":"pkg:github/Azure/postgresql@v1","tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/Azure%2Fpostgresql/tags/v1","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/Azure%2Fpostgresql/tags/v1/manifests"},{"name":"v1.0.1","sha":"07141f95dd744ac06b8c40d008c9f2ea5f0c960f","kind":"commit","published_at":"2020-10-21T08:56:39.000Z","download_url":"https://codeload.github.com/Azure/postgresql/tar.gz/v1.0.1","html_url":"https://github.com/Azure/postgresql/releases/tag/v1.0.1","dependencies_parsed_at":"2023-05-31T14:15:43.964Z","dependency_job_id":null,"purl":"pkg:github/Azure/postgresql@v1.0.1","tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/Azure%2Fpostgresql/tags/v1.0.1","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/Azure%2Fpostgresql/tags/v1.0.1/manifests"},{"name":"v1.0.0","sha":"5948dc55f4118c074b81f4809eb1b880513591f4","kind":"commit","published_at":"2020-08-21T07:32:20.000Z","download_url":"https://codeload.github.com/Azure/postgresql/tar.gz/v1.0.0","html_url":"https://github.com/Azure/postgresql/releases/tag/v1.0.0","dependencies_parsed_at":"2023-05-31T14:15:45.080Z","dependency_job_id":null,"purl":"pkg:github/Azure/postgresql@v1.0.0","tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/Azure%2Fpostgresql/tags/v1.0.0","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/Azure%2Fpostgresql/tags/v1.0.0/manifests"}]},"repo_metadata_updated_at":"2025-10-23T04:48:25.533Z","dependent_packages_count":0,"downloads":null,"downloads_period":null,"dependent_repos_count":1,"rankings":{"downloads":null,"dependent_repos_count":24.756773886864206,"dependent_packages_count":0.0,"stargazers_count":7.143083504991285,"forks_count":4.268737125653621,"docker_downloads_count":null,"average":9.042148629377278},"purl":"pkg:githubactions/Azure/postgresql","advisories":[],"docker_usage_url":"https://docker.ecosyste.ms/usage/actions/Azure/postgresql","docker_dependents_count":null,"docker_downloads_count":null,"usage_url":"https://repos.ecosyste.ms/usage/actions/Azure/postgresql","dependent_repositories_url":"https://repos.ecosyste.ms/api/v1/usage/actions/Azure/postgresql/dependencies","status":null,"funding_links":[],"critical":null,"issue_metadata":{"last_synced_at":"2025-09-22T06:22:53.443Z","issues_count":10,"pull_requests_count":45,"avg_time_to_close_issue":23664908.5,"avg_time_to_close_pull_request":2942549.6666666665,"issues_closed_count":2,"pull_requests_closed_count":27,"pull_request_authors_count":11,"issue_authors_count":10,"avg_comments_per_issue":2.9,"avg_comments_per_pull_request":0.2,"merged_pull_requests_count":21,"bot_issues_count":0,"bot_pull_requests_count":20,"past_year_issues_count":1,"past_year_pull_requests_count":5,"past_year_avg_time_to_close_issue":null,"past_year_avg_time_to_close_pull_request":1546621.3333333333,"past_year_issues_closed_count":0,"past_year_pull_requests_closed_count":3,"past_year_pull_request_authors_count":2,"past_year_issue_authors_count":1,"past_year_avg_comments_per_issue":0.0,"past_year_avg_comments_per_pull_request":0.4,"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/Azure%2Fpostgresql/issues","maintainers":[{"login":"alanenriqueo","count":2,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/alanenriqueo"}],"active_maintainers":[]},"versions_url":"https://packages.ecosyste.ms/api/v1/registries/github%20actions/packages/Azure%2Fpostgresql/versions","version_numbers_url":"https://packages.ecosyste.ms/api/v1/registries/github%20actions/packages/Azure%2Fpostgresql/version_numbers","dependent_packages_url":"https://packages.ecosyste.ms/api/v1/registries/github%20actions/packages/Azure%2Fpostgresql/dependent_packages","related_packages_url":"https://packages.ecosyste.ms/api/v1/registries/github%20actions/packages/Azure%2Fpostgresql/related_packages","codemeta_url":"https://packages.ecosyste.ms/api/v1/registries/github%20actions/packages/Azure%2Fpostgresql/codemeta","maintainers":[]}