write-query

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

Record

Authors
Anthropic
Created
2026-08-18T02:32:37Z
Pulled
22 hours ago
Modules
core/language_model/agentskills
Raw OASF record (JSON)
{
  "authors": [
    "Anthropic"
  ],
  "created_at": "2026-08-18T02:32:37Z",
  "description": "Write optimized SQL for your dialect with best practices. Use when translating a natural-language data need into SQL, building a multi-CTE query with joins and aggregations, optimizing a query against a large partitioned table, or getting dialect-specific syntax for Snowflake, BigQuery, Postgres, etc.",
  "domains": [
    {
      "id": 10603,
      "name": "technology/information_technology/database_administration"
    },
    {
      "id": 2006,
      "name": "retail_and_ecommerce/retail_analytics"
    },
    {
      "id": 11104,
      "name": "technology/artificial_intelligence/large_language_models"
    },
    {
      "id": 10401,
      "name": "technology/data_science/big_data"
    }
  ],
  "modules": [
    {
      "artifact": {
        "data": "LS0tCm5hbWU6IHdyaXRlLXF1ZXJ5CmRlc2NyaXB0aW9uOiBXcml0ZSBvcHRpbWl6ZWQgU1FMIGZvciB5b3VyIGRpYWxlY3Qgd2l0aCBiZXN0IHByYWN0aWNlcy4gVXNlIHdoZW4gdHJhbnNsYXRpbmcgYSBuYXR1cmFsLWxhbmd1YWdlIGRhdGEgbmVlZCBpbnRvIFNRTCwgYnVpbGRpbmcgYSBtdWx0aS1DVEUgcXVlcnkgd2l0aCBqb2lucyBhbmQgYWdncmVnYXRpb25zLCBvcHRpbWl6aW5nIGEgcXVlcnkgYWdhaW5zdCBhIGxhcmdlIHBhcnRpdGlvbmVkIHRhYmxlLCBvciBnZXR0aW5nIGRpYWxlY3Qtc3BlY2lmaWMgc3ludGF4IGZvciBTbm93Zmxha2UsIEJpZ1F1ZXJ5LCBQb3N0Z3JlcywgZXRjLgphcmd1bWVudC1oaW50OiAiPGRlc2NyaXB0aW9uIG9mIHdoYXQgZGF0YSB5b3UgbmVlZD4iCi0tLQoKIyAvd3JpdGUtcXVlcnkgLSBXcml0ZSBPcHRpbWl6ZWQgU1FMCgo+IElmIHlvdSBzZWUgdW5mYW1pbGlhciBwbGFjZWhvbGRlcnMgb3IgbmVlZCB0byBjaGVjayB3aGljaCB0b29scyBhcmUgY29ubmVjdGVkLCBzZWUgW0NPTk5FQ1RPUlMubWRdKC4uLy4uL0NPTk5FQ1RPUlMubWQpLgoKV3JpdGUgYSBTUUwgcXVlcnkgZnJvbSBhIG5hdHVyYWwgbGFuZ3VhZ2UgZGVzY3JpcHRpb24sIG9wdGltaXplZCBmb3IgeW91ciBzcGVjaWZpYyBTUUwgZGlhbGVjdCBhbmQgZm9sbG93aW5nIGJlc3QgcHJhY3RpY2VzLgoKIyMgVXNhZ2UKCmBgYAovd3JpdGUtcXVlcnkgPGRlc2NyaXB0aW9uIG9mIHdoYXQgZGF0YSB5b3UgbmVlZD4KYGBgCgojIyBXb3JrZmxvdwoKIyMjIDEuIFVuZGVyc3RhbmQgdGhlIFJlcXVlc3QKClBhcnNlIHRoZSB1c2VyJ3MgZGVzY3JpcHRpb24gdG8gaWRlbnRpZnk6CgotICoqT3V0cHV0IGNvbHVtbnMqKjogV2hhdCBmaWVsZHMgc2hvdWxkIHRoZSByZXN1bHQgaW5jbHVkZT8KLSAqKkZpbHRlcnMqKjogV2hhdCBjb25kaXRpb25zIGxpbWl0IHRoZSBkYXRhICh0aW1lIHJhbmdlcywgc2VnbWVudHMsIHN0YXR1c2VzKT8KLSAqKkFnZ3JlZ2F0aW9ucyoqOiBBcmUgdGhlcmUgR1JPVVAgQlkgb3BlcmF0aW9ucywgY291bnRzLCBzdW1zLCBhdmVyYWdlcz8KLSAqKkpvaW5zKio6IERvZXMgdGhpcyByZXF1aXJlIGNvbWJpbmluZyBtdWx0aXBsZSB0YWJsZXM/Ci0gKipPcmRlcmluZyoqOiBIb3cgc2hvdWxkIHJlc3VsdHMgYmUgc29ydGVkPwotICoqTGltaXRzKio6IElzIHRoZXJlIGEgdG9wLU4gb3Igc2FtcGxlIHJlcXVpcmVtZW50PwoKIyMjIDIuIERldGVybWluZSBTUUwgRGlhbGVjdAoKSWYgdGhlIHVzZXIncyBTUUwgZGlhbGVjdCBpcyBub3QgYWxyZWFkeSBrbm93biwgYXNrIHdoaWNoIHRoZXkgdXNlOgoKLSAqKlBvc3RncmVTUUwqKiAoaW5jbHVkaW5nIEF1cm9yYSwgUkRTLCBTdXBhYmFzZSwgTmVvbikKLSAqKlNub3dmbGFrZSoqCi0gKipCaWdRdWVyeSoqIChHb29nbGUgQ2xvdWQpCi0gKipSZWRzaGlmdCoqIChBbWF6b24pCi0gKipEYXRhYnJpY2tzIFNRTCoqCi0gKipNeVNRTCoqIChpbmNsdWRpbmcgQXVyb3JhIE15U1FMLCBQbGFuZXRTY2FsZSkKLSAqKlNRTCBTZXJ2ZXIqKiAoTWljcm9zb2Z0KQotICoqRHVja0RCKioKLSAqKlNRTGl0ZSoqCi0gKipPdGhlcioqIChhc2sgZm9yIHNwZWNpZmljcykKClJlbWVtYmVyIHRoZSBkaWFsZWN0IGZvciBmdXR1cmUgcXVlcmllcyBpbiB0aGUgc2FtZSBzZXNzaW9uLgoKIyMjIDMuIERpc2NvdmVyIFNjaGVtYSAoSWYgV2FyZWhvdXNlIENvbm5lY3RlZCkKCklmIGEgZGF0YSB3YXJlaG91c2UgTUNQIHNlcnZlciBpcyBjb25uZWN0ZWQ6CgoxLiBTZWFyY2ggZm9yIHJlbGV2YW50IHRhYmxlcyBiYXNlZCBvbiB0aGUgdXNlcidzIGRlc2NyaXB0aW9uCjIuIEluc3BlY3QgY29sdW1uIG5hbWVzLCB0eXBlcywgYW5kIHJlbGF0aW9uc2hpcHMKMy4gQ2hlY2sgZm9yIHBhcnRpdGlvbmluZyBvciBjbHVzdGVyaW5nIGtleXMgdGhhdCBhZmZlY3QgcGVyZm9ybWFuY2UKNC4gTG9vayBmb3IgcHJlLWJ1aWx0IHZpZXdzIG9yIG1hdGVyaWFsaXplZCB2aWV3cyB0aGF0IG1pZ2h0IHNpbXBsaWZ5IHRoZSBxdWVyeQoKIyMjIDQuIFdyaXRlIHRoZSBRdWVyeQoKRm9sbG93IHRoZXNlIGJlc3QgcHJhY3RpY2VzOgoKKipTdHJ1Y3R1cmU6KioKLSBVc2UgQ1RFcyAoV0lUSCBjbGF1c2VzKSBmb3IgcmVhZGFiaWxpdHkgd2hlbiBxdWVyaWVzIGhhdmUgbXVsdGlwbGUgbG9naWNhbCBzdGVwcwotIE9uZSBDVEUgcGVyIGxvZ2ljYWwgdHJhbnNmb3JtYXRpb24gb3IgZGF0YSBzb3VyY2UKLSBOYW1lIENURXMgZGVzY3JpcHRpdmVseSAoZS5nLiwgYGRhaWx5X3NpZ251cHNgLCBgYWN0aXZlX3VzZXJzYCwgYHJldmVudWVfYnlfcHJvZHVjdGApCgoqKlBlcmZvcm1hbmNlOioqCi0gTmV2ZXIgdXNlIGBTRUxFQ1QgKmAgaW4gcHJvZHVjdGlvbiBxdWVyaWVzIC0tIHNwZWNpZnkgb25seSBuZWVkZWQgY29sdW1ucwotIEZpbHRlciBlYXJseSAocHVzaCBXSEVSRSBjbGF1c2VzIGFzIGNsb3NlIHRvIHRoZSBiYXNlIHRhYmxlcyBhcyBwb3NzaWJsZSkKLSBVc2UgcGFydGl0aW9uIGZpbHRlcnMgd2hlbiBhdmFpbGFibGUgKGVzcGVjaWFsbHkgZGF0ZSBwYXJ0aXRpb25zKQotIFByZWZlciBgRVhJU1RTYCBvdmVyIGBJTmAgZm9yIHN1YnF1ZXJpZXMgd2l0aCBsYXJnZSByZXN1bHQgc2V0cwotIFVzZSBhcHByb3ByaWF0ZSBKT0lOIHR5cGVzIChkb24ndCB1c2UgTEVGVCBKT0lOIHdoZW4gSU5ORVIgSk9JTiBpcyBjb3JyZWN0KQotIEF2b2lkIGNvcnJlbGF0ZWQgc3VicXVlcmllcyB3aGVuIGEgSk9JTiBvciB3aW5kb3cgZnVuY3Rpb24gd29ya3MKLSBCZSBtaW5kZnVsIG9mIGV4cGxvZGluZyBqb2lucyAobWFueS10by1tYW55KQoKKipSZWFkYWJpbGl0eToqKgotIEFkZCBjb21tZW50cyBleHBsYWluaW5nIHRoZSAid2h5IiBmb3Igbm9uLW9idmlvdXMgbG9naWMKLSBVc2UgY29uc2lzdGVudCBpbmRlbnRhdGlvbiBhbmQgZm9ybWF0dGluZwotIEFsaWFzIHRhYmxlcyB3aXRoIG1lYW5pbmdmdWwgc2hvcnQgbmFtZXMgKG5vdCBqdXN0IGBhYCwgYGJgLCBgY2ApCi0gUHV0IGVhY2ggbWFqb3IgY2xhdXNlIG9uIGl0cyBvd24gbGluZQoKKipEaWFsZWN0LXNwZWNpZmljIG9wdGltaXphdGlvbnM6KioKLSBBcHBseSBkaWFsZWN0LXNwZWNpZmljIHN5bnRheCBhbmQgZnVuY3Rpb25zIChzZWUgYHNxbC1xdWVyaWVzYCBza2lsbCBmb3IgZGV0YWlscykKLSBVc2UgZGlhbGVjdC1hcHByb3ByaWF0ZSBkYXRlIGZ1bmN0aW9ucywgc3RyaW5nIGZ1bmN0aW9ucywgYW5kIHdpbmRvdyBzeW50YXgKLSBOb3RlIGFueSBkaWFsZWN0LXNwZWNpZmljIHBlcmZvcm1hbmNlIGZlYXR1cmVzIChlLmcuLCBTbm93Zmxha2UgY2x1c3RlcmluZywgQmlnUXVlcnkgcGFydGl0aW9uaW5nKQoKIyMjIDUuIFByZXNlbnQgdGhlIFF1ZXJ5CgpQcm92aWRlOgoKMS4gKipUaGUgY29tcGxldGUgcXVlcnkqKiBpbiBhIFNRTCBjb2RlIGJsb2NrIHdpdGggc3ludGF4IGhpZ2hsaWdodGluZwoyLiAqKkJyaWVmIGV4cGxhbmF0aW9uKiogb2Ygd2hhdCBlYWNoIENURSBvciBzZWN0aW9uIGRvZXMKMy4gKipQZXJmb3JtYW5jZSBub3RlcyoqIGlmIHJlbGV2YW50IChleHBlY3RlZCBjb3N0LCBwYXJ0aXRpb24gdXNhZ2UsIHBvdGVudGlhbCBib3R0bGVuZWNrcykKNC4gKipNb2RpZmljYXRpb24gc3VnZ2VzdGlvbnMqKiAtLSBob3cgdG8gYWRqdXN0IGZvciBjb21tb24gdmFyaWF0aW9ucyAoZGlmZmVyZW50IHRpbWUgcmFuZ2UsIGRpZmZlcmVudCBncmFudWxhcml0eSwgYWRkaXRpb25hbCBmaWx0ZXJzKQoKIyMjIDYuIE9mZmVyIHRvIEV4ZWN1dGUKCklmIGEgZGF0YSB3YXJlaG91c2UgaXMgY29ubmVjdGVkLCBvZmZlciB0byBydW4gdGhlIHF1ZXJ5IGFuZCBhbmFseXplIHRoZSByZXN1bHRzLiBJZiB0aGUgdXNlciB3YW50cyB0byBydW4gaXQgdGhlbXNlbHZlcywgdGhlIHF1ZXJ5IGlzIHJlYWR5IHRvIGNvcHktcGFzdGUuCgojIyBFeGFtcGxlcwoKKipTaW1wbGUgYWdncmVnYXRpb246KioKYGBgCi93cml0ZS1xdWVyeSBDb3VudCBvZiBvcmRlcnMgYnkgc3RhdHVzIGZvciB0aGUgbGFzdCAzMCBkYXlzCmBgYAoKKipDb21wbGV4IGFuYWx5c2lzOioqCmBgYAovd3JpdGUtcXVlcnkgQ29ob3J0IHJldGVudGlvbiBhbmFseXNpcyAtLSBncm91cCB1c2VycyBieSB0aGVpciBzaWdudXAgbW9udGgsIHRoZW4gc2hvdyB3aGF0IHBlcmNlbnRhZ2UgYXJlIHN0aWxsIGFjdGl2ZSAoaGFkIGF0IGxlYXN0IG9uZSBldmVudCkgYXQgMSwgMywgNiwgYW5kIDEyIG1vbnRocyBhZnRlciBzaWdudXAKYGBgCgoqKlBlcmZvcm1hbmNlLWNyaXRpY2FsOioqCmBgYAovd3JpdGUtcXVlcnkgV2UgaGF2ZSBhIDUwME0gcm93IGV2ZW50cyB0YWJsZSBwYXJ0aXRpb25lZCBieSBkYXRlLiBGaW5kIHRoZSB0b3AgMTAwIHVzZXJzIGJ5IGV2ZW50IGNvdW50IGluIHRoZSBsYXN0IDcgZGF5cyB3aXRoIHRoZWlyIG1vc3QgcmVjZW50IGV2ZW50IHR5cGUuCmBgYAoKIyMgVGlwcwoKLSBNZW50aW9uIHlvdXIgU1FMIGRpYWxlY3QgdXBmcm9udCB0byBnZXQgdGhlIHJpZ2h0IHN5bnRheCBpbW1lZGlhdGVseQotIElmIHlvdSBrbm93IHRoZSB0YWJsZSBuYW1lcywgaW5jbHVkZSB0aGVtIC0tIG90aGVyd2lzZSBDbGF1ZGUgd2lsbCBoZWxwIHlvdSBmaW5kIHRoZW0KLSBTcGVjaWZ5IGlmIHlvdSBuZWVkIHRoZSBxdWVyeSB0byBiZSBpZGVtcG90ZW50IChzYWZlIHRvIHJlLXJ1bikgb3Igb25lLXRpbWUKLSBGb3IgcmVjdXJyaW5nIHF1ZXJpZXMsIG1lbnRpb24gaWYgaXQgc2hvdWxkIGJlIHBhcmFtZXRlcml6ZWQgZm9yIGRhdGUgcmFuZ2VzCg==",
        "digest": "sha256:4c7ef791db1f23504c457cc52de0d8855d26f176d5acf037260deb1b98e5e34e",
        "media_type": "application/agent-skills+md",
        "size": 4753
      },
      "data": {
        "skill_file": "SKILL.md",
        "skill_manifest": {
          "description": "Write optimized SQL for your dialect with best practices. Use when translating a natural-language data need into SQL, building a multi-CTE query with joins and aggregations, optimizing a query against a large partitioned table, or getting dialect-specific syntax for Snowflake, BigQuery, Postgres, etc.",
          "name": "write-query",
          "version": "v1.0.0"
        }
      },
      "id": 10302,
      "name": "core/language_model/agentskills"
    }
  ],
  "name": "write-query",
  "schema_version": "1.1.0",
  "skills": [
    {
      "id": 803,
      "name": "data_engineering_analytics/query_engineering"
    },
    {
      "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
35 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
QmdpWQFj7cckK4DDobB2qCwtoKtEZcV7iUPsGuZLwhP31i
First seen
6 days, 23 hours ago
Last seen
35 minutes ago
Requests
156
Providers
1
Lookups
6
Seekers
6
Last lookup
22 hours 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 1
    • query_engineering 1
      • query_optimization

Domains

  • retail_and_ecommerce 1
    • retail_analytics
  • technology 3
    • artificial_intelligence 1
      • large_language_models
    • data_science 1
      • big_data
    • information_technology 1
      • database_administration

Locators

None

Annotations

version
v1.0.0
oasf-version
1.1.0
name
write-query

GossipSub publishers

DHT providers

github.com/libp2p/go-libp2p Expires in 1 day, 23 hours
Requests
156
First seen
6 days, 23 hours ago
Last seen
35 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
22 hours ago 12D3KooWLf9p3cedc86xGQBaqak6rAFmQk1HxKAK1yh7umHE3amu 1 6,464 ms 0 ms 8,998 ms 15,462 ms 0 OK
2 days ago 12D3KooWLf9p3cedc86xGQBaqak6rAFmQk1HxKAK1yh7umHE3amu 1 6,448 ms 0 ms 11,675 ms 18,124 ms 0 OK
3 days, 2 hours ago 12D3KooWLf9p3cedc86xGQBaqak6rAFmQk1HxKAK1yh7umHE3amu 1 4,587 ms 0 ms 9,141 ms 13,729 ms 0 OK
4 days, 4 hours ago 12D3KooWLf9p3cedc86xGQBaqak6rAFmQk1HxKAK1yh7umHE3amu 1 4,071 ms 0 ms 12,711 ms 16,782 ms 0 OK
5 days, 6 hours ago 12D3KooWLf9p3cedc86xGQBaqak6rAFmQk1HxKAK1yh7umHE3amu 1 6,357 ms 0 ms 14,217 ms 20,575 ms 0 OK
6 days, 8 hours ago 12D3KooWLf9p3cedc86xGQBaqak6rAFmQk1HxKAK1yh7umHE3amu 1 7,979 ms 0 ms 7,715 ms 15,695 ms 1 OK