AI-Powered Dune Analytics Clone for Cardano: Open-Source Toolkit for Custom Real-Time On-Chain & DeFi Dashboards

[GENERAL] Name and surname of main applicant

Adnan Khan

[GENERAL] Are you delivering this project as an individual or as an entity (whether formally incorporated or not)

Entity (Incorporated)

[GENERAL] Please specify how many months you expect your project to last (from 2-12 months)

3

[GENERAL] Please indicate if your proposal has been auto-translated into English from another language

No

[GENERAL] Summarize your solution to the problem (200-character limit including spaces)

We’ll develop a LLM-compatible open-source toolkit that will enable developers to create real-time custom dashboards that simplify access to on-chain data and unlock intelligent on-chain insights.

[GENERAL] Does your project have any dependencies on other organizations, technical or otherwise?

No

[GENERAL] If YES, please describe what the dependency is and why you believe it is essential for your project’s delivery. If NO, please write “No dependencies.”

No dependencies.

[GENERAL] Will your project’s output/s be fully open source?

Yes

[GENERAL] Please provide here more information on the open source status of your project outputs

Our project will be open source under the MIT License, ensuring transparency and community collaboration.

[METADATA] Horizons

Analytics

[SOLUTION] Please describe your proposed solution

Cardano generates a vast amount of on-chain DeFi data, including smart contract interactions, token transfers, and liquidity movements. However, this raw blockchain data is difficult to access and analyze directly due to a lack of developer-friendly tools. Current solutions do not provide the necessary flexibility for developers to build custom dashboards or extract specific insights from raw blockchain data. 

Without tools that convert this data into a queryable format, developers face challenges in:

• Whale Watching:
• Similar to Dune’s tracking of large token holders, our toolkit can allow developers to monitor Cardano whales by building dashboards that track large transactions, token swaps, and staking movements.
• Yield Farming & DeFi Analytics:
• On Dune, users often create dashboards to track liquidity pools, yield farming, and staking performance. Developers can build dashboards to analyze yield over time, optimize DeFi strategies, and monitor staking rewards on Cardano.
• Cross-Protocol Analytics:
• Just like Dune supports cross-chain queries, developers using our toolkit can analyze multiple Cardano dApps (such as decentralized exchanges and lending protocols) to track liquidity across platforms, borrowing/lending rates, and protocol usage.

This lack of access to structured, real-time data prevents the accessing of valuable insights, leading to missed opportunities for optimizing dApps, making informed decisions, or conducting in-depth research.

We propose the development of an LLM-compatible open-source toolkit specifically designed to convert Cardano blockchain raw data into SQL-compatible data feeds. This will allow developers to query and analyze the data, using SQL, and build customized real-time dashboards to visualize insights directly. The toolkit will also feature an LLM integration, allowing developers to convert complex queries and dashboards into intelligent natural language insights.

How It Works (Technical Details)

1. Data Extraction and Conversion:

The toolkit will include a data extraction layer that interfaces directly with the Cardano blockchain. It will aggregate on-chain data from various sources, including transaction history, smart contract executions, liquidity pool interactions, and token transfers. This data will be structured and converted into SQL-compatible formats.

Technical Components:

• Cardano Node Access: Direct interaction with Cardano full nodes to access transaction and block data.
• ETL Pipeline: An extract-transform-load pipeline that processes and structures raw blockchain data into predefined relational tables, enabling SQL queries.
• Data Enrichment: The pipeline will perform real-time data enrichment, aggregating key metrics like liquidity, token balances, and transaction volumes.

2. SQL-Based Querying:

Developers will interact with this data via an SQL query engine. The toolkit will provide predefined tables for the most critical metrics (e.g., liquidity pool movements, token interactions), allowing developers to query specific data in real-time using SQL.

SQL Query Example:

For tracking how much liquidity an address adds or removes from liquidity pools:

SELECT timestamp, pool_id, liquidity_added, liquidity_removed

FROM liquidity_pool_interactions

WHERE address = 'specific_address'

ORDER BY timestamp DESC;

Functionality:

• Real-Time Queries: Querying will reflect real-time data fetched from the Cardano blockchain.
• Pre-Defined Data Models: Developers will have access to predefined tables for common DeFi metrics like liquidity pool activities, token flows, and smart contract events.

3. Custom Dashboards:

The toolkit will allow developers to create custom dashboards by combining multiple SQL queries. Dashboards can be created to monitor real-time DeFi metrics or display historical trends across Cardano’s ecosystem.

Dashboard Features:

• Data Visualizations: SQL query results will be visualized in various formats (e.g., line charts, bar graphs, tables) for easy interpretation.
• Widget-Based Layout: Developers can create dashboards by dragging and dropping widgets that display different data visualizations.

Example Use Case:

A developer can create a dashboard to monitor the liquidity provided by a specific address across multiple liquidity pools. By combining the SQL query results, the dashboard will provide a real-time view of liquidity movements, token balances, and other key metrics for the specified address.

4. Real-Time Monitoring and Alerts:

The toolkit will include a real-time monitoring feature, allowing users to set up alerts for specific blockchain events. For example, developers can set alerts to be notified when liquidity in a pool drops below a certain threshold or when large token movements occur.

Alert Configuration Example:

CREATE ALERT liquidity_alert

ON liquidity_pool_interactions

WHEN liquidity_added < 1000

NOTIFY 'email_address';

• Real-Time Alerts: Developers can configure alerts based on real-time data and receive notifications when specified conditions are met.
• Event-Driven Triggers: Alerts will be triggered by blockchain events like token transfers, liquidity changes, and contract interactions.

5. LLM Integration for Natural Language Insights:

The toolkit will feature an LLM integration that enables developers to convert SQL queries and dashboard results into natural language insights. This will allow for a more intuitive interpretation of complex blockchain data.

Example:

A developer might query the liquidity pool data for a specific address. The LLM integration can convert the query results into natural language:

• Query: "What is the total liquidity added by Address X in the past 30 days?"
• Natural Language Response: "In the past 30 days, Address X has added a total of 15,000 ADA in liquidity across three liquidity pools."

This feature will simplify the interaction with complex data and help users who are less familiar with SQL but still need actionable insights.

Modular Components Overview:

• Data Extraction Layer: Extracts raw data from the Cardano blockchain (transaction data, smart contract interactions).
• SQL Conversion Module: Converts raw blockchain data into SQL-compatible formats for easy querying.
• Query Engine: Executes SQL queries on pre-structured Cardano data (e.g., liquidity pools, token transfers).
• Dashboard Builder: Allows users to build custom dashboards with real-time data visualizations.
• Alert System: Provides real-time alerts for blockchain events based on custom SQL query conditions.
• LLM Integration: Converts SQL query results into intelligent natural language insights for easier data interpretation.

Target Users (Developer-Oriented Use Cases)

• Developers:
• Create custom dashboards to track smart contract performance, liquidity pool activities, and token flows in real-time.
• DeFi Traders:
• Analyze liquidity shifts, token volumes, and set up real-time alerts to capitalize on market changes.
• Blockchain Researchers:
• Extract and analyze historical on-chain data, providing deeper insights into trends and blockchain behavior.

Benefits to the Cardano Ecosystem

• Enhanced Data Accessibility:
• Developers will gain easy access to structured blockchain data, enabling detailed analysis and the creation of custom dashboards.
• Real-Time Monitoring:
• Real-time data access and alerting capabilities will allow for better decision-making and faster responses to blockchain events.
• Data-Driven Insights:
• By converting raw blockchain data into SQL-compatible formats, developers can perform complex queries and gain valuable insights to optimize dApps and DeFi strategies.

To keep the scope realistic, the initial toolkit will focus on:

1. Whale Watching: Track large transactions and liquidity shifts by major holders.
2. Cross-Platform Analysis: Monitor liquidity flows and lending rates across Cardano DeFi dApps.
3. Yield Farming Analytics: Analyze yield performance and staking rewards to optimize DeFi strategies.

The toolkit will include real-time alerts and LLM-based insights for easier data interpretation. As an open-source project, it will expand to support more use cases as community contributions grow.

Conclusion

This open-source toolkit will empower developers to unlock the full potential of Cardano’s on-chain data by converting it into SQL-compatible feeds, facilitating real-time queries, custom dashboards, and intelligent natural language insights. By providing a flexible, developer-focused toolset, this solution will drive innovation and improve the efficiency of on-chain data analysis across the Cardano ecosystem.

[IMPACT] Please define the positive impact your project will have on the wider Cardano community

Our toolkit will significantly improve on-chain data accessibility for developers, traders, and researchers, empowering them to extract real-time insights from Cardano’s DeFi data. By simplifying data queries, enabling custom dashboards, and providing natural language insights, users will have the tools to optimize dApps, track market activity, and improve DeFi strategies.

Measuring Impact:

1. User Metrics: We will track the number of active users, SQL queries run, and custom dashboards created.
2. Community Contributions: Monitor shared dashboards and developer contributions within the open-source community.
3. Real-World Use Cases: Capture success stories showing how the toolkit enhanced decision-making and dApp performance.

Sharing Outputs:

• Open-Source Repository: The toolkit will be available on GitHub for public use, encouraging collaboration and improvements.

The toolkit will empower the community to leverage on-chain data, driving innovation and growth within the Cardano ecosystem.

[CAPABILITY & FEASIBILITY] What is your capability to deliver your project with high levels of trust and accountability? How do you intend to validate if your approach is feasible?

Our team is composed of experienced Cardano developers and community members with deep knowledge of the Cardano stack. We have collaborated with reputable teams such as IAMX, Nucast, etc. contributing to the development of multiple projects in the ecosystem. This extensive background positions us uniquely to execute this project effectively.

Steps to Ensure Trust and Accountability

1. Proven Track Record: Our team has demonstrated success in designing and executing complex blockchain solutions, ensuring we can deliver a high-quality, effective toolkit for Cardano data analysis.
2. Transparent Fund Management: We will adopt industry best practices for fund management, including transparent financial reporting and milestone-based fund release, ensuring that every allocation aligns with the project's progress and objectives.
3. Community Engagement: Regular updates, community-driven feedback loops, and open discussions on our development progress will be a key part of our strategy to maintain transparency and trust within the Cardano community.
4. Security and Compliance: We will utilize Cardano’s secure infrastructure and follow strict compliance standards to manage funds and ensure all operations are secure, protecting both the community’s trust and investment.

Our commitment to maintaining high standards of trust and accountability, combined with our technical expertise and successful track record, reinforces our ability to deliver DSN efficiently and transparently for the Cardano community.

[PROJECT MILESTONES] What are the key milestones you need to achieve in order to complete your project successfully?

Milestone 1: Project Kickoff

A. Milestone Outputs

Project Initiation Report

• Market Analysis: Conduct a detailed study of the current landscape for blockchain-based analytics platforms, particularly within the Cardano ecosystem. Identify the key pain points faced by users and assess the gaps in existing tools for on-chain analysis.
• Technology Assessment: Analyze current technologies, SQL-based querying tools, and real-time data analytics frameworks that can be leveraged to develop the customizable analytics platform.
• Competitive Analysis: Examine existing blockchain analytics tools like Dune Analytics to identify strengths, weaknesses, and opportunities for innovation on the Cardano blockchain.

B. Acceptance Criteria

• The Initiation Report offers a thorough understanding of user needs in blockchain analytics, highlighting unique advantages of customizable solutions on Cardano.
• A clear definition of the project's scope, key objectives, and the anticipated impact on the Cardano community.

C. Evidence of Milestone Completion

• A finalized Initiation Report is submitted to the project repository

Milestone 2: Platform Architecture and Design

A. Milestone Outputs

• Technical Feasibility Report: A detailed breakdown of the technical infrastructure required to build the platform, including SQL-based querying, data flows, and real-time monitoring capabilities. Identify key challenges related to scaling and security, alongside solutions.
• High-Level Architecture: Draft a comprehensive architecture diagram that outlines the platform’s key modules, such as data ingestion, user dashboard creation, and alerting systems. Ensure design scalability for future integrations with additional blockchains.

B. Acceptance Criteria

• Confirmation that the platform's architecture supports real-time data monitoring, custom dashboard creation, and SQL-like querying.
• The design aligns with Cardano’s standards, ensuring data integrity and seamless integration with the blockchain.

C. Evidence of Milestone Completion

• A Technical Feasibility Report submitted, reviewed, and validated by the technical team.
• A finalized Architecture Design available in the project repository.

Milestone 3: Platform Prototyping

A. Milestone Outputs

• Prototype Development: Deliver a working prototype showcasing the platform's core functionalities, such as customizable dashboard creation, real-time data feeds, SQL querying, and alert setups.
• Testing Environment: Set up a sandbox environment to test the prototype's performance, including integration with the Cardano blockchain and simulation of user activities like monitoring transactions and liquidity pools.

B. Acceptance Criteria

• The prototype effectively demonstrates customizable dashboards, real-time data updates, and SQL-based querying.
• The sandbox testing environment operates smoothly, replicating real-world Cardano blockchain data .

C. Evidence of Milestone Completion

• A Prototype Documentation detailing features, user guides, and system requirements.
• A Testing Report outlining testing scenarios, outcomes, and performance benchmarks achieved in the sandbox environment.

Final Milestone: Launch and Project Completion

A. Milestone Outputs

• Final Completion Report: Comprehensive documentation of all project phases, from inception to mainnet deployment, summarizing key accomplishments, lessons learned, and alignment with initial KPIs.
• Launch: Launch the fully functional analytics platform on the Cardano mainnet, with real-time data monitoring, SQL queries, and community sharing features available.

B. Acceptance Criteria

• The platform is fully operational on the Cardano mainnet with clear user documentation and best practices for creating and sharing dashboards.
• The Final Report evaluates project success against predefined KPIs, showcasing impact on the Cardano ecosystem and future growth potential.

C. Evidence of Milestone Completion

• A Project Closure Report and presentation summarizing the platform’s functionality, key achievements, and community impact.
• Launch Documentation available on GitHub with developer guides and best practices for enterprise users.

[RESOURCES] Who is in the project team and what are their roles?

Adnan Khan

https://x.com/skepticus_x

https://www.linkedin.com/in/adnan-khan-x/

Adnan has over four years of experience in the Web3 space, working as a product architect for multiple startups. He previously served as a research partner at Levitate Labs, a Web3-focused venture capital firm and accelerator. Adnan holds a degree in Data Science and Machine Learning and was a core contributor to user experience research at Fetcch, a Web3 research venture.

Coherence Labs Ltd

We are a RAK DAO-based blockchain development company headquartered in the UAE, with a team of 11+ developers specializing in web3 and AI solutions. Our team has collaborated with established projects, including Biconomy, 0g, Nillion network, NMKR, IAGON, IAMX and Nucast, contributing to the development of multiple projects across the ecosystem.

[BUDGET & COSTS] Please provide a cost breakdown of the proposed work and resources

Budget Breakdown for Customizable Analytics Platform for Cardano

Total Budget: 145,000 ADA

The budget is structured to ensure strategic resource allocation across all project stages, focusing on development, community engagement, and project closure.

Milestone 1: Project Kickoff

Total: 25,000 ADA

• Project Manager: 5,000 ADA
• Senior Cardano Developer: 15,000 ADA
• Operational & Research Costs: 5,000 ADA

Milestone 2: Library Technical Design

Total: 45,000 ADA

• Project Manager: 10,000 ADA
• Senior Cardano Developer x 2 : 35,000 ADA

Milestone 3: Technical Prototyping

Total: 55,000 ADA

• Project Manager: 10,000 ADA
• Senior Cardano Developer x 2: 45,000 ADA

Final Milestone: Mainnet Deployment and Project Close-out

Total: 20,000 ADA

• Project Manager: 5,000 ADA
• Senior Cardano Developer x 2 : 15,000 ADA

[VALUE FOR MONEY] How does the cost of the project represent value for money for the Cardano ecosystem?

The Customizable Analytics Toolkit offers exceptional value for the Cardano community, with a total budget of 145,000 ADA strategically focused on delivering high-impact features that will drive engagement, better decision-making, and stronger collaboration within the ecosystem.

Cost Justification

• Lean Development Approach:
• We are committed to a lean development model, efficiently allocating resources to core functionalities, ensuring high-quality output without unnecessary overhead. This approach enables us to develop a robust, feature-rich toolkit while maintaining cost efficiency.

• Essential Features:
• Each budget allocation is tied to critical components like real-time data integration, customizable dashboards, and security audits. These features are designed to address the specific needs of developers, traders, and researchers within Cardano, enhancing user experience and ecosystem participation.

• Long-Term Benefits:
• The investment will unlock real-time access to crucial on-chain data, empowering users to make informed decisions, drive innovation, and fuel Cardano’s growth. Enhanced insights and participation will strengthen the ecosystem’s competitive position in the blockchain space.

Overall Impact

By offering real-time analytics and a collaborative platform for developers, investors, and researchers, the toolkit will elevate the Cardano ecosystem. The benefits, including improved decision-making, greater innovation, and increased user engagement—far outweigh the initial financial commitment, making it a key step forward for Cardano