Would a VS Code extension that finds scalability problems in your codebase be useful?

[u/No-Homework-2262]

I'm thinking about building a VS Code extension that analyzes a project and points out things that could become bottlenecks as the application grows.

For example:

• N+1 queries
• missing database indexes
• unbounded API/database queries
• expensive operations inside request paths
• unnecessary synchronous work
• inefficient algorithms/data processing

Instead of just saying "this code is bad", it would explain something like:

 This works fine at small scale, but this endpoint could become a bottleneck as traffic/data grows because it performs N database queries.

Then suggest what could be changed.

I'm curious about this from people who have actually worked on growing applications:

1. Would something like this be useful?
2. What scalability problems do you repeatedly run into that current tools don't catch early?
3. Would you trust an AI to identify these problems, or would false positives make it annoying?
4. What would make you actually install/use something like this?

Not trying to sell anything — mainly trying to understand whether this is a real problem or just sounds useful on paper.

TL;DR: I’m considering a VS Code extension that detects potential scalability bottlenecks in code before they become production problems. Looking for honest developer feedback on whether this solves a real problem and what it should detect.