tool

• id: 4653
  tools_id: AOAT-004653
  tools_url: https://sherloqdata.io
  tools_name: Sherloq
  publish_date: 2022-09-24
  is_active: 1
  created_at: 2025-07-23T05:58:33.471061
  updated_at: 2025-07-27T08:15:21.895024
  

---

badges

• tool_id: 4653
  badge_id: 35
  is_active:
  created_at: 2025-08-31T09:54:52.557846
  value: 1
  id: 54496
  updated_at: 2025-08-31T12:56:27.351129
  value_text:
  

---

• tool_id: 4653
  badge_id: 35
  is_active:
  created_at: 2025-08-31T11:18:42.211533
  value: 1
  id: 59702
  updated_at: 2025-08-31T12:56:27.351129
  value_text:
  

---

• tool_id: 4653
  badge_id: 3
  is_active: 1
  created_at: 2025-07-19T09:09:05.686616
  value: 1
  id: 1576
  updated_at: 2025-07-27T08:11:45.309133
  value_text:
  

---

• tool_id: 4653
  badge_id: 17
  is_active: 1
  created_at: 2025-07-21T12:34:50.291939
  value: 1
  id: 6815
  updated_at: 2025-07-27T08:11:45.309133
  value_text:
  

---

• tool_id: 4653
  badge_id: 25
  is_active: 1
  created_at: 2025-08-18T14:37:48.145979
  value: 4141878
  id: 33108
  updated_at: 2025-08-18T14:37:48.145979
  value_text:
  

---

• tool_id: 4653
  badge_id: 9
  is_active: 1
  created_at: 2025-08-30T08:35:05.582954
  value: 1
  id: 43799
  updated_at: 2025-08-30T08:35:05.582954
  value_text:
  

---

• tool_id: 4653
  badge_id: 35
  is_active: 1
  created_at: 2025-08-31T13:44:14.852057
  value: 1
  id: 67887
  updated_at: 2025-08-31T13:44:14.852057
  value_text:
  

---

images

• image_id: 13086
  tool_id: 4653
  image_url: https://ageofai.tools/wp-content/uploads/img/AOAT-004653-img-6168.png
  image_type: gallery
  alt_text:
  order: 1
  is_active: 1
  created_at: 2025-07-23T06:21:01.537453
  updated_at: 2025-07-27T08:07:15.656641
  

---

• image_id: 13087
  tool_id: 4653
  image_url: https://ageofai.tools/wp-content/uploads/img/AOAT-004653-img-6169.png
  image_type: gallery
  alt_text:
  order: 2
  is_active: 1
  created_at: 2025-07-23T06:21:01.537453
  updated_at: 2025-07-27T08:07:15.656641
  

---

• image_id: 67647
  tool_id: 4653
  image_url: https://ageofai.tools/wp-content/uploads/fullsc/fullsc-4653-VPH6E.png
  image_type: homefullsc
  alt_text:
  order:
  is_active: 1
  created_at: 2025-08-11T07:19:57.74348
  updated_at: 2025-08-11T07:19:57.74348
  

---

• image_id: 13084
  tool_id: 4653
  image_url: https://ageofai.tools/wp-content/uploads/logo/AOAT-004653-logo.png
  image_type: logo
  alt_text:
  order:
  is_active: 1
  created_at: 2025-07-23T06:21:01.537453
  updated_at: 2025-07-27T08:07:15.656641
  

---

• image_id: 13085
  tool_id: 4653
  image_url: https://ageofai.tools/wp-content/uploads/sc/AOAT-004653-sc-10986.png
  image_type: screenshot
  alt_text:
  order:
  is_active: 1
  created_at: 2025-07-23T06:21:01.537453
  updated_at: 2025-07-27T08:07:15.656641
  

---

pricing

• pricing_id: 1154
  tool_id: 4653
  price: 0
  currency_symbol: $
  billing_period:
  pricing_explanation:
  currency:
  pricing_name:
  is_active: 1
  updated_at: 2025-07-27T08:08:19.419945
  created_at: 2025-07-27T08:10:10.881958
  

---

pricing_models

• tool_id: 4653
  pricing_model_id: 1
  is_active: 1
  created_at: 2025-07-23T06:17:37.581901
  id: 1719
  updated_at: 2025-07-27T08:16:13.168523
  

---

all_pricing_models

• pricing_model_id: 9
  pricing_model_name: Hybrid Models
  is_active:
  sort: 0
  

---

• pricing_model_id: 10
  pricing_model_name: Deprecated/Legacy
  is_active:
  sort: 0
  

---

• pricing_model_id: 1
  pricing_model_name: Free
  is_active: 1
  sort: 1
  

---

• pricing_model_id: 2
  pricing_model_name: Freemium
  is_active: 1
  sort: 2
  

---

• pricing_model_id: 12
  pricing_model_name: Free Trial
  is_active: 1
  sort: 3
  

---

• pricing_model_id: 3
  pricing_model_name: Subscription
  is_active: 1
  sort: 6
  

---

• pricing_model_id: 4
  pricing_model_name: Pay-As-You-Go (PAYG)
  is_active: 1
  sort: 4
  

---

• pricing_model_id: 5
  pricing_model_name: One-Time Purchase
  is_active: 1
  sort: 7
  

---

• pricing_model_id: 6
  pricing_model_name: Credit or Token-Based
  is_active: 1
  sort: 5
  

---

• pricing_model_id: 7
  pricing_model_name: Custom Pricing
  is_active: 1
  sort: 8
  

---

• pricing_model_id: 8
  pricing_model_name: Performance-Based
  is_active: 1
  sort: 9
  

---

• pricing_model_id: 11
  pricing_model_name: Miscellaneous
  is_active: 1
  sort: 10
  

---

active_pricing_model_names

ratings

• rating_id: 87946
  tool_id: 4653
  source_id: 3
  score: 4.443165815
  weight:
  comment:
  created_at: 2025-09-17T22:25:01.51939
  is_active: 1
  updated_at: 2025-09-17T22:25:01.51939
  

---

• rating_id: 65649
  tool_id: 4653
  source_id: 3
  score: 4.309687144
  weight:
  comment:
  created_at: 2025-08-11T14:08:44.463387
  is_active: 1
  updated_at: 2025-08-11T14:08:44.463387
  

---

• rating_id: 65648
  tool_id: 4653
  source_id: 3
  score: 4.309687144
  weight:
  comment:
  created_at: 2025-08-11T14:08:37.141652
  is_active: 1
  updated_at: 2025-08-11T14:08:37.141652
  

---

• rating_id: 4653
  tool_id: 4653
  source_id: 3
  score: 3.844145
  weight:
  comment:
  created_at: 2025-06-28T07:49:38.28653
  is_active: 1
  updated_at: 2025-07-27T08:17:24.286376
  

---

seo

• seo_id: 4653
  tool_id: 4653
  title: Sherloq: Collaborative SQL Code Management for Data Analysts
  tldr:
  short_description: Collaborate and manage SQL queries with Sherloq's AI-powered plug-in. Save time and focus on data analysis.
  introduction_title: AI SQL Query Builder: Sherloq - Revolutionizing Data Analysis with Collaborative Code Management
  introduction_body: AI SQL query builders like Sherloq are transforming how data analysts work. Sherloq is the one place for all your ad-hoc SQL queries. Using the AI SQL repo plug-in, you can collaboratively manage, save, and share your SQL code, without leaving your IDE. Stop those frustrating where the fck did I put that SQL moments and focus on data analysis. With Sherloq, you'll streamline your workflow, enhance collaboration, and ultimately become more efficient in your data-driven tasks.
  is_active: 1
  created_at: 2025-07-23T06:17:37.581901
  updated_at: 2025-07-27T08:11:20.221553
  

---

social_media

• tool_id: 4653
  network_id: 12
  social_media_url: https://linkedin.com/company/sherloqdata
  is_active: 1
  created_at: 2025-07-01T18:37:06.603568
  id: 6047
  updated_at: 2025-07-27T08:14:10.033253
  

---

tags

• tool_id: 4653
  tag_id: 297
  weight: 1
  is_active: 1
  created_at: 2025-07-23T06:17:37.581901
  id: 18219
  updated_at: 2025-07-27T08:14:35.369098
  

---

• tool_id: 4653
  tag_id: 41
  weight: 2
  is_active: 1
  created_at: 2025-07-23T06:17:37.581901
  id: 18220
  updated_at: 2025-07-27T08:14:35.369098
  

---

• tool_id: 4653
  tag_id: 17
  weight: 3
  is_active: 1
  created_at: 2025-07-23T06:17:37.581901
  id: 18221
  updated_at: 2025-07-27T08:14:35.369098
  

---

• tool_id: 4653
  tag_id: 38
  weight: 4
  is_active: 1
  created_at: 2025-07-23T06:17:37.581901
  id: 18222
  updated_at: 2025-07-27T08:14:35.369098
  

---

• tool_id: 4653
  tag_id: 11
  weight: 5
  is_active: 1
  created_at: 2025-07-23T06:17:37.581901
  id: 18223
  updated_at: 2025-07-27T08:14:35.369098
  

---

toolsets

• tool_id: 4653
  toolset_id: 17
  weight: 1
  is_active: 1
  created_at: 2025-07-23T06:17:37.581901
  id: 47736
  updated_at: 2025-07-27T08:15:00.645841
  

---

• tool_id: 4653
  toolset_id: 12
  weight: 2
  is_active: 1
  created_at: 2025-07-23T06:17:37.581901
  id: 47737
  updated_at: 2025-07-27T08:15:00.645841
  

---

• tool_id: 4653
  toolset_id: 18
  weight: 3
  is_active: 1
  created_at: 2025-07-23T06:17:37.581901
  id: 47738
  updated_at: 2025-07-27T08:15:00.645841
  

---

jobs

• tool_id: 4653
  job_id: 16
  weight: 1
  is_active: 1
  created_at: 2025-07-23T06:17:37.581901
  id: 110926
  updated_at: 2025-07-27T08:12:08.543303
  

---

• tool_id: 4653
  job_id: 21
  weight: 2
  is_active: 1
  created_at: 2025-07-23T06:17:37.581901
  id: 110927
  updated_at: 2025-07-27T08:12:08.543303
  

---

• tool_id: 4653
  job_id: 27
  weight: 3
  is_active: 1
  created_at: 2025-07-23T06:17:37.581901
  id: 110928
  updated_at: 2025-07-27T08:12:08.543303
  

---

• tool_id: 4653
  job_id: 4
  weight: 4
  is_active: 1
  created_at: 2025-07-23T06:17:37.581901
  id: 110929
  updated_at: 2025-07-27T08:12:08.543303
  

---

platforms

• tool_id: 4653
  platform_id: 1
  priority: 1
  platform_url: https://sherloqdata.io
  is_active:
  created_at: 2025-07-23T06:17:37.581901
  id: 4651
  updated_at: 2025-08-15T20:53:40.074
  

---

• tool_id: 4653
  platform_id: 1
  priority: 1
  platform_url: https://sherloqdata.io
  is_active: 1
  created_at: 2025-08-15T17:23:41.766314
  id: 34222
  updated_at: 2025-08-15T17:23:41.766314
  

---

• tool_id: 4653
  platform_id: 15
  priority:
  platform_url: https://plugins.jetbrains.com/plugin/22201-sherloq--save-share--simplify-your-queries
  is_active: 1
  created_at: 2025-09-17T13:31:09.718329
  id: 64037
  updated_at: 2025-09-17T13:31:09.718329
  

---

score_log

• log_id: 202990
  tool_id: 4653
  final_score: 3.99
  logged_at: 2025-09-17T22:25:01.51939
  change_reason: New rating added | Coverage: 8.6% | Penalty: 0.8982
  triggered_by: System
  source_summary: Similar web Raiting: 4.443165815 (w=58.000) | Base Score: 4.443 | Final: 3.991
  final_score_2: 3.9908648645
  

---

• log_id: 181244
  tool_id: 4653
  final_score: 3.87
  logged_at: 2025-08-19T16:20:53.067949
  change_reason: rating_sources changed | Coverage: 8.6% | Penalty: 0.8982
  triggered_by: System
  source_summary: Similar web Raiting: 4.309687144 (w=58.000) | Base Score: 4.310 | Final: 3.871
  final_score_2: 3.8709739218
  

---

• log_id: 165699
  tool_id: 4653
  final_score: 3.88
  logged_at: 2025-08-19T16:20:25.813463
  change_reason: rating_sources changed | Coverage: 10.2% | Penalty: 0.8999
  triggered_by: System
  source_summary: Similar web Raiting: 4.309687144 (w=59.000) | Base Score: 4.310 | Final: 3.878
  final_score_2: 3.8784124418
  

---

• log_id: 147262
  tool_id: 4653
  final_score: 3.87
  logged_at: 2025-08-12T06:15:25.263278
  change_reason: Rating source weights updated | Coverage: 8.6% | Penalty: 0.8982
  triggered_by: System
  source_summary: Similar web Raiting: 4.309687144 (w=58.000) | Base Score: 4.310 | Final: 3.871
  final_score_2: 3.8709739218
  

---

• log_id: 129025
  tool_id: 4653
  final_score: 3.88
  logged_at: 2025-08-11T16:36:22.187859
  change_reason: Applied precise penalty formula - Similar Web = 4.5 | Coverage: 10.2% | Penalty: 0.9000
  triggered_by: Manual Refresh
  source_summary: Similar web Raiting: 4.309687144 (w=49.000) | Base Score: 4.310 | Final: 3.879
  final_score_2: 3.8785762099
  

---

• log_id: 117892
  tool_id: 4653
  final_score: 3.34
  logged_at: 2025-08-11T16:32:06.680827
  change_reason: Applied milder penalty formula - v2 | Coverage: 10.2% | Penalty: 0.776
  triggered_by: Manual Refresh
  source_summary: Similar web Raiting: 4.309687144 (w=49.000) | Base Score: 4.310 | Final: 3.342
  final_score_2: 3.342205477
  

---

• log_id: 106759
  tool_id: 4653
  final_score: 2.37
  logged_at: 2025-08-11T16:28:07.06408
  change_reason: Applied new fair penalty system | Coverage: 10.2% | Penalty: 0.551
  triggered_by: Manual Refresh
  source_summary: Similar web Raiting: 4.309687144 (w=49.000) | Base Score: 4.310 | Final: 2.375
  final_score_2: 2.3747281198
  

---

• log_id: 95626
  tool_id: 4653
  final_score: 4.31
  logged_at: 2025-08-11T16:16:08.254948
  change_reason: weights updated to defaults
  triggered_by: Manual
  source_summary: Similar web Raiting: 4.309687144 (w=49.000)
  final_score_2: 4.309687144
  

---

• log_id: 69282
  tool_id: 4653
  final_score: 0.44
  logged_at: 2025-08-11T16:10:08.878468
  change_reason: weights updated to defaults
  triggered_by: Manual
  source_summary: Similar web Raiting: 4.309687144 (w=5.00)
  final_score_2: 0.4397639943
  

---

• log_id: 64537
  tool_id: 4653
  final_score: 4.31
  logged_at: 2025-08-11T14:08:37.141652
  change_reason: New rating added
  triggered_by: System
  source_summary: Similar web Raiting: 4.309687144 (w=1.0000)
  final_score_2: 4.309687144
  

---

• log_id: 34176
  tool_id: 4653
  final_score: 3.84
  logged_at: 2025-06-28T07:38:11.151992
  change_reason: New rating added
  triggered_by: System
  source_summary: Similar web Raiting: 3.844145000 (weight: 1.0000)
  final_score_2: 3.844145
  

---

last_update

• tool_id: 4653
  last_update: 2025-08-31T13:44:14.852057
  

---