Prisma Optimize — AI-driven query analysis

Hey Product Hunters! For the past 7 years, we at Prisma have been working hard to support the maker community in building amazing apps, by removing the complexity of databases, allowing you to focus on your own mission. One thing we have heard for a long time is that it’s still really hard to debug and improve performance. It’s difficult to know what the problem is — let alone how to fix it! So we set out to solve this. Prisma Optimize is a really neat tool that integrates directly into your existing Prisma ORM client, measures the performance of individual database queries, and then shows everything in an easy-to-understand dashboard. It will give you specific recommendations on what to change, and an AI assistant to answer follow-up questions and review code before you implement it. With Optimize, we wanted to go a step further in helping developers build great products — not only do we take away the complexities of managing databases, but now we can help you solve performance challenges too. Want to try it out? It’s free to start! Let us know how you go with it — did it help? How was your experience? What can we help you with next?

Slow and inefficient queries leads to poor app performance and excessive (and unnecessary) costs. Prisma Optimize peeks inside your database to see which queries can be sped up and uses AI to rewrite them. There's more on offer — but if you have a complex database backend that could run faster, you need to check out Prisma Optimize!

Very cool! Looking forward to trying this. Does it also analyse raw queries or MongoDB aggregations to offer better ways to query the data natively (i.e. use include to join data instead of a Lookup aggregation)?

query optimization is a topic hidden deep in everyones' passive knowledge. we've all spent too much time on it. I am glad Optimize will eventually save us the pain of going through these dark memories. thousands of mirror neurons thank you for it, @sorenbs & @nikolasburk :)

Congratulations on your product @sorenbs! Prisma Optimize tackles an angle that I know from my experience has a massive impact on UX creation and improvement. I wish you and the team a lot of success🥳

Sometimes understanding why a query is slow is one thing, but knowing how to fix it efficiently is another.

A big fan of Prisma (so big I made a framework on top of it hehe) - super excited for this launch!

Very excited about Optimize allowing anyone to improve query performance 💯 Would've loved to have a tool like this when I last worked with a database in a project to tell me what and how to do to make those queries faster. And now, we have Optimize. Go try it out, and make your app even better and faster!

this is a fantastic idea. i have one remark: We had some troubles with inefficient mongodb calls. The problem was that was an issue in prisma itself, which eventually got fixed after raising some awareness in the issue tracker. I think its therefore important that prisma optimize reports back issues it can't solve, or patterns that are used often and aren't really optimized in prisma.

Really excited about this one! In the Database and TypeScript worlds, there are many ways to solve a problem, to build that feature you want to ship, but rarely do the tools help you understand how to use them better while using them, or warn you when you're doing something not optimal or wrong. As tool makers, we try to step away and not be too opinionated in our designs, to fit a broader range of use cases. Sure, the docs might talk about best practices, or common issues, but it is always on the builder to find these pieces of information, and to put 2 and 2 together and apply the learnings to their own solution. This is not trivial, especially if you're not in the top 10-20% of backend developers. Even if you are the most brilliant developer out there, your team's codebase can get so large and the velocity can be so high, that introducing new mistakes/suboptimal usage of tools are inevitable.

Excited to get this into the hands of our users!

More time coding, less time fixing queries this is all about speeding up dev work!

congrats on the launch!! looks like a great tool for developers!