{"id":"003d9ece-81e8-4c15-842a-5389ff2f412b","slug":"lz-web3-dune-analytics-api-skills","name":"dune-analytics-api","description":"Dune Analytics API for blockchain data queries. Use for: (1) Discovering tables and inspecting schemas, (2) Executing/refreshing Dune queries, (3) SQL query optimization for Solana/EVM chains, (4) Understanding dex.trades vs dex_aggregator.trades, (5) Working with Solana transactions and log parsing, (6) Managing query parameters and results, (7) Uploading CSV/NDJSON data to Dune tables. Triggers on: Dune query, blockchain data, DEX trades, Solana transactions, on-chain analytics, query optimization, data upload, CSV upload, table discovery, find table, schema inspection.","canonicalUrl":"https://xpersona.co/skill/lz-web3-dune-analytics-api-skills","sourceUrl":"https://github.com/LZ-Web3/dune-analytics-api-skills","homepage":"https://github.com/LZ-Web3/dune-analytics-api-skills","source":"GITHUB_OPENCLEW","vendor":{"slug":"lz-web3","label":"Lz Web3","url":"https://github.com/LZ-Web3/dune-analytics-api-skills"},"protocols":["OPENCLEW"],"capabilities":["append"],"trustScore":null,"trustConfidence":"unknown","artifactCount":0,"benchmarkCount":0,"lastRelease":null,"freshnessAt":"2026-02-24T19:44:05.008Z","freshnessLabel":"Feb 24, 2026","securityReviewed":true,"openapiReady":false,"stats":[{"label":"Trust score","value":"Unknown"},{"label":"Compatibility","value":"OpenClaw"},{"label":"Freshness","value":"Feb 24, 2026"},{"label":"Vendor","value":"Lz Web3"},{"label":"Artifacts","value":"0"},{"label":"Benchmarks","value":"0"},{"label":"Last release","value":"Unpublished"}],"factsPreview":[{"factKey":"docs_crawl","category":"integration","label":"Crawlable docs","value":"6 indexed pages on the official domain","href":"https://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fopenclaw%2Fskills%2Ftree%2Fmain%2Fskills%2Fasleep123%2Fcaldav-calendar","sourceUrl":"https://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fopenclaw%2Fskills%2Ftree%2Fmain%2Fskills%2Fasleep123%2Fcaldav-calendar","sourceType":"search_document","confidence":"medium","observedAt":"2026-04-15T05:03:46.393Z","isPublic":true},{"factKey":"vendor","category":"vendor","label":"Vendor","value":"Lz Web3","href":"https://github.com/LZ-Web3/dune-analytics-api-skills","sourceUrl":"https://github.com/LZ-Web3/dune-analytics-api-skills","sourceType":"profile","confidence":"medium","observedAt":"2026-02-24T19:44:06.023Z","isPublic":true},{"factKey":"protocols","category":"compatibility","label":"Protocol compatibility","value":"OpenClaw","href":"https://xpersona.co/api/v1/agents/lz-web3-dune-analytics-api-skills/contract","sourceUrl":"https://xpersona.co/api/v1/agents/lz-web3-dune-analytics-api-skills/contract","sourceType":"contract","confidence":"medium","observedAt":"2026-02-24T19:44:06.023Z","isPublic":true},{"factKey":"traction","category":"adoption","label":"Adoption signal","value":"1 GitHub stars","href":"https://github.com/LZ-Web3/dune-analytics-api-skills","sourceUrl":"https://github.com/LZ-Web3/dune-analytics-api-skills","sourceType":"profile","confidence":"medium","observedAt":"2026-02-24T19:44:06.023Z","isPublic":true},{"factKey":"handshake_status","category":"security","label":"Handshake status","value":"UNKNOWN","href":"https://xpersona.co/api/v1/agents/lz-web3-dune-analytics-api-skills/trust","sourceUrl":"https://xpersona.co/api/v1/agents/lz-web3-dune-analytics-api-skills/trust","sourceType":"trust","confidence":"medium","observedAt":null,"isPublic":true}],"highlights":["1 GitHub stars","Trust evidence available"],"agentCard":{"name":"dune-analytics-api","description":"Dune Analytics API for blockchain data queries. Use for: (1) Discovering tables and inspecting schemas, (2) Executing/refreshing Dune queries, (3) SQL query optimization for Solana/EVM chains, (4) Understanding dex.trades vs dex_aggregator.trades, (5) Working with Solana transactions and log parsing, (6) Managing query parameters and results, (7) Uploading CSV/NDJSON data to Dune tables. Triggers on: Dune query, blockchain data, DEX trades, Solana transactions, on-chain analytics, query optimization, data upload, CSV upload, table discovery, find table, schema inspection.","source":"GITHUB_OPENCLEW","sourceId":"github:1159007224","homepage":"https://github.com/LZ-Web3/dune-analytics-api-skills","repository":"https://github.com/LZ-Web3/dune-analytics-api-skills","documentation":"https://xpersona.co/skill/lz-web3-dune-analytics-api-skills/agent/lz-web3-dune-analytics-api-skills","protocols":["OPENCLEW"],"capabilities":["append"],"languages":["typescript"],"install":{"command":"git clone https://github.com/LZ-Web3/dune-analytics-api-skills.git","ecosystem":"git"},"examples":[{"kind":"example","language":"bash","snippet":"pip install dune-client"},{"kind":"example","language":"python","snippet":"from dune_client.client import DuneClient\nfrom dune_client.query import QueryBase\nimport os\n\nclient = DuneClient(api_key=os.environ['DUNE_API_KEY'])\n\n# Execute a query\nresult = client.run_query(query=QueryBase(query_id=123456), performance='medium', ping_frequency=5)\nprint(f\"Rows: {len(result.result.rows)}\")\n\n# Get cached result (no re-execution)\nresult = client.get_latest_result(query_id=123456)\n\n# Get/update SQL\nsql = client.get_query(123456).sql\nclient.update_query(query_id=123456, query_sql=\"SELECT ...\")\n\n# Upload CSV data (quick, overwrites existing)\nclient.upload_csv(\n    data=\"col1,col2\\nval1,val2\",\n    description=\"My data\",\n    table_name=\"my_table\",\n    is_private=True\n)\n\n# Create table + insert (supports append)\nclient.create_table(\n    namespace=\"my_user\",\n    table_name=\"my_table\",\n    schema=[{\"name\": \"col1\", \"type\": \"varchar\"}, {\"name\": \"col2\", \"type\": \"double\"}],\n    is_private=True\n)\nimport io\nclient.insert_data(\n    namespace=\"my_user\",\n    table_name=\"my_table\",\n    data=io.BytesIO(b\"col1,col2\\nabc,1.5\"),\n    content_type=\"text/csv\"\n)"}]}}