{"id":"cmuxjybay1fu8ad077medjzpz","slug":"postgres-patterns","publicId":"db15f7e8-783e-4adc-8754-35386c82d907","name":"postgres-patterns","description":"쿼리 최적화, 스키마 설계, 인덱싱, 보안을 위한 PostgreSQL 데이터베이스 패턴. Supabase 모범 사례 기반.","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/docs/ko-KR/skills/postgres-patterns","createdAt":"2026-10-07T03:32:57.569Z","completedAt":"2026-10-07T03:32:57.567Z","visibility":"public","publishedAt":"2026-08-06T17:11:24.797Z","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":"cmuxjybaz1fu9ad07sdqxkvwn","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-21T16:25:41.064Z","lastVerifiedAt":"2026-10-21T16:25:41.064Z","lastChangeDetectedAt":"2026-08-25T12:22:05.093Z","scannedHash":"fb8a2e436022675edd0d5a7c5c4179b2fcf41671","latestUpstreamHash":"fb8a2e436022675edd0d5a7c5c4179b2fcf41671","nextCheckDueAt":"2026-10-22T15:56:53.538Z"},"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":1210,"unit":null,"method":"tiktoken/cl100k_base/skill-md-body"}]},"rows":[{"origin":"signal","id":"cmuxjybj71fw6ad07pt3s8ny9","subjectType":"skill_audit","subjectId":"cmuxjybay1fu8ad077medjzpz","relatedType":"","relatedId":"","dataCategory":"performance","sourceClass":"scan","source":"vettd","ruleId":"performance/static-context-tokens","severity":null,"label":"Static context tokens","detail":null,"valueNum":1210,"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:32:54.000Z","payload":null},{"origin":"signal","id":"cmuxjyc8d1g1kad07b0yv14dr","subjectType":"skill_audit","subjectId":"cmuxjybay1fu8ad077medjzpz","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:32:54.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":"cmuxjybjr1fwpad07e3y9rk2f","subjectType":"skill_audit","subjectId":"cmuxjybay1fu8ad077medjzpz","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:32:54.000Z","payload":null},{"origin":"signal","id":"cmuxjybvb1fzjad07sbk4vo9m","subjectType":"skill_audit","subjectId":"cmuxjybay1fu8ad077medjzpz","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:32:54.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"]}