Skip to content

Dune-Style Custom SQL Dashboard (Frontend/Backend) #97

Description

@edehvictor

📝 Description

Power users want to query protocol data themselves. We need to build a Dune Analytics-style interface where users can write raw SQL to query our indexed vault data and render custom charts.

🎯 Acceptance Criteria

  • Build a secure backend endpoint that accepts read-only SQL queries against an analytics replica database.
  • Build a frontend code editor (e.g., Monaco Editor) with SQL syntax highlighting.
  • Render the returned JSON datasets dynamically into Recharts/Chart.js graphs based on user configuration.

🛠 Technical Details

  • Stack: React, Monaco Editor, Node.js, PostgreSQL.
  • Location: /frontend/src/pages/analytics/
  • Security: HIGH RISK. Strict database permissions (read-only, execution timeouts) to prevent SQL injection or DoS attacks.

⏱ Complexity & Scope

  • Estimated Time: 3-4 weeks.
  • Drips Complexity: High (200 points) - Full-stack complex architecture.

📋 Guidelines for Submission

  • Minimum 90 percent test coverage required.
  • Clear NatSpec-style documentation must be added to public contract functions.
  • Timeframe for completion: 2 Wave cycles.

Metadata

Metadata

Assignees

Labels

Stellar WaveIssues in the Stellar wave program

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions