Sigma rule: Suspicious SQL Query

A detection rule from the SigmaHQ repository, shown as its author published it. Dataset version ref-c689c4b183d8, updated 2022-12-27T00:00:00.000Z.

Rule

Title
Suspicious SQL Query
Status
test
Level
medium
Author
@juju4
Date
2022-12-27
File
rules/category/database/db_anomalous_query.yml
Commit
ccbb0369507f796db0b0ae6854c8a2be471b9d84

Detects suspicious SQL query keywrods that are often used during recon, exfiltration or destructive activities. Such as dropping tables and selecting wildcard fields

Log source

category
database
definition
Requirements: Must be able to log the SQL queries

Detection

keywords:
    - 'drop'
    - 'truncate'
    - 'dump'
    - 'select \*'
condition: keywords

False positives (as the rule lists them)

  • Inventory and monitoring activity
  • Vulnerability scanners
  • Legitimate applications

Tags

  • attack.exfiltration
  • attack.initial-access
  • attack.privilege-escalation
  • attack.persistence
  • attack.t1190
  • attack.t1505.001

MITRE ATT&CK ids this rule names

References

Read on 2026-11-03T00:58:21.399Z under licence sigma-drl-1.1@d5f4c36a from https://github.com/SigmaHQ/sigma/blob/ccbb0369507f796db0b0ae6854c8a2be471b9d84/rules/category/database/db_anomalous_query.yml

Sources and licences

  • SigmaHQ

    "Suspicious SQL Query" by @juju4 (SigmaHQ). Rule: https://github.com/SigmaHQ/sigma/blob/ccbb0369507f796db0b0ae6854c8a2be471b9d84/rules/category/database/db_anomalous_query.yml.
    Licensed under the Detection Rule License (DRL) 1.1: https://github.com/SigmaHQ/Detection-Rule-License

    Detection Rule License (DRL) 1.1

Cite this page

Dragons Eye Ransomware Tracker, "Sigma rule: Suspicious SQL Query",
entity page, dataset version ref-c689c4b183d8, updated 2022-12-27T00:00:00.000Z,
https://ransomware-tracker.com/detections/sigma/d84c0ded-edd7-4123-80ed-348bb3ccc4d5 (accessed 2026-11-03).
Underlying source: SigmaHQ rule d84c0ded-edd7-4123-80ed-348bb3ccc4d5, commit ccbb0369507f796db0b0ae6854c8a2be471b9d84.

Pages change. The dataset version identifies the data, but no archive of old versions is kept, so this citation cannot be replayed later.