built an ai tool that creates a dune dashboard for any smart contract
▲ 5 r/solidity+2 crossposts

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

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 automatically generates a Dune dashboard.

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

u/Phitrone — 2 days ago

Built something to help car owners

There have been scenarios where we face some random issues in car, want to understand things from technical aspect before taking actions based on service stations.

Most of the information is present in the car’s owner manual which is kinda not very easy to navigate.

We do have AI products but problem they are general purpose solution might mot be able to help with model specific issues.

Built a RAG based app where the car’s owner manual is source of truth and people can query their questions on the same

As PoC built it for virtus as german cars have been always tricky

Link in the comments to try

Feel free to give it a try and let me know how it works out

Open to feedback or suggestions

reddit.com
u/Phitrone — 1 month ago

Finally that pain went away

This started in May 2025 when I was in gym doing a stretch and I felt a striking pain in my right leg, that settled and I continued with normal life but after 2-3 says I started feeling the pain in leg whenever I used to sit, this went for a week finally visited the neuro he asked for MRI and it showed mid disc bulge in L4-L5. Things felt bad and kinda affected me mentally, gave me 2-3 exercises which I did for a month and things improved I felt I have recovered and got lazy and skipped the exercises, there was slight pain but it was manageable thought will get better with time.

I was wrong, after few days same thing started same radiating pain whenever I used to sit, by time kinda left it to get better with time but it remained the same way, main hiccup from my side not visited any physio and also didn’t do exercises.

Then came December, somehow I got mild pneumonia and started coughing very hardly and had to take a rest for a week or so, very few movement and vigorously coughing, something happened pain kinda worsened like 10x now even a min is unbearable while sitting. This got me very anxious and this kinda pushed me to visit physio.

PT-1 ( reputed hospital in my city)
Gave them full details regarding the cause and how it has been they recommended it will take a month to recover. They mentioned robotic spinal decompression along with TENS and IFT. I went for 3-4 days things seema to recover and saw a ray of hope but after it they introduced some stretches like knee-to-chest which kinda increased the pain. I thought it will be fine after 2-3 sessions but it become worse now I have introduced tingling sensation and shocks kind of feeling in the feet.

Decided to change the PT based on the stories from people here

PT2 ( private practitioner with his own clinic)
Same gave them full details regarding the pain and the recent experience with the PT-1.
He checks for some motion and strength in the glutes on the very first day mentioned there are chances that your spinal injury have healed but the muscles guarding for so long have been tight and griping on the nerve, I went for 3 days did some exercises and then he used to like work on strengthening muscles of glute by day 5 it felt like 90% of pain has gone and by 10th day I was pain free.

That’s how it worked out for me, I think exercise and right PT is the way out of it and continuous movement should be present in lifestyle.

You can surely conquer it do not loose hope

reddit.com
u/Phitrone — 1 month ago