Product
Ask Sherloq AI
Sherloq AI is your assistant inside the editor.
What is it?
Sherloq AI is your assistant inside the editor.
You can ask it things like:
“How to filter out the exclude folder?"
"Why is this query using a LEFT JOIN?"
"Fix syntax error in this query”
It reads the queries you’ve saved in Sherloq and gives answers that are based on your real SQL, not generic advice.
How to use it
- Open Sherloq AI
Click the Sherloq badge in your editor to open the chat. - Ask a question
Type your question in natural language — no need to write SQL. - See the answer with real SQL examples
Sherloq highlights the relevant logic and explains each part clearly.
Example: Filtering Folders
🖼️ Here’s what it looks like when you ask a question like
“How to filter out the exclude folder?”
What this does:
- Joins the
query_folders
table onparent_id
- Excludes deleted folders (
deleted_at IS NULL
) - Filters out names with terms like
monthly
,weekly
,template
, etc.
You’ll get both the SQL and the explanation—so you can learn or adjust it as needed.
Tip: Ask About Anything
Try things like:
- “What does this CASE WHEN mean?”
- “Can you rewrite this to use CTEs?”
- “How to join deals with customers?”
- “Fix this BigQuery syntax error”
Sherloq AI is powered by the queries your team has already written, so it’s always relevant.