{"package":"graphile-pg-aggregates","ecosystem":"npm","latest_version":"2.17.2","description":"PostGraphile v5 aggregate plugin — sum, avg, min, max, stddev, variance, distinctCount, groupedAggregates with groupBy + having, orderBy relational aggregates","license":"MIT","license_risk":"permissive","commercial_use_notes":"Permissive: commercial closed-source use OK; preserve the copyright notice.","homepage":"https://github.com/constructive-io/constructive","repository":"https://github.com/constructive-io/constructive","downloads_weekly":4089,"health":{"score":73,"risk":"moderate","breakdown":{"maintenance":25,"popularity":6,"security":25,"maturity":15,"community":2},"deprecated":false,"max_score":100},"vulnerabilities":{"count":0,"critical":0,"high":0,"medium":0,"low":0,"details":[]},"versions":{"latest":"2.17.2","total_count":106,"recent":["2.11.9","2.11.10","2.11.11","2.12.0","2.12.1","2.13.0","2.14.0","2.14.1","2.14.2","2.14.3","2.14.4","2.14.5","2.14.6","2.14.7","2.15.0","2.16.0","2.16.1","2.17.0","2.17.1","2.17.2"]},"metadata":{"deprecated":false,"deprecated_message":null,"maintainers_count":1,"first_published":"2026-05-09T00:26:59.547Z","last_published":"2026-09-19T01:39:02.693Z","dependencies_count":1,"dependencies":["graphile-plugin-utils"]},"github_stats":{"stars":53,"forks":7,"open_issues":116,"is_archived":false,"pushed_at":"2026-08-17T08:59:15+00:00"},"bundle":null,"typescript":{"score":10,"has_types":true,"types_source":"bundled","types_package":null},"known_issues":{"bugs_count":0,"bugs_severity":{},"status_breakdown":{},"link":null,"scope":"none"},"historical_compromise":null,"recommendation":{"action":"safe_to_use","issues":[],"use_version":"2.17.2","version_hint":null,"summary":"graphile-pg-aggregates@2.17.2 is safe to use (health: 73/100)"},"version_scoped":null,"_meta":{"endpoint":"check","tier":"full","philosophy":"DepScope is free. Use the cheapest endpoint that answers your real question.","cheaper_alternatives":[{"endpoint":"/api/exists/npm/graphile-pg-aggregates","tokens_estimated":12,"use_when":"you only need to know if the package exists (hallucination guard)"},{"endpoint":"/api/health/npm/graphile-pg-aggregates","tokens_estimated":80,"use_when":"you only need a 0-100 score for go/no-go (>=70 = safe)"},{"endpoint":"/api/prompt/npm/graphile-pg-aggregates","tokens_estimated":280,"use_when":"you want a plain-text LLM-friendly brief instead of JSON"},{"endpoint":"POST /api/check_bulk","tokens_estimated":60,"use_when":"you have 5+ packages to check; sends one round-trip instead of N"}],"docs":"https://depscope.dev/integrate"},"_cache":"hit","_response_ms":0}