Soroban Contract Analytics
SCF #21 Activation Award Data Tool $30,000 View in SCF
Stellar Network Integration for No-Code Soroban Smart Contract Analytics & Visualization.
Team

reach_abhinav

Progress on Previous (Awarded) Submissions

  • We delved deep into the Stellar network, enhancing our understanding of its intricate connections with Soroban. 
  • We reevaluated our architecture to maximize its benefits for the Stellar community. 
  • We introduced a comprehensive Soroban smart contract overview and smart contract level dashboard to support the community better. 
  • Additionally, we dedicated substantial time to refine our deliverables and roadmap, aligning them with valuable feedback received.

Total Expected Roadmap

Total Cost to complete the  Project: $30,000

 
  • Product Overview:

DappLooker is a no-code powerful tool to empower the Stellar Network community by simplifying the understanding of Soroban smart contract data. It provides no-code analytics and visualization capabilities, enabling the creation of visually appealing explorers, charts, and dashboards. 

 
  • Vision and Objectives:

Our vision is to empower the Stellar community by simplifying data visualization for Soroban smart contracts and dApps using the DappLooker no-code tool. We aim to break down barriers for both technical and non-technical users, making analytics accessible, saving valuable time, and ultimately reducing costs.

 
  • Deliverables:
 

[Deliverable 1] - Integrate Stellar Testnet For Soroban deployed smart contract analytics - $18,000

[Deliverable 2] - Integrate Stellar Mainnet For Soroban deployed smart contract analytics - $12,000

  • We will organize Workshops to educate community for no-code smart contract analytics along with twitter space.
  • We will onboard Stellar network dApps and community for data driven analytics.

Entity Description

DappLooker leads the market in providing no-code affordable web3 analytics solutions backed by industry giants like Aave, TheGraph, Polygon, Connext, Uniswap, and more. The platform empowers users with analytics for 15+ networks, 350+ Dapps, and the ability to analyze data from over 350M+ on-chain users data. Sharing some resources below that might be of help: Website: https://dapplooker.com/home Customer KPIs: https://docs.google.com/presentation/d/1NoU8VDcJ6PhrVanDN_kqv6Mg95vKGnO44sKAmOAjzqg/edit#slide=id.g23eb3db0be6_0_0 Discover Page: https://dapplooker.com/browse/dashboards?sort=popular Docs: docs.dapplooker.com You can sign up using your wallet or email address : https://dapplooker.com/user/signup Register the subgraphs, smart contract from the Registration page: https://dapplooker.com/user/dashboard Demo Account Details Here's the demo account details which you can play around with. Website: https://dapplooker.com/login Email: help+sandbox@dapplooker.com Password: dapplooker123

Section

read

Product & Architecture

DappLooker is a powerful no-code analytics tool designed to assist the Stellar Network and its dApps, providing Soroban smart contract-level analytics.

 

The platform features a user-friendly visual SQL editor, making it accessible to both technical and non-technical users. Additionally, DappLooker will help in Soroban smart contract-level analytics, facilitating essential metric monitoring for the Stellar Network and its community, including KPIs like active users, unique users, token contracts, and daily/weekly/monthly transaction analysis.
 

Problem Solving and Benefits:

- Analytics & Accessibility: Smart contract data analytics is typically complex and requires technical expertise. DappLooker eliminates this barrier, enabling a broader audience, including developers, product managers, and marketing professionals, to perform analytics on the Soroban Smart Contracts deployed on Stellar testnet/mainnet data.


- Ease of Use: The platform simplifies smart contract data analytics & visualization, making it accessible to technical as well as non-technical users. Its visual SQL editor allows users to query, filter, join, and group multiple smart contract data with an advanced editor effortlessly.

- Community Empowerment: DappLooker empowers the Stellar community by providing tools to analyze Soroban smart contracts data deployed on Stellar testnet/mainnet, in one place.

- Visualization: Users can create a wide variety of charts, dashboards, and reports, making data more understandable and actionable.


- Collaboration: DappLooker enables users to collaborate, share, and export their analytics results, fostering a collaborative data-driven culture.


How It Works:
DappLooker seamlessly integrates with the Stellar Network, allowing easy registration of dApps and Soroban smart contracts deployed on Stellar testnet/mainnet for quick no-code analytics & visualization. The following features are available for the Stellar ecosystem and dApps:

- Easy Registration of Soroban Smart Contract: Users can register Soroban smart contracts deployed on Stellar testnet/mainnet by selecting them from the autocomplete.


- Browse Soroban smart Contract Dataset: Explore and browse Soroban smart contract data deployed onStellar testnet/mainnet in simple and intuitive tabular form.
- Automated Chart and Dashboard Building with X-Ray: Create charts and complete dashboards effortlessly with a single click using the DappLooker AI Engine.
- API & SDK Integration: Easily access Soroban smart contract data deployed on Stellar testnet/mainnet using API and SDK.
- Download Smart Soroban contract  Data: With just one click, you can download smart contract data in various formats such as XLS, PNG, CSV, and JSON.
- Visual SQL Queries: Write SQL queries using an intuitive visual SQL editor on the Stellar Network & project dataset. Users can query, filter, join, and group by on the Stellar projects dataset.
- Community Analytics: Community analytics can be done on the indexed Stellar & Soroban smart contract dataset.
- Create, Fork, and Edit Charts: Choose from more than dozens of visualization types to create the best charts like Line chart, Bar chart, Combo, and many other chart types.
- Create Dashboard: Using the drag and drop feature of dashboard builder, create and fork dashboards. Gather info from multiple sources into a single dashboard.
- Share Dashboard: Share dashboards on a URL anywhere you need. Export the charts in popular formats like CSV, XLS, PNG, and JSON.
- Analytics on Multichain Data: Analyze & query multiple Stellar dApps, soroban smart contract data and build awesome charts & dashboards. Users can compare and monitor smart contract KPIs off multiple networks in a single place.
- Collections / Folders: Use collections to organize your charts/dashboards and to decide who gets to see and edit things. Using collections you can make your charts/dashboards private or public.
- Advanced Analytics: Do advanced analytics like funnel analysis, and user retention analysis to monitor active soroban smart contract activity and take appropriate action.


Utilization of Stellar Network: DappLooker leverages the Stellar Network's technology to:

- Implement smart contract indexer on Stellar testnet/mainnet
- Implement transformations for easy queries on the  smart contract data deployed on stellar testnet/mainnet
- Define data schema for User-Friendly Data Browsing.
- Users can analyze and compare data from multiple Smart contract simultaneously.
 

In summary, DappLooker is an innovative offering that democratizes data analytics within the Stellar Network, benefiting both technical and non-technical users. It seamlessly integrates with Stellar network, offering powerful no-code Smart contract analytics and visualization capabilities while promoting collaboration and community empowerment.

Technical Architecture Doc

https://docs.google.com/document/d/19u-4cN1FXrbBT3K5xvhvjZfDvl6aO6-j6Vi1I8aY0FI/edit?usp=sharing

Project URL

https://dapplooker.com/

Code URL

https://github.com/dapplooker

Video URL

https://www.youtube.com/watch?v=V-gUvqPMkgw&t=8s

Pitch Deck URL

https://docs.google.com/presentation/d/1h3CCxqBJOgENTB9CorOR8WvW9ueWTw6V4rjsf-DGAgg/edit?usp=sharing

Project Categories

Product Type [If Services for understanding what is happening on chain (data tools)]

Other Chain Description

We've proudly established strategic and financial partnerships with more than 15 leading blockchain networks like Ethereum, Polygon, Celo, Moonbeam, NEAR, BNB, Gnosis, Arbitrium One, Optimism, and Avalanche. The integration with the Stellar network for the Soroban smart contract stands out due to its incorporation of DappLooker's robust analytics and visualization tools. DappLooker's developer-friendly environment is a distinctive feature, offering the Stellar community & Soroban smart contracts a suite of user-friendly tools. These encompass plug-and-play SDKs, the Soroban smart contract data API, and a dedicated focus on facilitating effortless analysis for every user on the Stellar network. This integration is tailored precisely to meet the needs of the Stellar community.

Section

read

Deliverables List

[Deliverable 1] - Stellar Testnet Integration For Soroban deployed smart contract analytics - 3 Weeks

Brief description

  • Infrastructure Upgrade and APIs/Node Integration 
  • Upgrade and optimize infrastructure to support the successful integration of Stellar testnet with DappLooker. This will make sure the perfect infrastructure is in place.
  • Integrate Node APIs to fetch Soroban Smart contract data . This involves setting up a system to gather data from various sources on the Stellar testnet for integration.
     
  • Smart Contract Indexer Development 
    • Implement smart contract indexer to index Soroban Smart contract data deployed on the testnet in an easy queryable schema format for analytics.
    • Implement ETL transformations to process Soroban smart contract data in the easily queryable schema.
    • Store indexed data. Storage will depend on the volume and complexity of the data.
    • Define a data schema that defines the structure and format of the Soroban smart contract data being indexed. This schema will ensure consistency and ease of access to the data.
    • Implement the data schema.


 

  • Productize Soroban Smart Contract Integration on DappLooker
 
  1. Stellar Testnet integration at the registration page. Users can register, and select deployed smart contracts to be analyzed.
  2. Add Stellar Testnet on the integration page with details(https://dapplooker.com/integration)
  3. After integration, the Stellar community can easily create charts and dashboards using no-code visual SQL on the smart contract data. These charts and dashboards will be accessible on the Discover page at https://dapplooker.com/browse.
  • Dashboard Development 
    1. Smart Contract Summary Dashboard: Featuring essential metrics, including total contracts, TVL, users, transactions, volume, and types (e.g., transfers, token swaps)
       
    2. Smart Contract level Dashboard: We'll list Soroban smart contracts by popularity, allowing users to access essential metrics for each contract by clicking on them. 
      1. Some of the metrics will be Total users, daily/weekly active users, TVL, and total transactions. More metrics will be added as per the feedback

         


How to measure completion

  • Infrastructure Upgrade to support successful Stellar testnet integration.
  • Stellar testnet users & community will be able to register Soroban smart contracts. Soroban Smart contract will be registered by selecting/searching from the autocomplete feature. 
  • Once data is synced they can browse and do advanced no-code analytics & visualization on the smart contract data.
  • Private launch and testing
  • Launch Soroban Smart Contract Summary & Smart Contract level Dashboard

Estimated date of completion

            18 Dec 2023

Budget

$18000

 

[Deliverable 2] - Integrate Stellar Mainnet For Soroban deployed smart contract analytics - 2 Weeks

Brief description

  • Infrastructure Upgrade and APIs/Node Integration 
  • Smart Contract Indexer Development
  • Soroban Smart Contract Integration for Analytics
  • Dashboard Development 
    • Soroban Mainnet Smart Contract Summary Dashboard
    • Soroban Smart Contract level Dashboard
       

Co-Marketing & Operations:

  • Co-marketing with Stellar Team
  • Twitter, Blog, Email Campaign
  • Workshops, Video Tutorials

 

How to measure completion

  • Infrastructure will be ready to support the successful Stellar mainnet.
  • Stellar mainnet users & community will be able to register Soroban smart contracts. Once data is synced they can browse and do advanced no-code analytics & visualization on the smart contract data.
  • Soroban Mainnet Smart contract will be registered by selecting/searching from the autocomplete feature. 
  • (Mainnet)Soroban Smart Contract Summary & Smart Contract level Dashboard will live.
  • Documentation, Promotion, and Marketing operations.

 


Estimated date of completion

2 January 2024
 

Budget

$12000

Requested Budget in USD ($)

30000

Section

read

Public Entity Name

DAPPLOOKER SOLUTIONS PRIVATE LIMITED

Team bio

We are a 12+ dedicated team with different skills including blockchain engineering, backend engineering, frontend engineering, and marketing. Below are the names of core Team members
1. Abhay Singh - 12+ years of experience in blockchain development, analytics, and marketing.
2. Abhinav Singh - 8+ years of experience in front-end development, and blockchain analytics.
 

Previous Partnership Highlights:
 

  • Polygon Dapp Store Kit Announcement: Tweet
  • Aave V3 Grant Announcement: Tweet
  • Moonbeam Partnership Announcement: Tweet
  • NEAR Protocol Partnership Announcement: Tweet
  • BNB Chain Partnership Announcement: Tweet
  • PEAQ Integration Announcement: Tweet
  • Flipside Partnership Announcement: Tweet
  • NFTX Partnership Announcement: Tweet
  • MatricsDao Partnership Announcement: Tweet
Prazenti Grant Announcement: Tweet