{"id":"cmuxjzu4f1hiiad07v84awm5l","slug":"postgres-patterns","publicId":"7be2453f-4216-4f6f-8ad2-a935ef28e4fc","name":"postgres-patterns","description":">","version":"","author":"affaan-m","license":"MIT","compatibility":"","status":"completed","overallGrade":"A","scannerVersion":11,"fileCount":1,"hasSkillMd":true,"hasScripts":false,"hasReferences":false,"hasEvals":false,"hasAssets":false,"sourceType":"github","sourceUrl":"https://github.com/affaan-m/ecc/tree/main/.kiro/skills/postgres-patterns","createdAt":"2026-10-07T03:34:08.086Z","completedAt":"2026-10-07T03:34:08.082Z","visibility":"public","publishedAt":"2026-08-06T17:11:21.814Z","category":"","frameworks":[],"badgeStatus":"vettd","downloadCount":0,"verdictRationale":{"summary":"Skill failed: 0 hard fails in skill checks.","verdict":"fail","scanners":[{"source":"vettd","weight":1,"verdict":null},{"source":"cisco","weight":0.8,"verdict":"pass"}],"consensus":"pending","warnTriggers":[],"policyVersion":"consensus-v1","hardFailTriggers":[]},"verdictPolicyVersion":"consensus-v1","skillId":"cmshrvyz504qnad07ac741due","findings":[{"id":"cmuxjzu4f1hikad07xfpqb3qw","source":"cisco","category":"security","label":"Skill does not specify a license","detail":"SKILL.md — Skill manifest does not include a 'license' field. Specifying a license helps users understand usage terms.","severity":"info","ruleId":"MANIFEST_MISSING_LICENSE","owaspLlmCategory":null,"intent":null,"chainId":null,"fingerprint":"592f7ac7731768f0fd0bba83f30850f9","filepath":"SKILL.md"}],"scannerRuns":[{"source":"cisco","status":"success","verdict":null,"grade":"A","findingCount":1,"criticalCount":0,"highCount":0},{"source":"vettd","status":"success","verdict":null,"grade":"A","findingCount":0,"criticalCount":0,"highCount":0}],"user":{"name":"Justin Pacella","image":"https://avatars.githubusercontent.com/u/97124458?v=4"},"repository":{"owner":"affaan-m","name":"ecc"},"freshness":{"status":"verified_unchanged","reason":null,"retryable":false,"renamedTo":null,"lastCheckedAt":"2026-10-21T23:34:06.878Z","lastVerifiedAt":"2026-10-21T23:34:06.878Z","lastChangeDetectedAt":"2026-08-25T20:30:27.920Z","scannedHash":"7ecd3fefc556d40ad2283aaa890dd9afb120089a","latestUpstreamHash":"7ecd3fefc556d40ad2283aaa890dd9afb120089a","nextCheckDueAt":"2026-10-22T22:07:02.004Z"},"signalCategories":[{"category":"safety","label":"Safety","form":"graded","verdict":null,"rows":[]},{"category":"reliability","label":"Reliability & Quality","form":"graded","verdict":null,"rows":[]},{"category":"performance","label":"Performance","form":"measured","verdict":{"form":"measured","magnitudes":[{"ruleId":"performance/static-context-tokens","label":"Static context tokens","value":1023,"unit":null,"method":"tiktoken/cl100k_base/skill-md-body"}]},"rows":[{"origin":"signal","id":"cmuxjzv6q1howad07v2cbcd3o","subjectType":"skill_audit","subjectId":"cmuxjzu4f1hiiad07v84awm5l","relatedType":"","relatedId":"","dataCategory":"performance","sourceClass":"scan","source":"vettd","ruleId":"performance/static-context-tokens","severity":null,"label":"Static context tokens","detail":null,"valueNum":1023,"valueText":null,"unit":null,"method":"tiktoken/cl100k_base/skill-md-body","derivation":null,"confidence":null,"sampleSize":null,"synthetic":false,"firstParty":true,"observedAt":"2026-10-07T03:34:02.000Z","payload":null},{"origin":"signal","id":"cmuxk00kv1ipwad07422jkoze","subjectType":"skill_audit","subjectId":"cmuxjzu4f1hiiad07v84awm5l","relatedType":"","relatedId":"","dataCategory":"performance","sourceClass":"scan","source":"vettd","ruleId":"performance/progressive-disclosure","severity":null,"label":"Progressive disclosure","detail":null,"valueNum":null,"valueText":"absent","unit":null,"method":null,"derivation":"read","confidence":null,"sampleSize":null,"synthetic":false,"firstParty":true,"observedAt":"2026-10-07T03:34:02.000Z","payload":null}]},{"category":"cost","label":"Cost","form":"measured","verdict":null,"rows":[]},{"category":"compatibility","label":"Compatibility","form":"unjudged","verdict":{"form":"unjudged"},"rows":[{"origin":"signal","id":"cmuxjzvhm1hr7ad07m9q8s6iv","subjectType":"skill_audit","subjectId":"cmuxjzu4f1hiiad07v84awm5l","relatedType":"","relatedId":"","dataCategory":"compatibility","sourceClass":"scan","source":"vettd","ruleId":"compatibility/declared-environment-assumptions","severity":null,"label":"Declared environment assumptions","detail":null,"valueNum":null,"valueText":"","unit":null,"method":null,"derivation":"read","confidence":null,"sampleSize":null,"synthetic":false,"firstParty":true,"observedAt":"2026-10-07T03:34:02.000Z","payload":null},{"origin":"signal","id":"cmuxjzxes1i6uad07nbndsvlu","subjectType":"skill_audit","subjectId":"cmuxjzu4f1hiiad07v84awm5l","relatedType":"","relatedId":"","dataCategory":"compatibility","sourceClass":"scan","source":"vettd","ruleId":"compatibility/declared-name","severity":null,"label":"Declared skill name","detail":null,"valueNum":null,"valueText":"postgres-patterns","unit":null,"method":null,"derivation":"read","confidence":null,"sampleSize":null,"synthetic":false,"firstParty":true,"observedAt":"2026-10-07T03:34:02.000Z","payload":null}]},{"category":"sentiment","label":"Popularity","form":"unjudged","verdict":null,"rows":[]},{"category":"characteristics","label":"Characteristics","form":"unjudged","verdict":null,"rows":[]}],"signalCount":24,"publisherSupplied":["name","description","author","version","license"]}