Sherloq

So we couldn’t end this year without our own Sherloq 2024 Wrapped 🎉 We’ve gathered some of the coolest insights we’ve got on SQL and product usage, like: ⏰ What’s the most popular hour of the day to run and save queries? 💡Do most users prefer Light or Dark mode? ✏️ What’s the average length of a SQL query? Take a look in the first comment (only on desktop) Happy holidays everyone!

Using a central version control is the standard for our Python code. But how many of us are doing the same for our SQL queries? I've written the same queries over and over again because GitHub felt like overkill for an SQL query, and the copy in a notebook always got lost. That’s when I found Sherloq, a lightweight tool that solved the problem for me. Sherloq integrates directly with your SQL editor. It lets you save, organize, and share your SQL queries. I found it to be the perfect middle ground between a notepad and GitHub, built specifically for SQL. That's why I happily decided to partner with Sherloq. 𝗛𝗲𝗿𝗲 𝗶𝘀 𝗵𝗼𝘄 𝗦𝗵𝗲𝗿𝗹𝗼𝗾 𝗰𝗮𝗻 𝗵𝗲𝗹𝗽 𝘆𝗼𝘂: 1. Reuse proven queries to save time and reduce errors. 2. Keep your SQL library organized and accessible for the whole team. 3. Never lose track of a query you spent hours perfecting.     With Sherloq, you can give your SQL the same attention to detail as your Python scripts, and unlock a more efficient workflow. Check it out for 𝗳𝗿𝗲𝗲 and see how much time you can save: https://lnkd.in/dp_5bquq Have you ever struggled to find or reuse an old SQL query? ---------------- ♻️ 𝗦𝗵𝗮𝗿𝗲 if you find that SQL queries should be better managed ➕ 𝗙𝗼𝗹𝗹𝗼𝘄 for more daily insights on how to grow your career in the data field #dataanalytics #datascience #sql #versioncontrol #sherloq

Meet our Partners!💥 Super excited to officially be launching our Partners Program with this amazing group of Data Leaders and Experts. It’s always so exciting to see other people believe in our mission, and understand the true value of what we do at Sherloq. Thanks for choosing to partner with us 🤩

December 2024 Changelog is here 🎄 This month we've focused on capabilities that can simply make your day-to-day SQL life easier 😎 Here's what we've been up to in the past month: 🆕 Generate ERDs for any one of your SQL queries Create ERDs (Entity Relationship Diagrams) to simply see relationships between tables for specific queries. 🆕 SQL formatting based on your dialect, directly on your editor Now formatting is fully customizable so you can choose your preferred SQL dialect. Using our keyboard shortcuts automatically format your query in your editor. 🆕 Insert any query into your editor with our keyboard shortcuts SQL snippets, one of our most beloved capabilities, is now available for every query. By using our keyboard shortcut @ @ you can search for any one of your saved queries, and easily insert it into your editor.

You don't need years to be "good at data" Focus on these to outperform your team (and get a promotion)... 1. Be supportive 2. Streamline your processes 3. Innovate the current workflow Sherloq makes it easy for all 3 Especially when working in a SQL-heavy data team You can easily: - Save queries (and share!) - Query version control (with notes!) - Search and insert into your IDE And the most game-changing feature.. It's a plugin No more writing a bunch of queries and logging off for the weekend only to come back and figure out where you left off I can't tell you how many hours this would have saved me had I known about this tool Try it out for yourself: https://bit.ly/sherloq -- P.S. Which feature resonates with you? I'll go first 👇 #sql #data #dataanalytics

Sherloq (YC W23) is the one place for all your queries, directly in your SQL editor. With the rise of Generative AI, SQL is even more popular within organizations as it is becoming more accessible to everyone. But users still spend too much time trying to manage, share, and find their code— it's scattered across different tools, docs, dashboards, people, and even notepads. Today's common alternatives aren’t built for SQL code, making each user independently manage their day-to-day SQL work. The result: Inconsistent SQL leads to inconsistent data. Using Sherloq’s collaborative SQL repository plugin, you can organize, save, and share your SQL code, without leaving your SQL editor: - Create a shared SQL repository for your org and team - Manage your code better with reusable SQL snippets and templates - Understand your code faster with AI SQL ERD diagrams, SQL errors explained, query optimization, and formatting - AI auto-documentation, including SQL version control, generated query names and descriptions With Sherloq, SQL users can focus on what matters most— analyzing the data and creating meaningful insights for their organization. https://lnkd.in/gHByPzB3

It’s finally here🥁🥁 Our complete redesign! Check it out here: https://www.sherloqdata.io

𝐇𝐨𝐰 𝐝𝐨 𝐲𝐨𝐮 𝐦𝐚𝐧𝐚𝐠𝐞 𝐲𝐨𝐮𝐫 𝐒𝐐𝐋 𝐪𝐮𝐞𝐫𝐢𝐞𝐬? If you're juggling between tools like Slack, Confluence, or spreadsheets, take a look at Sherloq: https://lnkd.in/gXDBm4wY 👇 It is a collaborative SQL repository that sits right on top of your preferred SQL editor, streamlining query management and team collaboration. The reason why I partnered with Sherloq for this post is because it brings all that you need for your SQL query management into one intuitive platform. 𝐇𝐞𝐫𝐞'𝐬 𝐰𝐡𝐲 𝐢𝐭 𝐬𝐭𝐚𝐧𝐝𝐬 𝐨𝐮𝐭: ➡️ No context switching: Save, share, and organize SQL queries directly from your editor ➡️ Stay organized: Use folders, snippets, and templates to manage reusable code and maintain consistency ➡️ Track and improve: Version control and activity tracking ensure you're always working with the most relevant queries ➡️ Boost collaboration: Easily share queries with teammates while managing permissions for secure and effective teamwork All in all, it saves you time and simplifies your workflows. Go get it for FREE!

Our October Changelog - here are some of the things we've been up to in the past month 🤩 🔍 Same Search, Just Better - We've changed the infra behind our search engine, so we now show the most relevant results based on team usage and activities, and in half of the time. 📁 AI SQL Organizer - We now can automatically organize your most common SQL: sort them into folders, and generate titles and descriptions for each. Try it out: https://lnkd.in/dni6C3w9 🤖 SQL Greeting Generator - For the upcoming holidays, we've had a bit fun so you can now create your own SQL greeting. Give it a shot: https://lnkd.in/d-zf4ZwK 🎨 And we're working on a something big (redesign anyone?), so stay tuned! Want to learn more about our SQL repository? DM us or reach out at [email protected]

We won the #1 Product of the Day on Product Hunt 🥇 To our amazing community - thank you for all the help and support!