Devtools
Interactive Codebase Map
Explore a codebase as a map of modules, dependencies and owners
Advanced24h2–3
Tree-sitterEChartsLLM
17/20SQL Query Plan Visualizer
Turn a database query plan into a visual tree with plain-language tips.
Intermediate14h1–2 people17/20 fit
Build SQL Query Plan Visualizer for backend developers in ~14h with 1–2 people. Stack: Postgres + ECharts + LLM.
Why it wins: Turns expert knowledge into a tool.
Build flow
01 · Problem
Query plans are walls of text that few developers can read.
02 · Solution
Parse the plan, draw a tree sized by cost, highlight slow nodes and suggest indexes with explanations.
03 · Build
- 1Parse plan JSON
- 2Render tree
- 3Highlight costs
- 4Explain
04 · Demo
Paste a slow query plan and see the missing index suggestion.
MVP checklist
- Plan parsing
- Cost tree
- Slow node highlights
- Index tips
Tech stack
| Tech | Role | |
|---|---|---|
| Postgres | Relational database | Data |
| ECharts | Interactive charts | UI |
| LLM | Language model | AI |
Reference repos
Open-source projects you can build on. Links checked 2026-10-31.
Related ideas
More DevtoolsFlag migrations that will lock tables or lose data before they run
Intermediate14h1–2Node.jsPostgresGitHub Actions17/20Devtools
CI Pipeline Speed Analyzer
Find which CI steps waste time and how to speed them up
Intermediate14h1–2GitHub APIEChartsNode.js17/20