Comment by twoquestions

Have you looked at DataSpell? I haven't used it myself but it looks like it fits at least some of what you need.

https://www.jetbrains.com/dataspell/