(Disclaimer: I am maintainer at SigNoz)

As far as I know, Prometheus doesn't do APM - it's primarily a metrics products (e.g. you can't click metrics to see relevant traces which cause increase in say the latency) You need to tie it up with some product which does tracing and that would be non-trivial.

Don't know much about SkyWalking to comment