- Announcements
- 1,125
- Messages
- 1,125
- Relayers
- 1
- Avg. size
- 527 B
- First seen
- 4 weeks, 2 days ago
- Last seen
- 35 minutes ago
- Topics
- dir/labels/v1
AGNTCY monitoring is a work in progress. Send your feedback to
[email protected].
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
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
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
- 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 |