sql-queries

CID baeareib4bgpueyocnemdko4zokxrxbdyz2eqhidmysbkk3upcwqu3wfwk4
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 baeareibrctd6xij3udx6bbk3f2rakzng3pu3sbhxkfc4dfilljh6uhscfa: empty referrer baeareibrctd6xij3udx6bbk3f2rakzng3pu3sbhxkfc4dfilljh6uhscfa
OASF record valid
Yes

Record

Authors
Anthropic
Created
2026-08-18T02:31:22Z
Pulled
1 day ago
Modules
core/language_model/agentskills
Raw OASF record (JSON)
{
  "authors": [
    "Anthropic"
  ],
  "created_at": "2026-08-18T02:31:22Z",
  "description": "Write correct, performant SQL across all major data warehouse dialects (Snowflake, BigQuery, Databricks, PostgreSQL, etc.). Use when writing queries, optimizing slow SQL, translating between dialects, or building complex analytical queries with CTEs, window functions, or aggregations.",
  "domains": [
    {
      "id": 2004,
      "name": "retail_and_ecommerce/order_fulfillment"
    },
    {
      "id": 10603,
      "name": "technology/information_technology/database_administration"
    }
  ],
  "modules": [
    {
      "artifact": {
        "data": "LS0tCm5hbWU6IHNxbC1xdWVyaWVzCmRlc2NyaXB0aW9uOiBXcml0ZSBjb3JyZWN0LCBwZXJmb3JtYW50IFNRTCBhY3Jvc3MgYWxsIG1ham9yIGRhdGEgd2FyZWhvdXNlIGRpYWxlY3RzIChTbm93Zmxha2UsIEJpZ1F1ZXJ5LCBEYXRhYnJpY2tzLCBQb3N0Z3JlU1FMLCBldGMuKS4gVXNlIHdoZW4gd3JpdGluZyBxdWVyaWVzLCBvcHRpbWl6aW5nIHNsb3cgU1FMLCB0cmFuc2xhdGluZyBiZXR3ZWVuIGRpYWxlY3RzLCBvciBidWlsZGluZyBjb21wbGV4IGFuYWx5dGljYWwgcXVlcmllcyB3aXRoIENURXMsIHdpbmRvdyBmdW5jdGlvbnMsIG9yIGFnZ3JlZ2F0aW9ucy4KdXNlci1pbnZvY2FibGU6IGZhbHNlCi0tLQoKIyBTUUwgUXVlcmllcyBTa2lsbAoKV3JpdGUgY29ycmVjdCwgcGVyZm9ybWFudCwgcmVhZGFibGUgU1FMIGFjcm9zcyBhbGwgbWFqb3IgZGF0YSB3YXJlaG91c2UgZGlhbGVjdHMuCgojIyBEaWFsZWN0LVNwZWNpZmljIFJlZmVyZW5jZQoKIyMjIFBvc3RncmVTUUwgKGluY2x1ZGluZyBBdXJvcmEsIFJEUywgU3VwYWJhc2UsIE5lb24pCgoqKkRhdGUvdGltZToqKgpgYGBzcWwKLS0gQ3VycmVudCBkYXRlL3RpbWUKQ1VSUkVOVF9EQVRFLCBDVVJSRU5UX1RJTUVTVEFNUCwgTk9XKCkKCi0tIERhdGUgYXJpdGhtZXRpYwpkYXRlX2NvbHVtbiArIElOVEVSVkFMICc3IGRheXMnCmRhdGVfY29sdW1uIC0gSU5URVJWQUwgJzEgbW9udGgnCgotLSBUcnVuY2F0ZSB0byBwZXJpb2QKREFURV9UUlVOQygnbW9udGgnLCBjcmVhdGVkX2F0KQoKLS0gRXh0cmFjdCBwYXJ0cwpFWFRSQUNUKFlFQVIgRlJPTSBjcmVhdGVkX2F0KQpFWFRSQUNUKERPVyBGUk9NIGNyZWF0ZWRfYXQpICAtLSAwPVN1bmRheQoKLS0gRm9ybWF0ClRPX0NIQVIoY3JlYXRlZF9hdCwgJ1lZWVktTU0tREQnKQpgYGAKCioqU3RyaW5nIGZ1bmN0aW9uczoqKgpgYGBzcWwKLS0gQ29uY2F0ZW5hdGlvbgpmaXJzdF9uYW1lIHx8ICcgJyB8fCBsYXN0X25hbWUKQ09OQ0FUKGZpcnN0X25hbWUsICcgJywgbGFzdF9uYW1lKQoKLS0gUGF0dGVybiBtYXRjaGluZwpjb2x1bW4gSUxJS0UgJyVwYXR0ZXJuJScgIC0tIGNhc2UtaW5zZW5zaXRpdmUKY29sdW1uIH4gJ15yZWdleF9wYXR0ZXJuJCcgIC0tIHJlZ2V4CgotLSBTdHJpbmcgbWFuaXB1bGF0aW9uCkxFRlQoc3RyLCBuKSwgUklHSFQoc3RyLCBuKQpTUExJVF9QQVJUKHN0ciwgZGVsaW1pdGVyLCBwb3NpdGlvbikKUkVHRVhQX1JFUExBQ0Uoc3RyLCBwYXR0ZXJuLCByZXBsYWNlbWVudCkKYGBgCgoqKkFycmF5cyBhbmQgSlNPTjoqKgpgYGBzcWwKLS0gSlNPTiBhY2Nlc3MKZGF0YS0+PidrZXknICAtLSB0ZXh0CmRhdGEtPiduZXN0ZWQnLT4na2V5JyAgLS0ganNvbgpkYXRhIz4+J3twYXRoLHRvLGtleX0nICAtLSBuZXN0ZWQgdGV4dAoKLS0gQXJyYXkgb3BlcmF0aW9ucwpBUlJBWV9BR0coY29sdW1uKQpBTlkoYXJyYXlfY29sdW1uKQphcnJheV9jb2x1bW4gQD4gQVJSQVlbJ3ZhbHVlJ10KYGBgCgoqKlBlcmZvcm1hbmNlIHRpcHM6KioKLSBVc2UgYEVYUExBSU4gQU5BTFlaRWAgdG8gcHJvZmlsZSBxdWVyaWVzCi0gQ3JlYXRlIGluZGV4ZXMgb24gZnJlcXVlbnRseSBmaWx0ZXJlZC9qb2luZWQgY29sdW1ucwotIFVzZSBgRVhJU1RTYCBvdmVyIGBJTmAgZm9yIGNvcnJlbGF0ZWQgc3VicXVlcmllcwotIFBhcnRpYWwgaW5kZXhlcyBmb3IgY29tbW9uIGZpbHRlciBjb25kaXRpb25zCi0gVXNlIGNvbm5lY3Rpb24gcG9vbGluZyBmb3IgY29uY3VycmVudCBhY2Nlc3MKCi0tLQoKIyMjIFNub3dmbGFrZQoKKipEYXRlL3RpbWU6KioKYGBgc3FsCi0tIEN1cnJlbnQgZGF0ZS90aW1lCkNVUlJFTlRfREFURSgpLCBDVVJSRU5UX1RJTUVTVEFNUCgpLCBTWVNEQVRFKCkKCi0tIERhdGUgYXJpdGhtZXRpYwpEQVRFQUREKGRheSwgNywgZGF0ZV9jb2x1bW4pCkRBVEVESUZGKGRheSwgc3RhcnRfZGF0ZSwgZW5kX2RhdGUpCgotLSBUcnVuY2F0ZSB0byBwZXJpb2QKREFURV9UUlVOQygnbW9udGgnLCBjcmVhdGVkX2F0KQoKLS0gRXh0cmFjdCBwYXJ0cwpZRUFSKGNyZWF0ZWRfYXQpLCBNT05USChjcmVhdGVkX2F0KSwgREFZKGNyZWF0ZWRfYXQpCkRBWU9GV0VFSyhjcmVhdGVkX2F0KQoKLS0gRm9ybWF0ClRPX0NIQVIoY3JlYXRlZF9hdCwgJ1lZWVktTU0tREQnKQpgYGAKCioqU3RyaW5nIGZ1bmN0aW9uczoqKgpgYGBzcWwKLS0gQ2FzZS1pbnNlbnNpdGl2ZSBieSBkZWZhdWx0IChkZXBlbmRzIG9uIGNvbGxhdGlvbikKY29sdW1uIElMSUtFICclcGF0dGVybiUnClJFR0VYUF9MSUtFKGNvbHVtbiwgJ3BhdHRlcm4nKQoKLS0gUGFyc2UgSlNPTgpjb2x1bW46a2V5OjpzdHJpbmcgIC0tIGRvdCBub3RhdGlvbiBmb3IgVkFSSUFOVApQQVJTRV9KU09OKCd7ImtleSI6ICJ2YWx1ZSJ9JykKR0VUX1BBVEgodmFyaWFudF9jb2wsICdwYXRoLnRvLmtleScpCgotLSBGbGF0dGVuIGFycmF5cy9vYmplY3RzClNFTEVDVCBmLnZhbHVlIEZST00gdGFibGUsIExBVEVSQUwgRkxBVFRFTihpbnB1dCA9PiBhcnJheV9jb2wpIGYKYGBgCgoqKlNlbWktc3RydWN0dXJlZCBkYXRhOioqCmBgYHNxbAotLSBWQVJJQU5UIHR5cGUgYWNjZXNzCmRhdGE6Y3VzdG9tZXI6bmFtZTo6U1RSSU5HCmRhdGE6aXRlbXNbMF06cHJpY2U6Ok5VTUJFUgoKLS0gRmxhdHRlbiBuZXN0ZWQgc3RydWN0dXJlcwpTRUxFQ1QKICAgIHQuaWQsCiAgICBpdGVtLnZhbHVlOm5hbWU6OlNUUklORyBhcyBpdGVtX25hbWUsCiAgICBpdGVtLnZhbHVlOnF0eTo6TlVNQkVSIGFzIHF1YW50aXR5CkZST00gbXlfdGFibGUgdCwKTEFURVJBTCBGTEFUVEVOKGlucHV0ID0+IHQuZGF0YTppdGVtcykgaXRlbQpgYGAKCioqUGVyZm9ybWFuY2UgdGlwczoqKgotIFVzZSBjbHVzdGVyaW5nIGtleXMgb24gbGFyZ2UgdGFibGVzIChub3QgdHJhZGl0aW9uYWwgaW5kZXhlcykKLSBGaWx0ZXIgb24gY2x1c3RlcmluZyBrZXkgY29sdW1ucyBmb3IgcGFydGl0aW9uIHBydW5pbmcKLSBTZXQgYXBwcm9wcmlhdGUgd2FyZWhvdXNlIHNpemUgZm9yIHF1ZXJ5IGNvbXBsZXhpdHkKLSBVc2UgYFJFU1VMVF9TQ0FOKExBU1RfUVVFUllfSUQoKSlgIHRvIGF2b2lkIHJlLXJ1bm5pbmcgZXhwZW5zaXZlIHF1ZXJpZXMKLSBVc2UgdHJhbnNpZW50IHRhYmxlcyBmb3Igc3RhZ2luZy90ZW1wIGRhdGEKCi0tLQoKIyMjIEJpZ1F1ZXJ5IChHb29nbGUgQ2xvdWQpCgoqKkRhdGUvdGltZToqKgpgYGBzcWwKLS0gQ3VycmVudCBkYXRlL3RpbWUKQ1VSUkVOVF9EQVRFKCksIENVUlJFTlRfVElNRVNUQU1QKCkKCi0tIERhdGUgYXJpdGhtZXRpYwpEQVRFX0FERChkYXRlX2NvbHVtbiwgSU5URVJWQUwgNyBEQVkpCkRBVEVfU1VCKGRhdGVfY29sdW1uLCBJTlRFUlZBTCAxIE1PTlRIKQpEQVRFX0RJRkYoZW5kX2RhdGUsIHN0YXJ0X2RhdGUsIERBWSkKVElNRVNUQU1QX0RJRkYoZW5kX3RzLCBzdGFydF90cywgSE9VUikKCi0tIFRydW5jYXRlIHRvIHBlcmlvZApEQVRFX1RSVU5DKGNyZWF0ZWRfYXQsIE1PTlRIKQpUSU1FU1RBTVBfVFJVTkMoY3JlYXRlZF9hdCwgSE9VUikKCi0tIEV4dHJhY3QgcGFydHMKRVhUUkFDVChZRUFSIEZST00gY3JlYXRlZF9hdCkKRVhUUkFDVChEQVlPRldFRUsgRlJPTSBjcmVhdGVkX2F0KSAgLS0gMT1TdW5kYXkKCi0tIEZvcm1hdApGT1JNQVRfREFURSgnJVktJW0tJWQnLCBkYXRlX2NvbHVtbikKRk9STUFUX1RJTUVTVEFNUCgnJVktJW0tJWQgJUg6JU06JVMnLCB0c19jb2x1bW4pCmBgYAoKKipTdHJpbmcgZnVuY3Rpb25zOioqCmBgYHNxbAotLSBObyBJTElLRSwgdXNlIExPV0VSKCkKTE9XRVIoY29sdW1uKSBMSUtFICclcGF0dGVybiUnClJFR0VYUF9DT05UQUlOUyhjb2x1bW4sIHIncGF0dGVybicpClJFR0VYUF9FWFRSQUNUKGNvbHVtbiwgcidwYXR0ZXJuJykKCi0tIFN0cmluZyBtYW5pcHVsYXRpb24KU1BMSVQoc3RyLCBkZWxpbWl0ZXIpICAtLSByZXR1cm5zIEFSUkFZCkFSUkFZX1RPX1NUUklORyhhcnJheSwgZGVsaW1pdGVyKQpgYGAKCioqQXJyYXlzIGFuZCBzdHJ1Y3RzOioqCmBgYHNxbAotLSBBcnJheSBvcGVyYXRpb25zCkFSUkFZX0FHRyhjb2x1bW4pClVOTkVTVChhcnJheV9jb2x1bW4pCkFSUkFZX0xFTkdUSChhcnJheV9jb2x1bW4pCnZhbHVlIElOIFVOTkVTVChhcnJheV9jb2x1bW4pCgotLSBTdHJ1Y3QgYWNjZXNzCnN0cnVjdF9jb2x1bW4uZmllbGRfbmFtZQpgYGAKCioqUGVyZm9ybWFuY2UgdGlwczoqKgotIEFsd2F5cyBmaWx0ZXIgb24gcGFydGl0aW9uIGNvbHVtbnMgKHVzdWFsbHkgZGF0ZSkgdG8gcmVkdWNlIGJ5dGVzIHNjYW5uZWQKLSBVc2UgY2x1c3RlcmluZyBmb3IgZnJlcXVlbnRseSBmaWx0ZXJlZCBjb2x1bW5zIHdpdGhpbiBwYXJ0aXRpb25zCi0gVXNlIGBBUFBST1hfQ09VTlRfRElTVElOQ1QoKWAgZm9yIGxhcmdlLXNjYWxlIGNhcmRpbmFsaXR5IGVzdGltYXRlcwotIEF2b2lkIGBTRUxFQ1QgKmAgLS0gYmlsbGluZyBpcyBwZXItYnl0ZSBzY2FubmVkCi0gVXNlIGBERUNMQVJFYCBhbmQgYFNFVGAgZm9yIHBhcmFtZXRlcml6ZWQgc2NyaXB0cwotIFByZXZpZXcgcXVlcnkgY29zdCB3aXRoIGRyeSBydW4gYmVmb3JlIGV4ZWN1dGluZyBsYXJnZSBxdWVyaWVzCgotLS0KCiMjIyBSZWRzaGlmdCAoQW1hem9uKQoKKipEYXRlL3RpbWU6KioKYGBgc3FsCi0tIEN1cnJlbnQgZGF0ZS90aW1lCkNVUlJFTlRfREFURSwgR0VUREFURSgpLCBTWVNEQVRFCgotLSBEYXRlIGFyaXRobWV0aWMKREFURUFERChkYXksIDcsIGRhdGVfY29sdW1uKQpEQVRFRElGRihkYXksIHN0YXJ0X2RhdGUsIGVuZF9kYXRlKQoKLS0gVHJ1bmNhdGUgdG8gcGVyaW9kCkRBVEVfVFJVTkMoJ21vbnRoJywgY3JlYXRlZF9hdCkKCi0tIEV4dHJhY3QgcGFydHMKRVhUUkFDVChZRUFSIEZST00gY3JlYXRlZF9hdCkKREFURV9QQVJUKCdkb3cnLCBjcmVhdGVkX2F0KQpgYGAKCioqU3RyaW5nIGZ1bmN0aW9uczoqKgpgYGBzcWwKLS0gQ2FzZS1pbnNlbnNpdGl2ZQpjb2x1bW4gSUxJS0UgJyVwYXR0ZXJuJScKUkVHRVhQX0lOU1RSKGNvbHVtbiwgJ3BhdHRlcm4nKSA+IDAKCi0tIFN0cmluZyBtYW5pcHVsYXRpb24KU1BMSVRfUEFSVChzdHIsIGRlbGltaXRlciwgcG9zaXRpb24pCkxJU1RBR0coY29sdW1uLCAnLCAnKSBXSVRISU4gR1JPVVAgKE9SREVSIEJZIGNvbHVtbikKYGBgCgoqKlBlcmZvcm1hbmNlIHRpcHM6KioKLSBEZXNpZ24gZGlzdHJpYnV0aW9uIGtleXMgZm9yIGNvbGxvY2F0ZWQgam9pbnMgKERJU1RLRVkpCi0gVXNlIHNvcnQga2V5cyBmb3IgZnJlcXVlbnRseSBmaWx0ZXJlZCBjb2x1bW5zIChTT1JUS0VZKQotIFVzZSBgRVhQTEFJTmAgdG8gY2hlY2sgcXVlcnkgcGxhbgotIEF2b2lkIGNyb3NzLW5vZGUgZGF0YSBtb3ZlbWVudCAod2F0Y2ggZm9yIERTX0JDQVNUIGFuZCBEU19ESVNUKQotIGBBTkFMWVpFYCBhbmQgYFZBQ1VVTWAgcmVndWxhcmx5Ci0gVXNlIGxhdGUtYmluZGluZyB2aWV3cyBmb3Igc2NoZW1hIGZsZXhpYmlsaXR5CgotLS0KCiMjIyBEYXRhYnJpY2tzIFNRTAoKKipEYXRlL3RpbWU6KioKYGBgc3FsCi0tIEN1cnJlbnQgZGF0ZS90aW1lCkNVUlJFTlRfREFURSgpLCBDVVJSRU5UX1RJTUVTVEFNUCgpCgotLSBEYXRlIGFyaXRobWV0aWMKREFURV9BREQoZGF0ZV9jb2x1bW4sIDcpCkRBVEVESUZGKGVuZF9kYXRlLCBzdGFydF9kYXRlKQpBRERfTU9OVEhTKGRhdGVfY29sdW1uLCAxKQoKLS0gVHJ1bmNhdGUgdG8gcGVyaW9kCkRBVEVfVFJVTkMoJ01PTlRIJywgY3JlYXRlZF9hdCkKVFJVTkMoZGF0ZV9jb2x1bW4sICdNTScpCgotLSBFeHRyYWN0IHBhcnRzCllFQVIoY3JlYXRlZF9hdCksIE1PTlRIKGNyZWF0ZWRfYXQpCkRBWU9GV0VFSyhjcmVhdGVkX2F0KQpgYGAKCioqRGVsdGEgTGFrZSBmZWF0dXJlczoqKgpgYGBzcWwKLS0gVGltZSB0cmF2ZWwKU0VMRUNUICogRlJPTSBteV90YWJsZSBUSU1FU1RBTVAgQVMgT0YgJzIwMjQtMDEtMTUnClNFTEVDVCAqIEZST00gbXlfdGFibGUgVkVSU0lPTiBBUyBPRiA0MgoKLS0gRGVzY3JpYmUgaGlzdG9yeQpERVNDUklCRSBISVNUT1JZIG15X3RhYmxlCgotLSBNZXJnZSAodXBzZXJ0KQpNRVJHRSBJTlRPIHRhcmdldCBVU0lORyBzb3VyY2UKT04gdGFyZ2V0LmlkID0gc291cmNlLmlkCldIRU4gTUFUQ0hFRCBUSEVOIFVQREFURSBTRVQgKgpXSEVOIE5PVCBNQVRDSEVEIFRIRU4gSU5TRVJUICoKYGBgCgoqKlBlcmZvcm1hbmNlIHRpcHM6KioKLSBVc2UgRGVsdGEgTGFrZSdzIGBPUFRJTUlaRWAgYW5kIGBaT1JERVJgIGZvciBxdWVyeSBwZXJmb3JtYW5jZQotIExldmVyYWdlIFBob3RvbiBlbmdpbmUgZm9yIGNvbXB1dGUtaW50ZW5zaXZlIHF1ZXJpZXMKLSBVc2UgYENBQ0hFIFRBQkxFYCBmb3IgZnJlcXVlbnRseSBhY2Nlc3NlZCBkYXRhc2V0cwotIFBhcnRpdGlvbiBieSBsb3ctY2FyZGluYWxpdHkgZGF0ZSBjb2x1bW5zCgotLS0KCiMjIENvbW1vbiBTUUwgUGF0dGVybnMKCiMjIyBXaW5kb3cgRnVuY3Rpb25zCgpgYGBzcWwKLS0gUmFua2luZwpST1dfTlVNQkVSKCkgT1ZFUiAoUEFSVElUSU9OIEJZIHVzZXJfaWQgT1JERVIgQlkgY3JlYXRlZF9hdCBERVNDKQpSQU5LKCkgT1ZFUiAoUEFSVElUSU9OIEJZIGNhdGVnb3J5IE9SREVSIEJZIHJldmVudWUgREVTQykKREVOU0VfUkFOSygpIE9WRVIgKE9SREVSIEJZIHNjb3JlIERFU0MpCgotLSBSdW5uaW5nIHRvdGFscyAvIG1vdmluZyBhdmVyYWdlcwpTVU0ocmV2ZW51ZSkgT1ZFUiAoT1JERVIgQlkgZGF0ZV9jb2wgUk9XUyBCRVRXRUVOIFVOQk9VTkRFRCBQUkVDRURJTkcgQU5EIENVUlJFTlQgUk9XKSBhcyBydW5uaW5nX3RvdGFsCkFWRyhyZXZlbnVlKSBPVkVSIChPUkRFUiBCWSBkYXRlX2NvbCBST1dTIEJFVFdFRU4gNiBQUkVDRURJTkcgQU5EIENVUlJFTlQgUk9XKSBhcyBtb3ZpbmdfYXZnXzdkCgotLSBMYWcgLyBMZWFkCkxBRyh2YWx1ZSwgMSkgT1ZFUiAoUEFSVElUSU9OIEJZIGVudGl0eSBPUkRFUiBCWSBkYXRlX2NvbCkgYXMgcHJldl92YWx1ZQpMRUFEKHZhbHVlLCAxKSBPVkVSIChQQVJUSVRJT04gQlkgZW50aXR5IE9SREVSIEJZIGRhdGVfY29sKSBhcyBuZXh0X3ZhbHVlCgotLSBGaXJzdCAvIExhc3QgdmFsdWUKRklSU1RfVkFMVUUoc3RhdHVzKSBPVkVSIChQQVJUSVRJT04gQlkgdXNlcl9pZCBPUkRFUiBCWSBjcmVhdGVkX2F0IFJPV1MgQkVUV0VFTiBVTkJPVU5ERUQgUFJFQ0VESU5HIEFORCBVTkJPVU5ERUQgRk9MTE9XSU5HKQpMQVNUX1ZBTFVFKHN0YXR1cykgT1ZFUiAoUEFSVElUSU9OIEJZIHVzZXJfaWQgT1JERVIgQlkgY3JlYXRlZF9hdCBST1dTIEJFVFdFRU4gVU5CT1VOREVEIFBSRUNFRElORyBBTkQgVU5CT1VOREVEIEZPTExPV0lORykKCi0tIFBlcmNlbnQgb2YgdG90YWwKcmV2ZW51ZSAvIFNVTShyZXZlbnVlKSBPVkVSICgpIGFzIHBjdF9vZl90b3RhbApyZXZlbnVlIC8gU1VNKHJldmVudWUpIE9WRVIgKFBBUlRJVElPTiBCWSBjYXRlZ29yeSkgYXMgcGN0X29mX2NhdGVnb3J5CmBgYAoKIyMjIENURXMgZm9yIFJlYWRhYmlsaXR5CgpgYGBzcWwKV0lUSAotLSBTdGVwIDE6IERlZmluZSB0aGUgYmFzZSBwb3B1bGF0aW9uCmJhc2VfdXNlcnMgQVMgKAogICAgU0VMRUNUIHVzZXJfaWQsIGNyZWF0ZWRfYXQsIHBsYW5fdHlwZQogICAgRlJPTSB1c2VycwogICAgV0hFUkUgY3JlYXRlZF9hdCA+PSBEQVRFICcyMDI0LTAxLTAxJwogICAgICBBTkQgc3RhdHVzID0gJ2FjdGl2ZScKKSwKCi0tIFN0ZXAgMjogQ2FsY3VsYXRlIHVzZXItbGV2ZWwgbWV0cmljcwp1c2VyX21ldHJpY3MgQVMgKAogICAgU0VMRUNUCiAgICAgICAgdS51c2VyX2lkLAogICAgICAgIHUucGxhbl90eXBlLAogICAgICAgIENPVU5UKERJU1RJTkNUIGUuc2Vzc2lvbl9pZCkgYXMgc2Vzc2lvbl9jb3VudCwKICAgICAgICBTVU0oZS5yZXZlbnVlKSBhcyB0b3RhbF9yZXZlbnVlCiAgICBGUk9NIGJhc2VfdXNlcnMgdQogICAgTEVGVCBKT0lOIGV2ZW50cyBlIE9OIHUudXNlcl9pZCA9IGUudXNlcl9pZAogICAgR1JPVVAgQlkgdS51c2VyX2lkLCB1LnBsYW5fdHlwZQopLAoKLS0gU3RlcCAzOiBBZ2dyZWdhdGUgdG8gc3VtbWFyeSBsZXZlbApzdW1tYXJ5IEFTICgKICAgIFNFTEVDVAogICAgICAgIHBsYW5fdHlwZSwKICAgICAgICBDT1VOVCgqKSBhcyB1c2VyX2NvdW50LAogICAgICAgIEFWRyhzZXNzaW9uX2NvdW50KSBhcyBhdmdfc2Vzc2lvbnMsCiAgICAgICAgU1VNKHRvdGFsX3JldmVudWUpIGFzIHRvdGFsX3JldmVudWUKICAgIEZST00gdXNlcl9tZXRyaWNzCiAgICBHUk9VUCBCWSBwbGFuX3R5cGUKKQoKU0VMRUNUICogRlJPTSBzdW1tYXJ5IE9SREVSIEJZIHRvdGFsX3JldmVudWUgREVTQzsKYGBgCgojIyMgQ29ob3J0IFJldGVudGlvbgoKYGBgc3FsCldJVEggY29ob3J0cyBBUyAoCiAgICBTRUxFQ1QKICAgICAgICB1c2VyX2lkLAogICAgICAgIERBVEVfVFJVTkMoJ21vbnRoJywgZmlyc3RfYWN0aXZpdHlfZGF0ZSkgYXMgY29ob3J0X21vbnRoCiAgICBGUk9NIHVzZXJzCiksCmFjdGl2aXR5IEFTICgKICAgIFNFTEVDVAogICAgICAgIHVzZXJfaWQsCiAgICAgICAgREFURV9UUlVOQygnbW9udGgnLCBhY3Rpdml0eV9kYXRlKSBhcyBhY3Rpdml0eV9tb250aAogICAgRlJPTSB1c2VyX2FjdGl2aXR5CikKU0VMRUNUCiAgICBjLmNvaG9ydF9tb250aCwKICAgIENPVU5UKERJU1RJTkNUIGMudXNlcl9pZCkgYXMgY29ob3J0X3NpemUsCiAgICBDT1VOVChESVNUSU5DVCBDQVNFCiAgICAgICAgV0hFTiBhLmFjdGl2aXR5X21vbnRoID0gYy5jb2hvcnRfbW9udGggVEhFTiBhLnVzZXJfaWQKICAgIEVORCkgYXMgbW9udGhfMCwKICAgIENPVU5UKERJU1RJTkNUIENBU0UKICAgICAgICBXSEVOIGEuYWN0aXZpdHlfbW9udGggPSBjLmNvaG9ydF9tb250aCArIElOVEVSVkFMICcxIG1vbnRoJyBUSEVOIGEudXNlcl9pZAogICAgRU5EKSBhcyBtb250aF8xLAogICAgQ09VTlQoRElTVElOQ1QgQ0FTRQogICAgICAgIFdIRU4gYS5hY3Rpdml0eV9tb250aCA9IGMuY29ob3J0X21vbnRoICsgSU5URVJWQUwgJzMgbW9udGhzJyBUSEVOIGEudXNlcl9pZAogICAgRU5EKSBhcyBtb250aF8zCkZST00gY29ob3J0cyBjCkxFRlQgSk9JTiBhY3Rpdml0eSBhIE9OIGMudXNlcl9pZCA9IGEudXNlcl9pZApHUk9VUCBCWSBjLmNvaG9ydF9tb250aApPUkRFUiBCWSBjLmNvaG9ydF9tb250aDsKYGBgCgojIyMgRnVubmVsIEFuYWx5c2lzCgpgYGBzcWwKV0lUSCBmdW5uZWwgQVMgKAogICAgU0VMRUNUCiAgICAgICAgdXNlcl9pZCwKICAgICAgICBNQVgoQ0FTRSBXSEVOIGV2ZW50ID0gJ3BhZ2VfdmlldycgVEhFTiAxIEVMU0UgMCBFTkQpIGFzIHN0ZXBfMV92aWV3LAogICAgICAgIE1BWChDQVNFIFdIRU4gZXZlbnQgPSAnc2lnbnVwX3N0YXJ0JyBUSEVOIDEgRUxTRSAwIEVORCkgYXMgc3RlcF8yX3N0YXJ0LAogICAgICAgIE1BWChDQVNFIFdIRU4gZXZlbnQgPSAnc2lnbnVwX2NvbXBsZXRlJyBUSEVOIDEgRUxTRSAwIEVORCkgYXMgc3RlcF8zX2NvbXBsZXRlLAogICAgICAgIE1BWChDQVNFIFdIRU4gZXZlbnQgPSAnZmlyc3RfcHVyY2hhc2UnIFRIRU4gMSBFTFNFIDAgRU5EKSBhcyBzdGVwXzRfcHVyY2hhc2UKICAgIEZST00gZXZlbnRzCiAgICBXSEVSRSBldmVudF9kYXRlID49IENVUlJFTlRfREFURSAtIElOVEVSVkFMICczMCBkYXlzJwogICAgR1JPVVAgQlkgdXNlcl9pZAopClNFTEVDVAogICAgQ09VTlQoKikgYXMgdG90YWxfdXNlcnMsCiAgICBTVU0oc3RlcF8xX3ZpZXcpIGFzIHZpZXdlZCwKICAgIFNVTShzdGVwXzJfc3RhcnQpIGFzIHN0YXJ0ZWRfc2lnbnVwLAogICAgU1VNKHN0ZXBfM19jb21wbGV0ZSkgYXMgY29tcGxldGVkX3NpZ251cCwKICAgIFNVTShzdGVwXzRfcHVyY2hhc2UpIGFzIHB1cmNoYXNlZCwKICAgIFJPVU5EKDEwMC4wICogU1VNKHN0ZXBfMl9zdGFydCkgLyBOVUxMSUYoU1VNKHN0ZXBfMV92aWV3KSwgMCksIDEpIGFzIHZpZXdfdG9fc3RhcnRfcGN0LAogICAgUk9VTkQoMTAwLjAgKiBTVU0oc3RlcF8zX2NvbXBsZXRlKSAvIE5VTExJRihTVU0oc3RlcF8yX3N0YXJ0KSwgMCksIDEpIGFzIHN0YXJ0X3RvX2NvbXBsZXRlX3BjdCwKICAgIFJPVU5EKDEwMC4wICogU1VNKHN0ZXBfNF9wdXJjaGFzZSkgLyBOVUxMSUYoU1VNKHN0ZXBfM19jb21wbGV0ZSksIDApLCAxKSBhcyBjb21wbGV0ZV90b19wdXJjaGFzZV9wY3QKRlJPTSBmdW5uZWw7CmBgYAoKIyMjIERlZHVwbGljYXRpb24KCmBgYHNxbAotLSBLZWVwIHRoZSBtb3N0IHJlY2VudCByZWNvcmQgcGVyIGtleQpXSVRIIHJhbmtlZCBBUyAoCiAgICBTRUxFQ1QKICAgICAgICAqLAogICAgICAgIFJPV19OVU1CRVIoKSBPVkVSICgKICAgICAgICAgICAgUEFSVElUSU9OIEJZIGVudGl0eV9pZAogICAgICAgICAgICBPUkRFUiBCWSB1cGRhdGVkX2F0IERFU0MKICAgICAgICApIGFzIHJuCiAgICBGUk9NIHNvdXJjZV90YWJsZQopClNFTEVDVCAqIEZST00gcmFua2VkIFdIRVJFIHJuID0gMTsKYGBgCgojIyBFcnJvciBIYW5kbGluZyBhbmQgRGVidWdnaW5nCgpXaGVuIGEgcXVlcnkgZmFpbHM6CgoxLiAqKlN5bnRheCBlcnJvcnMqKjogQ2hlY2sgZm9yIGRpYWxlY3Qtc3BlY2lmaWMgc3ludGF4IChlLmcuLCBgSUxJS0VgIG5vdCBhdmFpbGFibGUgaW4gQmlnUXVlcnksIGBTQUZFX0RJVklERWAgb25seSBpbiBCaWdRdWVyeSkKMi4gKipDb2x1bW4gbm90IGZvdW5kKio6IFZlcmlmeSBjb2x1bW4gbmFtZXMgYWdhaW5zdCBzY2hlbWEgLS0gY2hlY2sgZm9yIHR5cG9zLCBjYXNlIHNlbnNpdGl2aXR5IChQb3N0Z3JlU1FMIGlzIGNhc2Utc2Vuc2l0aXZlIGZvciBxdW90ZWQgaWRlbnRpZmllcnMpCjMuICoqVHlwZSBtaXNtYXRjaGVzKio6IENhc3QgZXhwbGljaXRseSB3aGVuIGNvbXBhcmluZyBkaWZmZXJlbnQgdHlwZXMgKGBDQVNUKGNvbCBBUyBEQVRFKWAsIGBjb2w6OkRBVEVgKQo0LiAqKkRpdmlzaW9uIGJ5IHplcm8qKjogVXNlIGBOVUxMSUYoZGVub21pbmF0b3IsIDApYCBvciBkaWFsZWN0LXNwZWNpZmljIHNhZmUgZGl2aXNpb24KNS4gKipBbWJpZ3VvdXMgY29sdW1ucyoqOiBBbHdheXMgcXVhbGlmeSBjb2x1bW4gbmFtZXMgd2l0aCB0YWJsZSBhbGlhcyBpbiBKT0lOcwo2LiAqKkdyb3VwIGJ5IGVycm9ycyoqOiBBbGwgbm9uLWFnZ3JlZ2F0ZWQgY29sdW1ucyBtdXN0IGJlIGluIEdST1VQIEJZIChleGNlcHQgaW4gQmlnUXVlcnkgd2hpY2ggYWxsb3dzIGdyb3VwaW5nIGJ5IGFsaWFzKQo=",
        "digest": "sha256:dbd5a5e2d563d83ca6d4d033206f285f503296eabff4a35545cdb4cb5302bd9a",
        "media_type": "application/agent-skills+md",
        "size": 11126
      },
      "data": {
        "skill_file": "SKILL.md",
        "skill_manifest": {
          "description": "Write correct, performant SQL across all major data warehouse dialects (Snowflake, BigQuery, Databricks, PostgreSQL, etc.). Use when writing queries, optimizing slow SQL, translating between dialects, or building complex analytical queries with CTEs, window functions, or aggregations.",
          "name": "sql-queries",
          "version": "v1.0.0"
        }
      },
      "id": 10302,
      "name": "core/language_model/agentskills"
    }
  ],
  "name": "sql-queries",
  "schema_version": "1.1.0",
  "skills": [
    {
      "id": 80201,
      "name": "data_engineering_analytics/data_modeling_design/schema_design"
    },
    {
      "id": 803,
      "name": "data_engineering_analytics/query_engineering"
    },
    {
      "id": 80302,
      "name": "data_engineering_analytics/query_engineering/query_optimization"
    },
    {
      "id": 80301,
      "name": "data_engineering_analytics/query_engineering/query_generation"
    }
  ],
  "version": "v1.0.0"
}

Advertisements

GossipSub broadcast

First seen
1 month ago
Last seen
14 minutes ago
Announcements
1,163
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
QmSP1gTxQq1YEx6NPCNFofq45ApqsQi8uweXRf7fVYKjCr
First seen
6 days, 23 hours ago
Last seen
14 minutes ago
Requests
158
Providers
1
Lookups
6
Seekers
6
Last lookup
1 day ago
Every 2 hours, last 3 days
ADD_PROVIDER GET_PROVIDERS Providers
Requests 30
Nov 14 Nov 15 Nov 16
10 Providers

Skills

  • data_engineering_analytics 2
    • data_modeling_design 1
      • schema_design
    • query_engineering 2
      • query_generation
      • query_optimization

Domains

  • retail_and_ecommerce 1
    • order_fulfillment
  • technology 1
    • information_technology 1
      • database_administration

Locators

None

Annotations

name
sql-queries
version
v1.0.0
oasf-version
1.1.0

GossipSub publishers

DHT providers

github.com/libp2p/go-libp2p Expires in 1 day, 23 hours
Requests
158
First seen
6 days, 23 hours ago
Last seen
14 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 ago 12D3KooWLf9p3cedc86xGQBaqak6rAFmQk1HxKAK1yh7umHE3amu 1 5,869 ms 0 ms 8,790 ms 14,659 ms 0 OK
2 days, 2 hours ago 12D3KooWLf9p3cedc86xGQBaqak6rAFmQk1HxKAK1yh7umHE3amu 1 3,606 ms 0 ms 7,989 ms 11,596 ms 0 OK
3 days, 4 hours ago 12D3KooWLf9p3cedc86xGQBaqak6rAFmQk1HxKAK1yh7umHE3amu 1 8,384 ms 0 ms 9,253 ms 17,638 ms 0 OK
4 days, 6 hours ago 12D3KooWLf9p3cedc86xGQBaqak6rAFmQk1HxKAK1yh7umHE3amu 1 5,405 ms 0 ms 12,963 ms 18,368 ms 0 OK
5 days, 9 hours ago 12D3KooWLf9p3cedc86xGQBaqak6rAFmQk1HxKAK1yh7umHE3amu 1 8,220 ms 0 ms 6,005 ms 14,225 ms 0 OK
6 days, 10 hours ago 12D3KooWLf9p3cedc86xGQBaqak6rAFmQk1HxKAK1yh7umHE3amu 1 10,000 ms 0 ms 11,955 ms 21,956 ms 1 OK