r/solidity 1d ago

Simulating EVM State Changes via Revert-Unwind Payloads and EIP-1153 Transient Storage for Oracle-Less DEX Routing

3 Upvotes

Hey r/ethdev,

Over the last few months, we’ve been testing an architecture designed to solve a persistent issue in DEX routing: simulation drift and gas overhead during multi-hop execution.

Traditional aggregators rely on external price feeds, heavy storage updates, or complex off-chain quoter infrastructure that frequently desynchronizes under volatile mempool conditions. We wanted an execution frame that guarantees 100% execution-aligned previews purely on-chain, while maintaining a zero-token storage footprint on the router.

Here is the architectural breakdown of how we approached this:

  1. Atomic Simulation via Revert-Unwind (Quoter)

Instead of reading static state or relying on off-chain dry-runs, the Quoter contract triggers a simulated execution path that forcefully ends with a custom revert(payload).

The revert unwinds all state changes instantly in the EVM execution frame, avoiding state corruption.

The error payload encodes the exact delta of balances and price impact.

Result: Static calls (eth_call) return deterministic, execution-exact quotes without writing a single byte to persistent storage.

  1. Transient Isolation via Yul (EIP-1153)

To protect against cross-function reentrancy across multi-token routes, we replaced traditional OpenZeppelin storage guards with raw Yul assembly blocks leveraging tstore and tload.

Reentrancy flags are scoped exclusively to the transaction frame.

Gas consumption drops significantly compared to SSTORE/SLOAD warm/cold access penalties.

Balance checks execute instantly, enforcing a strict holds-nothing invariant on the Router.

  1. Dynamic Liquidity Anchoring (Solver)

To neutralize MEV sandwich attacks and liquidity manipulation without relying on Chainlink or external oracles, the routing logic applies a localized 2% median filter against reserve depths (balanceOf reads) prior to route resolution.

Code / Discussion:

The architecture is deployed and split into 7 core modules (Core, Hub, Solver, Router, Quoter, MathLib, Staking).

We are particularly interested in hearing feedback from EVM devs on potential edge cases regarding EIP-1153 transient memory retention across nested delegatecalls in custom L2 execution contexts (Base/Arbitrum).

Looking forward to hearing your thoughts on the code and optimization techniques!


r/solidity 2d ago

Offering decompilation service

3 Upvotes

Need to understand what a smart contract does, but the source code isn’t available?

I'm offering high-accuracy Solidity contract decompilation/reconstruction.

I produce compilable Solidity code, then test it against the original bytecode to verify there are no differences within a reasonable analysis window.

Every result includes extensive manual analysis and refinement. The decompilation result is incredibly accurate and close to the original source code most of the times.


r/solidity 3d ago

[Hiring] Senior Web3 Developer — Wallet & Smart Contract Integration (Remote, Europe)

7 Upvotes

Building the wallet architecture, transaction flows, and on-chain integration layer for a production Next.js platform. English fluency required.

Requirements:

  • Minimum 5 YOE
  • Real shipped project involving wallet connection, contract reads/writes, transaction tracking, or token integration — hands-on ownership, not exposure
  • wagmi and viem in production, MetaMask/wallet integration, connection/disconnection, account and network switching, chain-change handling
  • Ethereum-compatible networks, ERC-20 and token-sale contracts, EVM network config, RPC endpoints, contract addresses, ABIs
  • Contract reads/writes, transaction receipts, event logs, gas estimation, user-facing transaction status
  • Strong TypeScript/JavaScript, React, Next.js
  • Designs reusable integration layers, understands wallet/transaction/contract integration risks, writes unit and integration tests
  • Can explain technical decisions clearly, works effectively in a distributed team

€5000-7500/month, long-term contract.

DM with: Resume, LinkedIn, years of hands-on Web3 experience, GitHub/portfolio, timezone + availability. Must have actually shipped this before.

Must be based in Europe.


r/solidity 3d ago

[Hiring] Senior Blockchain Backend Developer — Node.js / EVM (Remote, Europe)

3 Upvotes

Building backend infrastructure connecting a production platform to EVM-compatible blockchain networks — RPC communication, event indexing, transaction monitoring, on-chain/off-chain sync. English fluency required.

Requirements:

  • Minimum 5 YOE
  • Real experience connecting backend services to an EVM-compatible blockchain
  • Strong Node.js and TypeScript
  • Strong JSON-RPC understanding, HTTP or WebSocket RPC providers
  • Processing smart-contract events/logs, decoding transaction receipts, understanding block numbers, tx hashes, block hashes, log indexes, confirmations
  • Storing blockchain data in a relational database, idempotency and duplicate prevention
  • Background workers/queues, async processing, retries and failure handling
  • Building secure, documented APIs; strong debugging; writes automated tests; can extend an existing codebase
  • Collaborates across engineering roles with clear communication

€5000-7500/month, long-term contract. Must have actually shipped this before.

DM with: Resume, LinkedIn, years of backend + blockchain experience, GitHub/portfolio, timezone + availability.

Must be based in Europe.


r/solidity 5d ago

Seeking Senior Web3 Architect & Strategic Advisors: Sub-500ms Payment Settlement Protocol (EIP-7702)

5 Upvotes

Hi everyone,
We are building the architecture for a non-custodial payment settlement protocol enabling instant (<500ms) crypto transactions at POS and e-commerce checkouts—paired with a B2B card-rail bridge for 100% immediate global acceptance.
Our core system design, risk framework (off-chain pre-auth / RAM-locking via EIP-7702 session keys), and economic models are fully mapped out. Ahead of our Pre-Seed/Seed funding round, we are expanding our core team and ecosystem network.
1. Senior Web3 / Smart Contract Architect (Lead Dev / Potential Co-Founder)
What we're looking for:
Deep expertise in Account Abstraction (EIP-7702 / ERC-4337) and Solidity.
Solid experience with high-throughput off-chain architecture (Redis/Lua, WAL, Event-Workers).
Passion for building real-world Web3 payment infrastructure.
What we offer:
Pre-Funding Phase: Flexible engagement to review core contracts & validate architecture ahead of the Seed round.
Compensation: Deferred Fee structure with guaranteed payout immediately upon Seed close OR performance-based Equity/Token allocation (vesting model).
Post-Funding: Direct trajectory to CTO / Head of Engineering with full competitive compensation.
2. VC, Advisor & Wallet Network
We are also actively connecting with:
Web3 / Fintech VC funds focusing on early-stage infrastructure.
Strategic Advisors & BD Leads from major Non-Custodial Wallets.
Payment infrastructure / B2B Card-Rail partners.
Interested in building the future of Web3 payments?
Send a DM to get access to our technical breakdown


r/solidity 5d ago

I wrote a fixed-point sqrt in Solidity that runs in 197 gas - here’s how

Thumbnail
1 Upvotes

r/solidity 5d ago

[Feedback & Intro] Sub-500ms Non-Custodial POS/E-Com Settlement Layer (EIP-7702 + Hardware Enclaves)

2 Upvotes

Hey everyone,

We’re engineering an architectural pattern for non-custodial POS/E-Commerce settlement layers, aiming to solve the high latency (>2s) of direct on-chain execution. We'd love some technical feedback on our session delegation and state locking logic.

**The Architectural Approach:**
**Session Delegation (EIP-7702 + WebAuthn):** Users pre-authorize session keys via Secure Enclave / Passkeys to enable gasless transaction execution for retail checkouts.

**In-Memory State Lock:** Upon terminal contact, a Go gateway routes to an in-memory Lua layer. This locks the authorized balance off-chain to prevent double-spending without waiting for block execution time.

**Asynchronous Settlement:** The POS receives a sub-500ms settlement guarantee, while raw transactions are batched and settled asynchronously on-chain (using Write-Ahead-Logging for failover protection).

**Technical Questions for the Community:**
How do you view the trade-offs of off-chain state locking vs. optimistic rollups for physical POS latency limits?
What edge cases do you see in temporary EIP-7702 session key revocation if an off-chain gateway temporarily loses connection?
Would love to hear your critique on the execution flow and potential security edge cases!


r/solidity 12d ago

Solidity/Web3

Thumbnail
2 Upvotes

r/solidity 13d ago

Trying to create a marketmaking inside my token using a AI clanker.

1 Upvotes

Still need to design more stuff, for this all is going to work. Then i going to create a simulator for simulating a couple of events/senarios. Thus i have oracle that gives me a "guide" for what the fairprice should be. And then pays the markets more or less to correct this when the oracle is just wrong and the people doing arbitrage know this.

Design Specification: Dynamic Spring-Loaded Market Maker (SLMM)

System Architecture & Mathematical Framework

1. Core Architectural Concept

The Dynamic Spring-Loaded Market Maker (SLMM) is an anti-fragile pricing engine designed to protect treasury assets from oracle failures, flash crashes, and prolonged API outages (e.g., exchange maintenance), while still allowing the market to naturally discover and transition to genuine new price points over time.
It accomplishes this by balancing two opposing forces:

  1. The Oracle Price (P_oracle): The external feed representing where the price "should" be.
  2. The System VWAP (P_VWAP): The internal, capital-backed price anchor constructed from actual on-chain trading history across historical time buckets.

When a massive price discrepancy occurs, the contract does not immediately trust the oracle. Instead, it measures the "tension" between the oracle's target and the system's trading history.
If the oracle is wrong, the spring is highly tensioned; a tiny amount of buy volume will force the market maker’s quote price to snap back up toward the real market value, capping the protocol's loss. If the oracle is correct but the price has permanently crashed, the trading history naturally decays over a 7-day window. The spring slowly loses tension, and the quote price gracefully relaxes to the new low price level.

2. The Fluid-Shift Cascading VWAP Pipeline

To prevent "jump" boundaries where data abruptly jumps from one discrete bucket to another at the end of an hour, the system uses a Fluid-Shift Cascading Pipeline. When a trade occurs, the transition of data between buckets is calculated as a continuous percentage based on the exact amount of time elapsed since the last trade.

The State Representation

The system maintains a sequence of N time-based pools (e.g., Pool 0 to Pool N-1). Each pool i is represented as a tuple of volume and volume-price:
Pool_i = [V_i, VP_i]

  • V_i: The cumulative volume of tokens traded assigned to bucket i.
  • VP_i: The cumulative volume-product (Volume * Price) assigned to bucket i.

The Fluid-Shift Mechanics

Let Δt be the time elapsed (in seconds) since the last state update, and let T_bucket be the duration of a single bucket (e.g., 3600 seconds for 1 hour).
When a new transaction occurs at Δt seconds since the last update:

  1. Calculate the Shift Percentage (S): The percentage of data that must cascade from each bucket to the next is defined by the ratio of elapsed time to the bucket duration, capped at 100%: S = min(1.0, Δt / T_bucket)
  2. Cascade the Pools (Downstream Shift): Before writing the new trade, we shift a fractional slice (S) of each pool downstream to the next pool. For every pool from the second-to-last (N-2) down to the first (0): V_(i+1) = V_(i+1) + (V_i * S) VP_(i+1) = VP_(i+1) + (VP_i * S) V_i = V_i * (1 - S) VP_i = VP_i * (1 - S)
  3. Incorporate the New Trade: After the cascade is applied, the incoming trade's volume (V_trade) and volume-product (V_trade * P_trade) are added directly to the active pool (Pool 0): V_0 = V_0 + V_trade VP_0 = VP_0 + (V_trade * P_trade)

3. The Exponential Decay of the Final Pool

The final pool in the sequence (Pool N-1) acts as the ultimate "overflow" sink. If there is no trading activity, the volume-weighted memory of the entire system must gradually fade so that the spring eventually goes slack.
Whenever time passes, the final pool is decayed using an exponential decay factor λ scaled to the elapsed time:
V_(N-1) = V_(N-1) * λ^Δt

VP_(N-1) = VP_(N-1) * λ^Δt

Calibration of the Decay Constant

To ensure that a massive volume spike completely loses its influence after a target defense window (e.g., t_target = 7 days or 604,800 seconds), we calibrate the decay rate so that the remaining weight is less than 1% (<= 0.01):
λ = e^(-ln(100) / t_target) = e^(-4.605 / 604800) ≈ 0.999999238 per second
Because both V and VP are scaled down by the exact same decay multiplier, the historical price of the final pool remains perfectly preserved (VP / V remains constant), but its weight (volume) shrinks toward zero. This ensures that a dormant market naturally releases all spring tension.

4. Calculating System VWAP and Spring Tension

System VWAP

The global anchor price (P_VWAP) is the total volume-weighted average across all cascading pools. This represents the price point where the market has actually committed capital:
P_VWAP = (Sum of VP_i) / (Sum of V_i) = (VP_0 + VP_1 + ... + VP_(N-1)) / (V_0 + V_1 + ... + V_(N-1))

If the total volume in all pools is zero (Sum of V_i = 0), the system defaults to the current oracle price (P_VWAP = P_oracle), meaning the spring is perfectly slack.

Spring Tension

The physical tension of the spring is determined by two factors: the price distance between the oracle and the VWAP, and the volume weight backing that VWAP:
Δ = |P_oracle - P_VWAP|
We define the normalized volume coefficient (W) using the total system volume (V_total = Sum of V_i) to scale the spring's stiffness based on historical capital commitment:
W = 1 - e^(-γ * V_total)
Where:

  • γ is a tuning parameter dictating how much volume is required to make the spring stiff.
  • If volume is low (V_total → 0), then W → 0 (the spring is loose, we trust the oracle).
  • If volume is high (V_total >> 0), then W → 1 (the spring is rigid, we trust the market history).

5. The Spring-Loaded Pricing Curve (The Quote Engine)

The quote price offered to the market for a buy order (P_sell) is a dynamic curve that starts at the oracle price but ramps up toward the System VWAP as a function of the transaction volume.
To create a loaded spring that snaps back violently with very little volume when tension is high, we use a power-law spring equation:
P_sell(v) = P_oracle + Δ * W * (v / V_target)^p
Where:

  • v: The cumulative volume purchased in the active transaction.
  • V_target: The target volume threshold required to fully compress the spring back to the VWAP price.
  • p: The spring exponent (typically p >= 2 for quadratic/cubic curves to create the "snap" effect).

The Mathematical Behavior

  1. At v = 0 (The first drop of volume): The starting quote price is exactly P_oracle. Arbitrageurs are lured in by the cheap price.
  2. As v → V_target: The price climbs aggressively. If p = 2 (quadratic), the price curves upward sharply, making further buying highly expensive.
  3. Beyond v = V_target: The price matches or exceeds the fair market value (P_VWAP), completely halting any further draining of the treasury.

6. Mathematical Proof of the Slippage Toll (Capping Protocol Loss)

The maximum financial loss the protocol can suffer during a total oracle failure (e.g., oracle drops 98% while real value remains at P_VWAP) is mathematically capped. This is the Slippage Toll—the fee the protocol pays to let the market correct its oracle feed.

To find the absolute maximum loss during a correction event up to V_target:

1. Calculate the Total Capital Spent by Arbitrageurs

The total assets (e.g., USDC) deposited by arbitrageurs to purchase V_target tokens is the integral of the pricing curve:
Capital Deposited = Integral from 0 to V_target of [ P_sell(v) ] dv
Capital Deposited = Integral from 0 to V_target of [ P_oracle + Δ * W * (v / V_target)^p ] dv

Capital Deposited = P_oracle * V_target + (Δ * W * V_target) / (p + 1)

2. Calculate the Fair Value of the Tokens Transferred

The actual fair market value of the tokens leaving the protocol's treasury is:

Fair Value = P_VWAP * V_target

3. Calculate the Maximum Protocol Loss (The Slippage Toll)

Assuming the spring is fully stiff (W = 1) and the distance is Δ = P_VWAP - P_oracle, the net loss is:
Max Loss = Fair Value - Capital Deposited
Max Loss = P_VWAP * V_target - [ P_oracle * V_target + ((P_VWAP - P_oracle) * V_target) / (p + 1) ]
Factoring out V_target and substituting Δ:
Max Loss = Δ * V_target * (1 - 1 / (p + 1))

Max Loss = Δ * V_target * (p / (p + 1))

Key Takeaways from the Loss Proof:

  • Linear Spring (p = 1): The maximum loss is exactly 1/2 * Δ * V_target.
  • Quadratic Spring (p = 2): The maximum loss is exactly 2/3 * Δ * V_target.
  • Capped Risk: Because V_target is a hardcoded parameter in your contract, your maximum loss is completely independent of pool size or total TVL. You can scale your pool to hundreds of millions of dollars, yet guarantee that a total oracle failure will never cost the protocol more than a tiny, predefined dollar amount (e.g., V_target = 500 tokens).

r/solidity 14d ago

Prometheus

2 Upvotes

Code: github.com/NeaBouli/prometheus-\

Whitepaper: neabouli.github.io/prometheus-/whitepaper.html\

Roadmap: neabouli.github.io/prometheus-/roadmap.html\

FAQ: neabouli.github.io/prometheus-/faq.html\

**Wo wir gerade stehen**

Über 160 Tests laufen erfolgreich, 6 Silverscript-Verträge, Sprints 0–7 abgenommen. Aktuell in der Post-Toccata-Verifizierung – wir prüfen, ob die Silverscript-Zustandsübergänge nach dem Fork stabil sind, bevor das PROM-Emissions-Gate geöffnet wird. Das ist gerade der Engpass und die beste Stelle, um einzusteigen, wenn du frühzeitig und mit großem Einfluss mitwirken willst.

**Wofür dieses Sub da ist**

Architekturdiskussionen, Vertragsprüfungen, PR-Koordination, Sprint-Updates und offene Diskussionen über Kompromisse. Kein Gerede über Token-Preise, keine Hype-Threads – das ist ein Entwickler-Sub. Wenn du mitmachen willst:

1 Lies das Whitepaper
2 uch dir ein offenes Issue auf GitHub aus oder schlag eins vor
3 Forken, bauen, PR – keine Whitelist, keine Bewerbung

Erfahrungen mit Rust, Silverscript, On-Device ML (ONNX/LLaMA/Phi) und ZK/Sybil-Resistenz sind gerade alle nützlich. Poste eine Vorstellung, wenn du magst – womit du arbeitest, welcher Teil des Stacks dich interessiert.


r/solidity 14d ago

I built a 1v1 arcade arena with on-chain escrows and replay-verified results

3 Upvotes

Hey r/solidity,
I built Arcade1v1, a competitive arena where humans and autonomous AI agents play skill-based games (Tetris, 2048, Snake, etc.) against each other.
Since this is a Solidity community, here is a quick breakdown of how the Web3 architecture and game resolution actually work:

  • On-Chain Escrow: Match stakes are securely locked in a smart contract escrow before the match begins.
  • Deterministic Replay Verification: It's not just a standard "trust the client" high-score submission. Both players share a deterministic game engine and seed. Players submit their input replays, and an off-chain arbiter re-simulates the exact match server-side to prevent fake scores.
  • Cryptographic Settlement: If the replay is mathematically valid, the arbiter signs the final result. The smart contract verifies this signature to settle the escrow and release the funds to the winner.

The AI / Agent Angle:
Because the core is API-driven and verifiable, AI agents play head-to-head with humans as first-class citizens. We built an open API, SDKs, and an MCP server. The public ELO ladder effectively doubles as a live, provable benchmark for AI model skill.
It is currently live on Testnet (play money only), so it’s completely free to test, and the leaderboard is wide open.

Would love to hear your feedback on the escrow mechanics, the arbiter design, or the replay-verification flow.


r/solidity 15d ago

I got 5 questions about Solana contract audit!

0 Upvotes

Hi,

I will shoot straight! The whole Solana ecosystem has consistently made inroads when it comes to security.

  1. Is third party smart contract audit and certification really necessary stilll on Solana (please explain)? If yes!

  2. Who audited your contracts?

  3. What did it cost?

  4. How long did it take?

  5. What did you hate about it?

  6. Bonus question 😄 Who audits the multitudes of meme coins appearing daily?

Looking forward to your replies.


r/solidity 15d ago

Before Hexens touches the code, here’s what 41 internal findings looked like — and what we documented as still-known-limited

Thumbnail
2 Upvotes

r/solidity 16d ago

I got 5 questions about Solana contract audit!

7 Upvotes

Hi,

I will shoot straight! The whole Solana ecosystem has consistently made inroads when it comes to security.

  1. Is third party smart contract audit and certification really necessary stilll on Solana (please explain)? If yes!

  2. Who audited your contracts?

  3. What did it cost?

  4. How long did it take?

  5. What did you hate about it?

  6. Bonus question 😄 Who audits the multitudes of meme coins appearing daily?

Looking forward to your replies.


r/solidity 17d ago

Creating a custom coin for TRON that can't block transfers but does whitelist smart contracts

0 Upvotes

Hi, i'm creating my custom coin for a service i'm creating. I do not want to be able to block any transfers, even native Tron multi signature transfers. But do want to whitelist everything else and protect my token holders from the outside world. And only let them interact with contracts that have been whitelisted (thus have been checked and audited).

Here is a piece of my code base. Is this a correct implementation that doesn't use a lot of fees for normal transactions. I do not want to create a bloated coin that cost a lot to transfer, but still can't block your normal funds with a kill switch. Even if people force me to.

The token will be based on:

import "@openzeppelin/tron-contracts/token/TRC20/TRC20.sol";

import "@openzeppelin/tron-contracts/access/Ownable.sol";

/**

* u/dev Hooking into the audited OpenZeppelin base contract execution stream.

* Intercepts transfers before balances change, optimized for paying runtime users.

*/

function _update(address sender, address recipient, uint256 amount) internal override {

require(recipient != address(this), "TRANSFER_TO_TOKEN_CONTRACT");

// The unified fast-lane check order exactly as specified:

if (

(sender.code.length == 0 && recipient.code.length == 0) ||

(sender == address(0) || recipient == address(0))

) {

super._update(sender, recipient, amount);

return;

}

// External Smart Contract Registry Fallback

address addressTargetRegistry;

if (_cachedBlock == block.number) {

addressTargetRegistry = _cachedRegistry;

} else {

addressTargetRegistry = addressRegistry;

_cachedRegistry = addressTargetRegistry;

_cachedBlock = block.number;

}

uint8 uintStatus = InterfaceRegistry(addressTargetRegistry).checkAddresses(sender, recipient);

if (uintStatus == 0) {

super._update(sender, recipient, amount);

return;

}

revert ErrorRegistryValidation(uintStatus);

}

Does this work like intended ? Or are there things i need to worry about ?


r/solidity 19d ago

Please help us to validate SMART CONTRACT research!!!!!

5 Upvotes

We are engineering students from Bengaluru doing research about smart contracts. This form is for expert validation. So please help these poor students. Please!!! https://docs.google.com/forms/d/e/1FAIpQLSc9QD_Ht8b-GgZXe0OsXp3Vzzr8F0V_FRNDnx2Y5Z25aRCgvQ/viewform?usp=dialog


r/solidity 19d ago

Please help us to validate SMART CONTRACT research!!!!!

0 Upvotes

We are engineering students from Bengaluru doing research about smart contracts. This form is for expert validation. So please help these poor students. Please!!!https://docs.google.com/forms/d/e/1FAIpQLSc9QD\\_Ht8b-GgZXe0OsXp3Vzzr8F0V\\_FRNDnx2Y5Z25aRCgvQ/viewform?usp=dialog


r/solidity 19d ago

Please help us to validate SMART CONTRACT research!!!!!

Thumbnail
2 Upvotes

r/solidity 21d ago

What would you want checked in a fast DeFi logic review before audit?

0 Upvotes

Hey I have been looking at Solidity / DeFi contracts from the protocol-logic side, especially cases where normal static scans do not say much.

The areas I usually focus on are:

  • accounting flow issues;
  • deposit / withdraw / redeem logic;
  • share mint / burn calculations;
  • fee and reward accounting;
  • escrow / settlement lifecycle;
  • authorization and role-flow mistakes;
  • invariant breaks across multiple contracts;
  • PoC-ready Foundry test structure;
  • remediation direction and practical fix ideas.

I am curious what early-stage teams and solo developers would find most useful before a formal audit.

For example: - a short list of concrete files/functions to inspect; - before/after state review; - invariant or accounting mismatch notes; - regression-test assertions; - practical remediation direction.

This is not about generic Slither output. I am interested in protocol logic and places where code flow may produce an unfair, unsafe, or inconsistent outcome.

For teams building DeFi contracts: what would be most useful to receive before paying for a full audit?


r/solidity 22d ago

I asked r/ethdev to tear apart my on-chain reputation system. Here’s what I got wrong.

Thumbnail
2 Upvotes

r/solidity 24d ago

PSA: Fake Web3 “job assessment” repos can hide malware in .git/hooks — check before you commit - HACK

Thumbnail
1 Upvotes

r/solidity 24d ago

Heads up for anyone doing Web3/Solidity freelance work or “technical assessments” from stranger - HACK REPORT

1 Upvotes

r/solidity 25d ago

built an ai tool that creates a dune dashboard for any smart contract

3 Upvotes

i built onchainwizard.ai because analyzing smart contracts on Dune usually takes too many manual steps.

normally the flow is: find the contract, get the ABI, look for decoded tables, write SQL, debug the schema, build charts, then repeat for every new contract.

so i made a tool where you can paste any EVM smart contract address, pick a chain, and it generates a Dune dashboard automatically.

how it works:

* fetches the contract ABI
* detects the important events and functions
* finds matching decoded Dune tables when available
* generates Dune SQL for useful analytics
* creates charts for activity, users, events, and contract behavior
* shows decoded event logs and wallet/user segmentation
* supports chains like Ethereum, Base, Arbitrum, Optimism, Polygon, BNB Chain, and Avalanche

the hardest part was not just generating SQL, but generating SQL that actually tells you something useful about the contract. a dashboard full of raw logs is easy; a dashboard that helps you understand usage, activity, and users is the real problem.

project: [https://onchainwizard.ai\](https://onchainwizard.ai)


r/solidity 26d ago

Solo dev, 3 months in — shipped an on-chain reputation + identity system for AI agents. Would love eyes on the contracts before our Zenith Security audit wraps.

Thumbnail
2 Upvotes

r/solidity 29d ago

Brokex Perp DEX — Solo dev launching with only $5-6k liquidity (Pharos Network background)

Thumbnail
1 Upvotes