{"package":"piccolo","ecosystem":"pypi","latest_version":"1.35.0","description":"A fast, user friendly ORM and query builder which supports asyncio.","license":"MIT","license_risk":"permissive","commercial_use_notes":"Permissive: commercial closed-source use OK; preserve the copyright notice.","homepage":"https://github.com/piccolo-orm/piccolo","repository":"https://github.com/piccolo-orm/piccolo","downloads_weekly":0,"health":{"score":67,"risk":"moderate","breakdown":{"maintenance":25,"popularity":0,"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":"1.35.0","total_count":294,"recent":["1.20.0","1.21.0","1.22.0","1.23.0","1.24.0","1.24.1","1.24.2","1.25.0","1.26.0","1.26.1","1.27.0","1.27.1","1.28.0","1.29.0","1.30.0","1.31.0","1.32.0","1.33.0","1.34.0","1.35.0"]},"metadata":{"deprecated":false,"deprecated_message":null,"maintainers_count":1,"first_published":null,"last_published":"2026-07-01T22:24:02.525051Z","dependencies_count":17,"dependencies":["black","colorama>=0.4.0","Jinja2>=2.11.0","targ>=0.3.7","inflection>=0.5.1","typing-extensions>=4.3.0","pydantic[email]==2.*","orjson>=3.5.1; extra == \"orjson\"","ipython; extra == \"playground\"","asyncpg>=0.30.0; extra == \"postgres\"","aiosqlite>=0.16.0; extra == \"sqlite\"","uvloop>=0.12.0; sys_platform != \"win32\" and extra == \"uvloop\"","orjson>=3.5.1; extra == \"all\"","ipython; extra == \"all\"","asyncpg>=0.30.0; extra == \"all\"","aiosqlite>=0.16.0; extra == \"all\"","uvloop>=0.12.0; sys_platform != \"win32\" and extra == \"all\""]},"github_stats":null,"bundle":null,"typescript":null,"known_issues":{"bugs_count":0,"bugs_severity":{},"status_breakdown":{},"link":null,"scope":"none"},"historical_compromise":null,"recommendation":{"action":"use_with_caution","issues":["Moderate health score (67/100) — verify manually"],"use_version":"1.35.0","version_hint":null,"summary":"piccolo@1.35.0 low health (67/100) — consider alternatives"},"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/pypi/piccolo","tokens_estimated":12,"use_when":"you only need to know if the package exists (hallucination guard)"},{"endpoint":"/api/health/pypi/piccolo","tokens_estimated":80,"use_when":"you only need a 0-100 score for go/no-go (>=70 = safe)"},{"endpoint":"/api/prompt/pypi/piccolo","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","hint_bulk":"You've called /api/check 48 times in 60s. Save bandwidth + tokens with POST /api/check_bulk (1 round-trip for N pkgs)."},"requested_version":null,"_cache":"hit","_response_ms":0,"_powered_by":"depscope.dev — free package intelligence for AI agents","typosquat":{"is_suspected":false},"maintainer_trust":{"available":false},"malicious":{"is_malicious":false},"scorecard":{"available":false},"quality":{"available":false},"version_history_summary":{"total_versions":20,"first_release_age_days":null,"last_release_days_ago":14,"avg_days_between_releases":null,"release_velocity":"active"}}