Is it possible to run sql queries in strapi cli?

Discord Q&A strapi-questions
1

I want to do some console logs basically on the strapi db, namely checking for duplicate values, can I do quick tests like this in strapi cli without putting that code in the bootstrap.ts file instead?

This topic has been created from a Discord post (1277352146290868235) to give it more visibility.
It will be on Read-Only mode here.
Join the conversation on Discord

2

You can query the db using Strapi’s Entity Sevice using the Strapi console from the CLI.

3

Do note that it’s an interactive CLI tool

4

Yes perfect thats what i was looking for ty