Sherloq

Sherloq: AI Data Agent for Your SQL

Sherloq is an AI-powered data agent designed to revolutionize how you interact with SQL. Built directly into your editor, it provides context-aware assistance to streamline your SQL workflows. Say goodbye to generic code and hello to AI that understands your SQL.

What is Sherloq?

Sherloq is a browser extension and IntelliJ plugin designed to assist data professionals in writing, understanding, and managing SQL queries. It leverages AI to provide intelligent suggestions and automate common tasks, saving time and improving accuracy.

How does Sherloq work?

Sherloq works by analyzing your existing SQL code and data structures. It then uses this information to:

• Generate context-aware SQL: Based on your specific data, Sherloq can create new queries that are tailored to your needs.
• Fix SQL Syntax: It identifies and corrects syntax errors, ensuring your code runs smoothly.
• Extract logic and filters: Easily understand the underlying logic of complex queries.
• Modify existing queries: Quickly adapt existing code to new requirements.
• Write correct JOINs: Avoid common errors when joining tables.
• Find tables and fields: Easily discover and understand your data schema.

Key Features and Benefits

• AI-Powered Assistance: Sherloq uses AI to understand your SQL and provide intelligent suggestions, increasing your productivity.
• Context-Aware: Sherloq learns from your existing SQL and data, providing tailored assistance.
• SQL Repository: Sherloq helps you build an AI-ready SQL repository from your real work.
• Knowledge on-the-fly: Save and manage queries directly from your editor or import existing SQL.
• Version Control: Create versions of your queries to track changes and revert to previous versions.
• Permissions and Teams: Manage who can view and edit each folder and SQL, promoting collaboration and data governance.
• Plugin Integration: Sherloq works as a plugin for popular editors like Chrome and IntelliJ, requiring no complex integrations.

How to Use Sherloq

1. Download and install the Chrome extension or IntelliJ plugin.
2. Connect to your SQL database.
3. Start writing SQL queries in your editor. Sherloq will automatically provide suggestions and assistance as you type.

Why is Sherloq important?

In today's data-driven world, SQL is a critical skill for data professionals. Sherloq makes it easier and faster to write, understand, and manage SQL queries, ultimately helping you make better decisions based on your data.

Testimonials

Users rave about Sherloq's ease of use and time-saving capabilities:

• Rotem Haviv Ofir, Product Analyst at Taboola: "There’s definitely a need for something like this so that I can easily access my code. The way we’ve been handling things up until now feels obsolete."
• Omri Bouchnick, Business Analyst at Natural Intelligence: "The snippets give me a great starting point for writing queries without having to rewrite everything from scratch. I can start with the basics and then customize as needed. It’s very easy."
• Philipp Ulanovskiy, Senior Product Analyst at Taboola: "I’m super happy with the product! ... This one works, does it's job in an amazing way - and also logs your own queries, which is pretty helpful as well."

Is Sherloq secure?

Yes, Sherloq prioritizes data security. It is SOC2 compliant and does not integrate into your data or metadata. Enterprise plans offer SSO support and on-prem solutions for enhanced security.

Pricing

Sherloq offers a free plan and paid plans with additional features and support. Visit the pricing page for details.

Get Started

Ready to transform your SQL workflow? Download the Chrome extension or IntelliJ plugin and start using Sherloq today!

• [Download Chrome Extension](link to extension)
• [Download IntelliJ Plugin](link to plugin)

What is the best way to manage SQL queries?

Sherloq offers features to easily save and manage frequently used queries, categorize by topic, write descriptions, and share with your team. It can help you stay organized and prevent code redundancy.

Where can I use Sherloq?

You can use Sherloq in your preferred code editor with the browser extension or Intellij plugin.