postgresql-code-review

CID baeareignultwwhjwpsfoiku6oqr7fgzyvlgp7c63i63cebyhkv265equoy
vv1.0.0 OASF 1.1.0 Not signed

Security

CID matches content
Yes
Signed
No
0 signature(s)
Trusted (signature verified)
No
pull signatures: pull referrer baeareihlhgtvtskaxzf73b3nbu44o3vie67lc5wmn4vch6eb26pldgcdwi: empty referrer baeareihlhgtvtskaxzf73b3nbu44o3vie67lc5wmn4vch6eb26pldgcdwi
OASF record valid
Yes

Record

Authors
GitHub
Created
2026-08-19T06:47:24Z
Pulled
1 day, 1 hour ago
Modules
core/language_model/agentskills
Raw OASF record (JSON)
{
  "authors": [
    "GitHub"
  ],
  "created_at": "2026-08-19T06:47:24Z",
  "description": "PostgreSQL-specific code review assistant focusing on PostgreSQL best practices, anti-patterns, and unique quality standards. Covers JSONB operations, array usage, custom types, schema design, function optimization, and PostgreSQL-exclusive security features like Row Level Security (RLS).",
  "domains": [
    {
      "id": 1901,
      "name": "research_and_development/grant_management"
    },
    {
      "id": 10603,
      "name": "technology/information_technology/database_administration"
    },
    {
      "id": 107,
      "name": "technology/security"
    },
    {
      "id": 1905,
      "name": "research_and_development/research_data_management"
    }
  ],
  "modules": [
    {
      "artifact": {
        "data": "LS0tCm5hbWU6IHBvc3RncmVzcWwtY29kZS1yZXZpZXcKZGVzY3JpcHRpb246ICdQb3N0Z3JlU1FMLXNwZWNpZmljIGNvZGUgcmV2aWV3IGFzc2lzdGFudCBmb2N1c2luZyBvbiBQb3N0Z3JlU1FMIGJlc3QgcHJhY3RpY2VzLCBhbnRpLXBhdHRlcm5zLCBhbmQgdW5pcXVlIHF1YWxpdHkgc3RhbmRhcmRzLiBDb3ZlcnMgSlNPTkIgb3BlcmF0aW9ucywgYXJyYXkgdXNhZ2UsIGN1c3RvbSB0eXBlcywgc2NoZW1hIGRlc2lnbiwgZnVuY3Rpb24gb3B0aW1pemF0aW9uLCBhbmQgUG9zdGdyZVNRTC1leGNsdXNpdmUgc2VjdXJpdHkgZmVhdHVyZXMgbGlrZSBSb3cgTGV2ZWwgU2VjdXJpdHkgKFJMUykuJwotLS0KCiMgUG9zdGdyZVNRTCBDb2RlIFJldmlldyBBc3Npc3RhbnQKCkV4cGVydCBQb3N0Z3JlU1FMIGNvZGUgcmV2aWV3IGZvciAke3NlbGVjdGlvbn0gKG9yIGVudGlyZSBwcm9qZWN0IGlmIG5vIHNlbGVjdGlvbikuIEZvY3VzIG9uIFBvc3RncmVTUUwtc3BlY2lmaWMgYmVzdCBwcmFjdGljZXMsIGFudGktcGF0dGVybnMsIGFuZCBxdWFsaXR5IHN0YW5kYXJkcyB0aGF0IGFyZSB1bmlxdWUgdG8gUG9zdGdyZVNRTC4KCiMjIPCfjq8gUG9zdGdyZVNRTC1TcGVjaWZpYyBSZXZpZXcgQXJlYXMKCiMjIyBKU09OQiBCZXN0IFByYWN0aWNlcwpgYGBzcWwKLS0g4p2MIEJBRDogSW5lZmZpY2llbnQgSlNPTkIgdXNhZ2UKU0VMRUNUICogRlJPTSBvcmRlcnMgV0hFUkUgZGF0YS0+PidzdGF0dXMnID0gJ3NoaXBwZWQnOyAgLS0gTm8gaW5kZXggc3VwcG9ydAoKLS0g4pyFIEdPT0Q6IEluZGV4YWJsZSBKU09OQiBxdWVyaWVzCkNSRUFURSBJTkRFWCBpZHhfb3JkZXJzX3N0YXR1cyBPTiBvcmRlcnMgVVNJTkcgZ2luKChkYXRhLT4nc3RhdHVzJykpOwpTRUxFQ1QgKiBGUk9NIG9yZGVycyBXSEVSRSBkYXRhIEA+ICd7InN0YXR1cyI6ICJzaGlwcGVkIn0nOwoKLS0g4p2MIEJBRDogRGVlcCBuZXN0aW5nIHdpdGhvdXQgY29uc2lkZXJhdGlvbgpVUERBVEUgb3JkZXJzIFNFVCBkYXRhID0gZGF0YSB8fCAneyJzaGlwcGluZyI6eyJ0cmFja2luZyI6eyJudW1iZXIiOiIxMjMifX19JzsKCi0tIOKchSBHT09EOiBTdHJ1Y3R1cmVkIEpTT05CIHdpdGggdmFsaWRhdGlvbgpBTFRFUiBUQUJMRSBvcmRlcnMgQUREIENPTlNUUkFJTlQgdmFsaWRfc3RhdHVzIApDSEVDSyAoZGF0YS0+PidzdGF0dXMnIElOICgncGVuZGluZycsICdzaGlwcGVkJywgJ2RlbGl2ZXJlZCcpKTsKYGBgCgojIyMgQXJyYXkgT3BlcmF0aW9ucyBSZXZpZXcKYGBgc3FsCi0tIOKdjCBCQUQ6IEluZWZmaWNpZW50IGFycmF5IG9wZXJhdGlvbnMKU0VMRUNUICogRlJPTSBwcm9kdWN0cyBXSEVSRSAnZWxlY3Ryb25pY3MnID0gQU5ZKGNhdGVnb3JpZXMpOyAgLS0gTm8gaW5kZXgKCi0tIOKchSBHT09EOiBHSU4gaW5kZXhlZCBhcnJheSBxdWVyaWVzCkNSRUFURSBJTkRFWCBpZHhfcHJvZHVjdHNfY2F0ZWdvcmllcyBPTiBwcm9kdWN0cyBVU0lORyBnaW4oY2F0ZWdvcmllcyk7ClNFTEVDVCAqIEZST00gcHJvZHVjdHMgV0hFUkUgY2F0ZWdvcmllcyBAPiBBUlJBWVsnZWxlY3Ryb25pY3MnXTsKCi0tIOKdjCBCQUQ6IEFycmF5IGNvbmNhdGVuYXRpb24gaW4gbG9vcHMKLS0gVGhpcyB3b3VsZCBiZSBpbmVmZmljaWVudCBpbiBhIGZ1bmN0aW9uL3Byb2NlZHVyZQoKLS0g4pyFIEdPT0Q6IEJ1bGsgYXJyYXkgb3BlcmF0aW9ucwpVUERBVEUgcHJvZHVjdHMgU0VUIGNhdGVnb3JpZXMgPSBjYXRlZ29yaWVzIHx8IEFSUkFZWyduZXdfY2F0ZWdvcnknXQpXSEVSRSBpZCBJTiAoU0VMRUNUIGlkIEZST00gcHJvZHVjdHMgV0hFUkUgY29uZGl0aW9uKTsKYGBgCgojIyMgUG9zdGdyZVNRTCBTY2hlbWEgRGVzaWduIFJldmlldwpgYGBzcWwKLS0g4p2MIEJBRDogTm90IHVzaW5nIFBvc3RncmVTUUwgZmVhdHVyZXMKQ1JFQVRFIFRBQkxFIHVzZXJzICgKICAgIGlkIElOVEVHRVIsCiAgICBlbWFpbCBWQVJDSEFSKDI1NSksCiAgICBjcmVhdGVkX2F0IFRJTUVTVEFNUAopOwoKLS0g4pyFIEdPT0Q6IFBvc3RncmVTUUwtb3B0aW1pemVkIHNjaGVtYQpDUkVBVEUgVEFCTEUgdXNlcnMgKAogICAgaWQgQklHU0VSSUFMIFBSSU1BUlkgS0VZLAogICAgZW1haWwgQ0lURVhUIFVOSVFVRSBOT1QgTlVMTCwgIC0tIENhc2UtaW5zZW5zaXRpdmUgZW1haWwKICAgIGNyZWF0ZWRfYXQgVElNRVNUQU1QVFogREVGQVVMVCBOT1coKSwKICAgIG1ldGFkYXRhIEpTT05CIERFRkFVTFQgJ3t9JywKICAgIENPTlNUUkFJTlQgdmFsaWRfZW1haWwgQ0hFQ0sgKGVtYWlsIH4qICdeW0EtWmEtejAtOS5fJSstXStAW0EtWmEtejAtOS4tXStcLltBLVphLXpdezIsfSQnKQopOwoKLS0gQWRkIEpTT05CIEdJTiBpbmRleCBmb3IgbWV0YWRhdGEgcXVlcmllcwpDUkVBVEUgSU5ERVggaWR4X3VzZXJzX21ldGFkYXRhIE9OIHVzZXJzIFVTSU5HIGdpbihtZXRhZGF0YSk7CmBgYAoKIyMjIEN1c3RvbSBUeXBlcyBhbmQgRG9tYWlucwpgYGBzcWwKLS0g4p2MIEJBRDogVXNpbmcgZ2VuZXJpYyB0eXBlcyBmb3Igc3BlY2lmaWMgZGF0YQpDUkVBVEUgVEFCTEUgdHJhbnNhY3Rpb25zICgKICAgIGFtb3VudCBERUNJTUFMKDEwLDIpLAogICAgY3VycmVuY3kgVkFSQ0hBUigzKSwKICAgIHN0YXR1cyBWQVJDSEFSKDIwKQopOwoKLS0g4pyFIEdPT0Q6IFBvc3RncmVTUUwgY3VzdG9tIHR5cGVzCkNSRUFURSBUWVBFIGN1cnJlbmN5X2NvZGUgQVMgRU5VTSAoJ1VTRCcsICdFVVInLCAnR0JQJywgJ0pQWScpOwpDUkVBVEUgVFlQRSB0cmFuc2FjdGlvbl9zdGF0dXMgQVMgRU5VTSAoJ3BlbmRpbmcnLCAnY29tcGxldGVkJywgJ2ZhaWxlZCcsICdjYW5jZWxsZWQnKTsKQ1JFQVRFIERPTUFJTiBwb3NpdGl2ZV9hbW91bnQgQVMgREVDSU1BTCgxMCwyKSBDSEVDSyAoVkFMVUUgPiAwKTsKCkNSRUFURSBUQUJMRSB0cmFuc2FjdGlvbnMgKAogICAgYW1vdW50IHBvc2l0aXZlX2Ftb3VudCBOT1QgTlVMTCwKICAgIGN1cnJlbmN5IGN1cnJlbmN5X2NvZGUgTk9UIE5VTEwsCiAgICBzdGF0dXMgdHJhbnNhY3Rpb25fc3RhdHVzIERFRkFVTFQgJ3BlbmRpbmcnCik7CmBgYAoKIyMg8J+UjSBQb3N0Z3JlU1FMLVNwZWNpZmljIEFudGktUGF0dGVybnMKCiMjIyBQZXJmb3JtYW5jZSBBbnRpLVBhdHRlcm5zCi0gKipBdm9pZGluZyBQb3N0Z3JlU1FMLXNwZWNpZmljIGluZGV4ZXMqKjogTm90IHVzaW5nIEdJTi9HaVNUIGZvciBhcHByb3ByaWF0ZSBkYXRhIHR5cGVzCi0gKipNaXN1c2luZyBKU09OQioqOiBUcmVhdGluZyBKU09OQiBsaWtlIGEgc2ltcGxlIHN0cmluZyBmaWVsZAotICoqSWdub3JpbmcgYXJyYXkgb3BlcmF0b3JzKio6IFVzaW5nIGluZWZmaWNpZW50IGFycmF5IG9wZXJhdGlvbnMKLSAqKlBvb3IgcGFydGl0aW9uIGtleSBzZWxlY3Rpb24qKjogTm90IGxldmVyYWdpbmcgUG9zdGdyZVNRTCBwYXJ0aXRpb25pbmcgZWZmZWN0aXZlbHkKCiMjIyBTY2hlbWEgRGVzaWduIElzc3VlcwotICoqTm90IHVzaW5nIEVOVU0gdHlwZXMqKjogVXNpbmcgVkFSQ0hBUiBmb3IgbGltaXRlZCB2YWx1ZSBzZXRzCi0gKipJZ25vcmluZyBjb25zdHJhaW50cyoqOiBNaXNzaW5nIENIRUNLIGNvbnN0cmFpbnRzIGZvciBkYXRhIHZhbGlkYXRpb24KLSAqKldyb25nIGRhdGEgdHlwZXMqKjogVXNpbmcgVkFSQ0hBUiBpbnN0ZWFkIG9mIFRFWFQgb3IgQ0lURVhUCi0gKipNaXNzaW5nIEpTT05CIHN0cnVjdHVyZSoqOiBVbnN0cnVjdHVyZWQgSlNPTkIgd2l0aG91dCB2YWxpZGF0aW9uCgojIyMgRnVuY3Rpb24gYW5kIFRyaWdnZXIgSXNzdWVzCmBgYHNxbAotLSDinYwgQkFEOiBJbmVmZmljaWVudCB0cmlnZ2VyIGZ1bmN0aW9uCkNSRUFURSBPUiBSRVBMQUNFIEZVTkNUSU9OIHVwZGF0ZV9tb2RpZmllZF90aW1lKCkKUkVUVVJOUyBUUklHR0VSIEFTICQkCkJFR0lOCiAgICBORVcudXBkYXRlZF9hdCA9IE5PVygpOyAgLS0gU2hvdWxkIHVzZSBUSU1FU1RBTVBUWgogICAgUkVUVVJOIE5FVzsKRU5EOwokJCBMQU5HVUFHRSBwbHBnc3FsOwoKLS0g4pyFIEdPT0Q6IE9wdGltaXplZCB0cmlnZ2VyIGZ1bmN0aW9uCkNSRUFURSBPUiBSRVBMQUNFIEZVTkNUSU9OIHVwZGF0ZV9tb2RpZmllZF90aW1lKCkKUkVUVVJOUyBUUklHR0VSIEFTICQkCkJFR0lOCiAgICBORVcudXBkYXRlZF9hdCA9IENVUlJFTlRfVElNRVNUQU1QOwogICAgUkVUVVJOIE5FVzsKRU5EOwokJCBMQU5HVUFHRSBwbHBnc3FsOwoKLS0gU2V0IHRyaWdnZXIgdG8gZmlyZSBvbmx5IHdoZW4gbmVlZGVkCkNSRUFURSBUUklHR0VSIHVwZGF0ZV9tb2RpZmllZF90aW1lX3RyaWdnZXIKICAgIEJFRk9SRSBVUERBVEUgT04gdGFibGVfbmFtZQogICAgRk9SIEVBQ0ggUk9XCiAgICBXSEVOIChPTEQuKiBJUyBESVNUSU5DVCBGUk9NIE5FVy4qKQogICAgRVhFQ1VURSBGVU5DVElPTiB1cGRhdGVfbW9kaWZpZWRfdGltZSgpOwpgYGAKCiMjIPCfk4ogUG9zdGdyZVNRTCBFeHRlbnNpb24gVXNhZ2UgUmV2aWV3CgojIyMgRXh0ZW5zaW9uIEJlc3QgUHJhY3RpY2VzCmBgYHNxbAotLSDinIUgQ2hlY2sgaWYgZXh0ZW5zaW9uIGV4aXN0cyBiZWZvcmUgY3JlYXRpbmcKQ1JFQVRFIEVYVEVOU0lPTiBJRiBOT1QgRVhJU1RTICJ1dWlkLW9zc3AiOwpDUkVBVEUgRVhURU5TSU9OIElGIE5PVCBFWElTVFMgInBnY3J5cHRvIjsKQ1JFQVRFIEVYVEVOU0lPTiBJRiBOT1QgRVhJU1RTICJwZ190cmdtIjsKCi0tIOKchSBVc2UgZXh0ZW5zaW9ucyBhcHByb3ByaWF0ZWx5Ci0tIFVVSUQgZ2VuZXJhdGlvbgpTRUxFQ1QgdXVpZF9nZW5lcmF0ZV92NCgpOwoKLS0gUGFzc3dvcmQgaGFzaGluZwpTRUxFQ1QgY3J5cHQoJ3Bhc3N3b3JkJywgZ2VuX3NhbHQoJ2JmJykpOwoKLS0gRnV6enkgdGV4dCBtYXRjaGluZwpTRUxFQ1Qgd29yZF9zaW1pbGFyaXR5KCdwb3N0Z3JlcycsICdwb3N0Z3JlJyk7CmBgYAoKIyMg8J+boe+4jyBQb3N0Z3JlU1FMIFNlY3VyaXR5IFJldmlldwoKIyMjIFJvdyBMZXZlbCBTZWN1cml0eSAoUkxTKQpgYGBzcWwKLS0g4pyFIEdPT0Q6IEltcGxlbWVudGluZyBSTFMKQUxURVIgVEFCTEUgc2Vuc2l0aXZlX2RhdGEgRU5BQkxFIFJPVyBMRVZFTCBTRUNVUklUWTsKCkNSRUFURSBQT0xJQ1kgdXNlcl9kYXRhX3BvbGljeSBPTiBzZW5zaXRpdmVfZGF0YQogICAgRk9SIEFMTCBUTyBhcHBsaWNhdGlvbl9yb2xlCiAgICBVU0lORyAodXNlcl9pZCA9IGN1cnJlbnRfc2V0dGluZygnYXBwLmN1cnJlbnRfdXNlcl9pZCcpOjpJTlRFR0VSKTsKYGBgCgojIyMgUHJpdmlsZWdlIE1hbmFnZW1lbnQKYGBgc3FsCi0tIOKdjCBCQUQ6IE92ZXJseSBicm9hZCBwZXJtaXNzaW9ucwpHUkFOVCBBTEwgUFJJVklMRUdFUyBPTiBBTEwgVEFCTEVTIElOIFNDSEVNQSBwdWJsaWMgVE8gYXBwX3VzZXI7CgotLSDinIUgR09PRDogR3JhbnVsYXIgcGVybWlzc2lvbnMKR1JBTlQgU0VMRUNULCBJTlNFUlQsIFVQREFURSBPTiBzcGVjaWZpY190YWJsZSBUTyBhcHBfdXNlcjsKR1JBTlQgVVNBR0UgT04gU0VRVUVOQ0Ugc3BlY2lmaWNfdGFibGVfaWRfc2VxIFRPIGFwcF91c2VyOwpgYGAKCiMjIPCfjq8gUG9zdGdyZVNRTCBDb2RlIFF1YWxpdHkgQ2hlY2tsaXN0CgojIyMgU2NoZW1hIERlc2lnbgotIFsgXSBVc2luZyBhcHByb3ByaWF0ZSBQb3N0Z3JlU1FMIGRhdGEgdHlwZXMgKENJVEVYVCwgSlNPTkIsIGFycmF5cykKLSBbIF0gTGV2ZXJhZ2luZyBFTlVNIHR5cGVzIGZvciBjb25zdHJhaW5lZCB2YWx1ZXMKLSBbIF0gSW1wbGVtZW50aW5nIHByb3BlciBDSEVDSyBjb25zdHJhaW50cwotIFsgXSBVc2luZyBUSU1FU1RBTVBUWiBpbnN0ZWFkIG9mIFRJTUVTVEFNUAotIFsgXSBEZWZpbmluZyBjdXN0b20gZG9tYWlucyBmb3IgcmV1c2FibGUgY29uc3RyYWludHMKCiMjIyBQZXJmb3JtYW5jZSBDb25zaWRlcmF0aW9ucwotIFsgXSBBcHByb3ByaWF0ZSBpbmRleCB0eXBlcyAoR0lOIGZvciBKU09OQi9hcnJheXMsIEdpU1QgZm9yIHJhbmdlcykKLSBbIF0gSlNPTkIgcXVlcmllcyB1c2luZyBjb250YWlubWVudCBvcGVyYXRvcnMgKEA+LCA/KQotIFsgXSBBcnJheSBvcGVyYXRpb25zIHVzaW5nIFBvc3RncmVTUUwtc3BlY2lmaWMgb3BlcmF0b3JzCi0gWyBdIFByb3BlciB1c2Ugb2Ygd2luZG93IGZ1bmN0aW9ucyBhbmQgQ1RFcwotIFsgXSBFZmZpY2llbnQgdXNlIG9mIFBvc3RncmVTUUwtc3BlY2lmaWMgZnVuY3Rpb25zCgojIyMgUG9zdGdyZVNRTCBGZWF0dXJlcyBVdGlsaXphdGlvbgotIFsgXSBVc2luZyBleHRlbnNpb25zIHdoZXJlIGFwcHJvcHJpYXRlCi0gWyBdIEltcGxlbWVudGluZyBzdG9yZWQgcHJvY2VkdXJlcyBpbiBQTC9wZ1NRTCB3aGVuIGJlbmVmaWNpYWwKLSBbIF0gTGV2ZXJhZ2luZyBQb3N0Z3JlU1FMJ3MgYWR2YW5jZWQgU1FMIGZlYXR1cmVzCi0gWyBdIFVzaW5nIFBvc3RncmVTUUwtc3BlY2lmaWMgb3B0aW1pemF0aW9uIHRlY2huaXF1ZXMKLSBbIF0gSW1wbGVtZW50aW5nIHByb3BlciBlcnJvciBoYW5kbGluZyBpbiBmdW5jdGlvbnMKCiMjIyBTZWN1cml0eSBhbmQgQ29tcGxpYW5jZQotIFsgXSBSb3cgTGV2ZWwgU2VjdXJpdHkgKFJMUykgaW1wbGVtZW50YXRpb24gd2hlcmUgbmVlZGVkCi0gWyBdIFByb3BlciByb2xlIGFuZCBwcml2aWxlZ2UgbWFuYWdlbWVudAotIFsgXSBVc2luZyBQb3N0Z3JlU1FMJ3MgYnVpbHQtaW4gZW5jcnlwdGlvbiBmdW5jdGlvbnMKLSBbIF0gSW1wbGVtZW50aW5nIGF1ZGl0IHRyYWlscyB3aXRoIFBvc3RncmVTUUwgZmVhdHVyZXMKCiMjIPCfk50gUG9zdGdyZVNRTC1TcGVjaWZpYyBSZXZpZXcgR3VpZGVsaW5lcwoKMS4gKipEYXRhIFR5cGUgT3B0aW1pemF0aW9uKio6IEVuc3VyZSBQb3N0Z3JlU1FMLXNwZWNpZmljIHR5cGVzIGFyZSB1c2VkIGFwcHJvcHJpYXRlbHkKMi4gKipJbmRleCBTdHJhdGVneSoqOiBSZXZpZXcgaW5kZXggdHlwZXMgYW5kIGVuc3VyZSBQb3N0Z3JlU1FMLXNwZWNpZmljIGluZGV4ZXMgYXJlIHV0aWxpemVkCjMuICoqSlNPTkIgU3RydWN0dXJlKio6IFZhbGlkYXRlIEpTT05CIHNjaGVtYSBkZXNpZ24gYW5kIHF1ZXJ5IHBhdHRlcm5zCjQuICoqRnVuY3Rpb24gUXVhbGl0eSoqOiBSZXZpZXcgUEwvcGdTUUwgZnVuY3Rpb25zIGZvciBlZmZpY2llbmN5IGFuZCBiZXN0IHByYWN0aWNlcwo1LiAqKkV4dGVuc2lvbiBVc2FnZSoqOiBWZXJpZnkgYXBwcm9wcmlhdGUgdXNlIG9mIFBvc3RncmVTUUwgZXh0ZW5zaW9ucwo2LiAqKlBlcmZvcm1hbmNlIEZlYXR1cmVzKio6IENoZWNrIHV0aWxpemF0aW9uIG9mIFBvc3RncmVTUUwncyBhZHZhbmNlZCBmZWF0dXJlcwo3LiAqKlNlY3VyaXR5IEltcGxlbWVudGF0aW9uKio6IFJldmlldyBQb3N0Z3JlU1FMLXNwZWNpZmljIHNlY3VyaXR5IGZlYXR1cmVzCgpGb2N1cyBvbiBQb3N0Z3JlU1FMJ3MgdW5pcXVlIGNhcGFiaWxpdGllcyBhbmQgZW5zdXJlIHRoZSBjb2RlIGxldmVyYWdlcyB3aGF0IG1ha2VzIFBvc3RncmVTUUwgc3BlY2lhbCByYXRoZXIgdGhhbiB0cmVhdGluZyBpdCBhcyBhIGdlbmVyaWMgU1FMIGRhdGFiYXNlLgo=",
        "digest": "sha256:5c2f68120440692ae4b030b17e2a3553c1204d63ee871d6d994c6925b1f874cb",
        "media_type": "application/agent-skills+md",
        "size": 7439
      },
      "data": {
        "skill_file": "SKILL.md",
        "skill_manifest": {
          "description": "PostgreSQL-specific code review assistant focusing on PostgreSQL best practices, anti-patterns, and unique quality standards. Covers JSONB operations, array usage, custom types, schema design, function optimization, and PostgreSQL-exclusive security features like Row Level Security (RLS).",
          "name": "postgresql-code-review",
          "version": "v1.0.0"
        }
      },
      "id": 10302,
      "name": "core/language_model/agentskills"
    }
  ],
  "name": "postgresql-code-review",
  "schema_version": "1.1.0",
  "skills": [
    {
      "id": 80201,
      "name": "data_engineering_analytics/data_modeling_design/schema_design"
    },
    {
      "id": 60701,
      "name": "software_engineering/code_quality/code_review"
    },
    {
      "id": 1001,
      "name": "cybersecurity/application_security"
    },
    {
      "id": 80302,
      "name": "data_engineering_analytics/query_engineering/query_optimization"
    }
  ],
  "version": "v1.0.0"
}

Advertisements

GossipSub broadcast

First seen
4 weeks, 2 days ago
Last seen
16 minutes ago
Announcements
1,125
Publishers
1
Topics
dir/labels/v1
Every 2 hours, last 3 days
Announcements Publishers
Announcements 30
Nov 14 Nov 15 Nov 16
10 Publishers

DHT add-provider

DHT key
QmcBNMsbEMrobxVEeUbY2PABCS7eb54k3ZmVDS2QQAoTid
First seen
6 days, 23 hours ago
Last seen
16 minutes ago
Requests
157
Providers
1
Lookups
6
Seekers
6
Last lookup
1 day, 1 hour ago
Every 2 hours, last 3 days
ADD_PROVIDER GET_PROVIDERS Providers
Requests 30
Nov 14 Nov 15 Nov 16
10 Providers

Skills

  • cybersecurity 1
    • application_security
  • data_engineering_analytics 2
    • data_modeling_design 1
      • schema_design
    • query_engineering 1
      • query_optimization
  • software_engineering 1
    • code_quality 1
      • code_review

Domains

  • research_and_development 2
    • grant_management
    • research_data_management
  • technology 2
    • information_technology 1
      • database_administration
    • security

Locators

None

Annotations

version
v1.0.0
oasf-version
1.1.0
name
postgresql-code-review

GossipSub publishers

DHT providers

github.com/libp2p/go-libp2p Expires in 1 day, 23 hours
Requests
157
First seen
6 days, 23 hours ago
Last seen
16 minutes ago
Connection address
/ip4/3.140.179.223/udp/57133/quic-v1
Listen addresses (3)
  • /ip4/10.0.17.42/tcp/5555
  • /ip4/127.0.0.1/tcp/5555
  • /ip4/3.150.168.105/tcp/5555
Protocols (14)
  • /dir/rpc/1.0.0
  • /floodsub/1.0.0
  • /ipfs/id/1.0.0
  • /ipfs/id/push/1.0.0
  • /ipfs/ping/1.0.0
  • /libp2p/autonat/1.0.0
  • /libp2p/circuit/relay/0.2.0/hop
  • /libp2p/circuit/relay/0.2.0/stop
  • /libp2p/dcutr
  • /meshsub/1.0.0
  • /meshsub/1.1.0
  • /meshsub/1.2.0
  • /meshsub/1.3.0
  • dir/kad/1.0.0

Latest pull attempts

Time Provider Providers found Lookup Connect Pull Total CID Signatures Trusted OASF Result
1 day, 1 hour ago 12D3KooWLf9p3cedc86xGQBaqak6rAFmQk1HxKAK1yh7umHE3amu 1 3,222 ms 0 ms 10,521 ms 13,743 ms 0 OK
2 days, 3 hours ago 12D3KooWLf9p3cedc86xGQBaqak6rAFmQk1HxKAK1yh7umHE3amu 1 7,541 ms 0 ms 5,390 ms 12,931 ms 0 OK
3 days, 5 hours ago 12D3KooWLf9p3cedc86xGQBaqak6rAFmQk1HxKAK1yh7umHE3amu 1 6,070 ms 0 ms 11,462 ms 17,532 ms 0 OK
4 days, 7 hours ago 12D3KooWLf9p3cedc86xGQBaqak6rAFmQk1HxKAK1yh7umHE3amu 1 3,801 ms 0 ms 13,333 ms 17,134 ms 0 OK
5 days, 9 hours ago 12D3KooWLf9p3cedc86xGQBaqak6rAFmQk1HxKAK1yh7umHE3amu 1 7,093 ms 0 ms 7,559 ms 14,652 ms 0 OK
6 days, 11 hours ago 12D3KooWLf9p3cedc86xGQBaqak6rAFmQk1HxKAK1yh7umHE3amu 1 8,649 ms 0 ms 10,887 ms 19,536 ms 1 OK