{"id":12131364,"name":"@advcomm/ddp","ecosystem":"npm","description":"Declarative Database Provisioning - DDP CLI tool","homepage":"https://github.com/canonicalapp/ddp#readme","licenses":"MIT","normalized_licenses":["MIT"],"repository_url":"https://github.com/canonicalapp/ddp","keywords_array":["postgresql","database","schema","migration","sync","cli","ddp","declarative","provisioning","postgres","sql","database-management","schema-generation","database-sync"],"namespace":"advcomm","versions_count":20,"first_release_published_at":"2025-09-23T12:25:22.587Z","latest_release_published_at":"2026-08-17T07:33:07.960Z","latest_release_number":"3.3.0","last_synced_at":"2026-08-17T07:39:18.215Z","created_at":"2025-09-24T08:06:31.929Z","updated_at":"2026-08-17T07:39:18.568Z","registry_url":"https://www.npmjs.com/package/@advcomm/ddp","install_command":"npm install @advcomm/ddp","documentation_url":null,"metadata":{"funding":null,"dist-tags":{"latest":"3.3.0"},"contentPolicy":null},"repo_metadata":{"id":315248786,"uuid":"1057109850","full_name":"canonicalapp/ddp","owner":"canonicalapp","description":"Declarative Database Provisioning. Allows users to define the 'final state' of a target database from a definition script or a running database instance. The tool automatically generates an ALTER script to sync the target database schema with the source database, preserving all data on the target database. It syncs schema changes from dev to  prod.","archived":false,"fork":false,"pushed_at":"2026-06-08T07:22:53.000Z","size":1154,"stargazers_count":0,"open_issues_count":0,"forks_count":0,"subscribers_count":0,"default_branch":"main","last_synced_at":"2026-06-08T09:16:15.593Z","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/canonicalapp.png","metadata":{"files":{"readme":"README.md","changelog":"CHANGELOG.md","contributing":null,"funding":null,"license":"LICENSE","code_of_conduct":null,"threat_model":null,"audit":null,"citation":null,"codeowners":null,"security":null,"support":null,"governance":null,"roadmap":null,"authors":null,"dei":null,"publiccode":null,"codemeta":null,"zenodo":null,"notice":null,"maintainers":null,"copyright":null,"agents":null,"dco":null,"cla":null}},"created_at":"2025-09-15T09:36:34.000Z","updated_at":"2026-06-08T07:22:55.000Z","dependencies_parsed_at":"2025-09-17T15:36:06.873Z","dependency_job_id":null,"html_url":"https://github.com/canonicalapp/ddp","commit_stats":null,"previous_names":["canonicalapp/ddp"],"tags_count":18,"template":false,"template_full_name":null,"purl":"pkg:github/canonicalapp/ddp","repository_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/canonicalapp%2Fddp","tags_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/canonicalapp%2Fddp/tags","releases_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/canonicalapp%2Fddp/releases","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/canonicalapp%2Fddp/manifests","owner_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners/canonicalapp","download_url":"https://codeload.github.com/canonicalapp/ddp/tar.gz/refs/heads/main","sbom_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/canonicalapp%2Fddp/sbom","scorecard":null,"host":{"name":"GitHub","url":"https://github.com","kind":"github","repositories_count":286080680,"owners_count":36736845,"icon_url":"https://github.com/github.png","version":null,"created_at":"2022-05-30T11:31:42.601Z","updated_at":"2026-08-06T04:43:03.162Z","status":"online","status_checked_at":"2026-08-17T02:00:06.698Z","response_time":86,"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":"canonicalapp","name":"canonicalapp","uuid":"209111664","kind":"organization","description":null,"email":null,"website":null,"location":null,"twitter":null,"company":null,"icon_url":"https://avatars.githubusercontent.com/u/209111664?v=4","repositories_count":1,"last_synced_at":"2025-08-21T18:27:15.407Z","metadata":{"has_sponsors_listing":false},"html_url":"https://github.com/canonicalapp","funding_links":[],"total_stars":0,"followers":0,"following":0,"created_at":"2025-08-21T18:27:15.450Z","updated_at":"2025-08-21T18:27:15.450Z","owner_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners/canonicalapp","repositories_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners/canonicalapp/repositories"},"tags":[{"name":"v3.2.0","sha":"0e702d0a9638fffb410d381cc67550607b882325","kind":"commit","published_at":"2026-06-08T07:22:51.000Z","download_url":"https://codeload.github.com/canonicalapp/ddp/tar.gz/v3.2.0","html_url":"https://github.com/canonicalapp/ddp/releases/tag/v3.2.0","dependencies_parsed_at":null,"dependency_job_id":null,"purl":"pkg:github/canonicalapp/ddp@v3.2.0","tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/canonicalapp%2Fddp/tags/v3.2.0","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/canonicalapp%2Fddp/tags/v3.2.0/manifests"},{"name":"v3.1.0","sha":"27cf1c34e5e7437d39d895583183dd52088336aa","kind":"commit","published_at":"2026-05-22T08:12:05.000Z","download_url":"https://codeload.github.com/canonicalapp/ddp/tar.gz/v3.1.0","html_url":"https://github.com/canonicalapp/ddp/releases/tag/v3.1.0","dependencies_parsed_at":null,"dependency_job_id":null,"purl":"pkg:github/canonicalapp/ddp@v3.1.0","tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/canonicalapp%2Fddp/tags/v3.1.0","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/canonicalapp%2Fddp/tags/v3.1.0/manifests"},{"name":"v3.0.2","sha":"edf01cfe55564455a043486806371910f32ed44d","kind":"commit","published_at":"2026-05-08T13:47:31.000Z","download_url":"https://codeload.github.com/canonicalapp/ddp/tar.gz/v3.0.2","html_url":"https://github.com/canonicalapp/ddp/releases/tag/v3.0.2","dependencies_parsed_at":null,"dependency_job_id":null,"purl":"pkg:github/canonicalapp/ddp@v3.0.2","tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/canonicalapp%2Fddp/tags/v3.0.2","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/canonicalapp%2Fddp/tags/v3.0.2/manifests"},{"name":"v3.0.1","sha":"5c55f24a4114547372e4ce5bf490869d5803a34b","kind":"commit","published_at":"2026-05-08T13:36:11.000Z","download_url":"https://codeload.github.com/canonicalapp/ddp/tar.gz/v3.0.1","html_url":"https://github.com/canonicalapp/ddp/releases/tag/v3.0.1","dependencies_parsed_at":null,"dependency_job_id":null,"purl":"pkg:github/canonicalapp/ddp@v3.0.1","tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/canonicalapp%2Fddp/tags/v3.0.1","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/canonicalapp%2Fddp/tags/v3.0.1/manifests"},{"name":"v3.0.0","sha":"f5e234b0222360b461e751c8a0f27476506f59ae","kind":"commit","published_at":"2026-05-08T12:57:08.000Z","download_url":"https://codeload.github.com/canonicalapp/ddp/tar.gz/v3.0.0","html_url":"https://github.com/canonicalapp/ddp/releases/tag/v3.0.0","dependencies_parsed_at":null,"dependency_job_id":null,"purl":"pkg:github/canonicalapp/ddp@v3.0.0","tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/canonicalapp%2Fddp/tags/v3.0.0","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/canonicalapp%2Fddp/tags/v3.0.0/manifests"},{"name":"v2.3.0","sha":"c005dcc7efec0af00761f8ace3f1f1638127139a","kind":"commit","published_at":"2026-05-08T07:16:19.000Z","download_url":"https://codeload.github.com/canonicalapp/ddp/tar.gz/v2.3.0","html_url":"https://github.com/canonicalapp/ddp/releases/tag/v2.3.0","dependencies_parsed_at":null,"dependency_job_id":null,"purl":"pkg:github/canonicalapp/ddp@v2.3.0","tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/canonicalapp%2Fddp/tags/v2.3.0","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/canonicalapp%2Fddp/tags/v2.3.0/manifests"},{"name":"v2.2.2","sha":"3d1fc5357c46ea7af2e8050ef06a7ae88b46d7ac","kind":"commit","published_at":"2026-04-30T06:38:50.000Z","download_url":"https://codeload.github.com/canonicalapp/ddp/tar.gz/v2.2.2","html_url":"https://github.com/canonicalapp/ddp/releases/tag/v2.2.2","dependencies_parsed_at":null,"dependency_job_id":null,"purl":"pkg:github/canonicalapp/ddp@v2.2.2","tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/canonicalapp%2Fddp/tags/v2.2.2","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/canonicalapp%2Fddp/tags/v2.2.2/manifests"},{"name":"v2.2.1","sha":"6992693e1e3ead13b70cde259822421649c4587f","kind":"commit","published_at":"2026-04-30T05:46:36.000Z","download_url":"https://codeload.github.com/canonicalapp/ddp/tar.gz/v2.2.1","html_url":"https://github.com/canonicalapp/ddp/releases/tag/v2.2.1","dependencies_parsed_at":null,"dependency_job_id":null,"purl":"pkg:github/canonicalapp/ddp@v2.2.1","tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/canonicalapp%2Fddp/tags/v2.2.1","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/canonicalapp%2Fddp/tags/v2.2.1/manifests"},{"name":"v2.2.0","sha":"53ec1a7f7284cb191e9fb9b0652de8af15f7d863","kind":"commit","published_at":"2026-04-28T07:37:59.000Z","download_url":"https://codeload.github.com/canonicalapp/ddp/tar.gz/v2.2.0","html_url":"https://github.com/canonicalapp/ddp/releases/tag/v2.2.0","dependencies_parsed_at":null,"dependency_job_id":null,"purl":"pkg:github/canonicalapp/ddp@v2.2.0","tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/canonicalapp%2Fddp/tags/v2.2.0","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/canonicalapp%2Fddp/tags/v2.2.0/manifests"},{"name":"v2.1.2","sha":"ae45492e90f3421e23cb921fa6f47726405d992f","kind":"commit","published_at":"2026-04-27T10:51:41.000Z","download_url":"https://codeload.github.com/canonicalapp/ddp/tar.gz/v2.1.2","html_url":"https://github.com/canonicalapp/ddp/releases/tag/v2.1.2","dependencies_parsed_at":null,"dependency_job_id":null,"purl":"pkg:github/canonicalapp/ddp@v2.1.2","tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/canonicalapp%2Fddp/tags/v2.1.2","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/canonicalapp%2Fddp/tags/v2.1.2/manifests"},{"name":"v2.1.1","sha":"bfea8655d1a0fbf568f496bad4dba9c46347eaee","kind":"commit","published_at":"2026-04-24T09:20:54.000Z","download_url":"https://codeload.github.com/canonicalapp/ddp/tar.gz/v2.1.1","html_url":"https://github.com/canonicalapp/ddp/releases/tag/v2.1.1","dependencies_parsed_at":null,"dependency_job_id":null,"purl":"pkg:github/canonicalapp/ddp@v2.1.1","tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/canonicalapp%2Fddp/tags/v2.1.1","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/canonicalapp%2Fddp/tags/v2.1.1/manifests"},{"name":"v2.1.0","sha":"fcaee9bfba7d25f6f403b17bfaccec46e5f5a1ec","kind":"commit","published_at":"2026-04-24T07:41:01.000Z","download_url":"https://codeload.github.com/canonicalapp/ddp/tar.gz/v2.1.0","html_url":"https://github.com/canonicalapp/ddp/releases/tag/v2.1.0","dependencies_parsed_at":null,"dependency_job_id":null,"purl":"pkg:github/canonicalapp/ddp@v2.1.0","tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/canonicalapp%2Fddp/tags/v2.1.0","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/canonicalapp%2Fddp/tags/v2.1.0/manifests"},{"name":"v2.0.4","sha":"0146db195f7f7b4d105748f92773ab5cb16106fa","kind":"commit","published_at":"2026-04-23T16:39:59.000Z","download_url":"https://codeload.github.com/canonicalapp/ddp/tar.gz/v2.0.4","html_url":"https://github.com/canonicalapp/ddp/releases/tag/v2.0.4","dependencies_parsed_at":null,"dependency_job_id":null,"purl":"pkg:github/canonicalapp/ddp@v2.0.4","tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/canonicalapp%2Fddp/tags/v2.0.4","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/canonicalapp%2Fddp/tags/v2.0.4/manifests"},{"name":"v2.0.3","sha":"8688b413fe5918d062dba05be42e29040bde519a","kind":"commit","published_at":"2026-04-23T16:29:10.000Z","download_url":"https://codeload.github.com/canonicalapp/ddp/tar.gz/v2.0.3","html_url":"https://github.com/canonicalapp/ddp/releases/tag/v2.0.3","dependencies_parsed_at":null,"dependency_job_id":null,"purl":"pkg:github/canonicalapp/ddp@v2.0.3","tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/canonicalapp%2Fddp/tags/v2.0.3","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/canonicalapp%2Fddp/tags/v2.0.3/manifests"},{"name":"v2.0.2","sha":"8506af1c1cb6dfd55774adbe547070526dfa92e1","kind":"commit","published_at":"2026-04-23T13:54:28.000Z","download_url":"https://codeload.github.com/canonicalapp/ddp/tar.gz/v2.0.2","html_url":"https://github.com/canonicalapp/ddp/releases/tag/v2.0.2","dependencies_parsed_at":null,"dependency_job_id":null,"purl":"pkg:github/canonicalapp/ddp@v2.0.2","tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/canonicalapp%2Fddp/tags/v2.0.2","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/canonicalapp%2Fddp/tags/v2.0.2/manifests"},{"name":"v2.0.1","sha":"1553947372a3fa29ba7099394f5035fe6e688e8b","kind":"commit","published_at":"2026-04-23T13:24:46.000Z","download_url":"https://codeload.github.com/canonicalapp/ddp/tar.gz/v2.0.1","html_url":"https://github.com/canonicalapp/ddp/releases/tag/v2.0.1","dependencies_parsed_at":null,"dependency_job_id":null,"purl":"pkg:github/canonicalapp/ddp@v2.0.1","tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/canonicalapp%2Fddp/tags/v2.0.1","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/canonicalapp%2Fddp/tags/v2.0.1/manifests"},{"name":"v2.0.0","sha":"4461716b0ccdccf46c44249f55ceeb6251e9c0b6","kind":"tag","published_at":"2026-04-23T13:24:41.000Z","download_url":"https://codeload.github.com/canonicalapp/ddp/tar.gz/v2.0.0","html_url":"https://github.com/canonicalapp/ddp/releases/tag/v2.0.0","dependencies_parsed_at":null,"dependency_job_id":null,"purl":"pkg:github/canonicalapp/ddp@v2.0.0","tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/canonicalapp%2Fddp/tags/v2.0.0","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/canonicalapp%2Fddp/tags/v2.0.0/manifests"},{"name":"v1.0.0","sha":"a25433aa32e175a7ca1c300ca39126aad4056ef9","kind":"commit","published_at":"2026-04-21T12:16:37.000Z","download_url":"https://codeload.github.com/canonicalapp/ddp/tar.gz/v1.0.0","html_url":"https://github.com/canonicalapp/ddp/releases/tag/v1.0.0","dependencies_parsed_at":null,"dependency_job_id":null,"purl":"pkg:github/canonicalapp/ddp@v1.0.0","tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/canonicalapp%2Fddp/tags/v1.0.0","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/canonicalapp%2Fddp/tags/v1.0.0/manifests"}]},"repo_metadata_updated_at":"2026-08-17T07:39:18.568Z","dependent_packages_count":0,"downloads":201,"downloads_period":"last-month","dependent_repos_count":0,"rankings":{"downloads":null,"dependent_repos_count":23.798543552711305,"dependent_packages_count":34.32976137196853,"stargazers_count":null,"forks_count":null,"docker_downloads_count":null,"average":29.06415246233992},"purl":"pkg:npm/%40advcomm/ddp","advisories":[],"docker_usage_url":"https://docker.ecosyste.ms/usage/npm/@advcomm/ddp","docker_dependents_count":null,"docker_downloads_count":null,"usage_url":"https://repos.ecosyste.ms/usage/npm/@advcomm/ddp","dependent_repositories_url":"https://repos.ecosyste.ms/api/v1/usage/npm/@advcomm/ddp/dependencies","status":null,"funding_links":[],"critical":null,"issue_metadata":{"last_synced_at":"2026-04-21T14:02:57.946Z","issues_count":0,"pull_requests_count":7,"avg_time_to_close_issue":null,"avg_time_to_close_pull_request":16.333333333333332,"issues_closed_count":0,"pull_requests_closed_count":6,"pull_request_authors_count":1,"issue_authors_count":0,"avg_comments_per_issue":null,"avg_comments_per_pull_request":0.0,"merged_pull_requests_count":6,"bot_issues_count":0,"bot_pull_requests_count":0,"past_year_issues_count":0,"past_year_pull_requests_count":7,"past_year_avg_time_to_close_issue":null,"past_year_avg_time_to_close_pull_request":16.333333333333332,"past_year_issues_closed_count":0,"past_year_pull_requests_closed_count":6,"past_year_pull_request_authors_count":1,"past_year_issue_authors_count":0,"past_year_avg_comments_per_issue":null,"past_year_avg_comments_per_pull_request":0.0,"past_year_bot_issues_count":0,"past_year_bot_pull_requests_count":0,"past_year_merged_pull_requests_count":6,"issues_url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/repositories/canonicalapp%2Fddp/issues","maintainers":[{"login":"dev2t","count":7,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/dev2t"}],"active_maintainers":[{"login":"dev2t","count":7,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/dev2t"}]},"versions_url":"https://packages.ecosyste.ms/api/v1/registries/npmjs.org/packages/@advcomm%2Fddp/versions","version_numbers_url":"https://packages.ecosyste.ms/api/v1/registries/npmjs.org/packages/@advcomm%2Fddp/version_numbers","latest_version_url":"https://packages.ecosyste.ms/api/v1/registries/npmjs.org/packages/@advcomm%2Fddp/latest_version","dependent_packages_url":"https://packages.ecosyste.ms/api/v1/registries/npmjs.org/packages/@advcomm%2Fddp/dependent_packages","related_packages_url":"https://packages.ecosyste.ms/api/v1/registries/npmjs.org/packages/@advcomm%2Fddp/related_packages","codemeta_url":"https://packages.ecosyste.ms/api/v1/registries/npmjs.org/packages/@advcomm%2Fddp/codemeta","maintainers":[{"uuid":"dev1-hc","login":"dev1-hc","name":null,"email":"dev1@hostingcontroller.com","url":null,"packages_count":7,"html_url":"https://www.npmjs.com/~dev1-hc","role":null,"created_at":"2025-09-24T11:17:06.379Z","updated_at":"2025-09-24T11:17:06.379Z","packages_url":"https://packages.ecosyste.ms/api/v1/registries/npmjs.org/maintainers/dev1-hc/packages"},{"uuid":"syedhashmi","login":"syedhashmi","name":null,"email":"hashmi@gmail.com","url":null,"packages_count":6,"html_url":"https://www.npmjs.com/~syedhashmi","role":null,"created_at":"2025-09-24T11:17:06.328Z","updated_at":"2025-09-24T11:17:06.328Z","packages_url":"https://packages.ecosyste.ms/api/v1/registries/npmjs.org/maintainers/syedhashmi/packages"},{"uuid":"dev2t","login":"dev2t","name":null,"email":"dev2@advcomm.ca","url":null,"packages_count":4,"html_url":"https://www.npmjs.com/~dev2t","role":null,"created_at":"2025-09-24T11:17:06.426Z","updated_at":"2025-09-24T11:17:06.426Z","packages_url":"https://packages.ecosyste.ms/api/v1/registries/npmjs.org/maintainers/dev2t/packages"}]}