>sqlite3
Sqlite3 queries SQLite databases. Attackers use it to query Chrome and Safari cookies, browsing history, and notes databases without launching browsers.
Default Executable Paths
/usr/bin/sqlite3Integrity & Metadata
SQLite databases in ~/Library/Application Support contain sensitive session tokens and credentials.
Detect sqlite3 command targeting browser cookies or history databases.
Executive Summary & AI Quick Reference
sqlite3 is a native utility pre-installed on macOS systems. Threat actors and red teams abuse sqlite3 as a Living-off-the-Land Binary (LOLBin) to achieve Credential Dump without triggering traditional antivirus file-hash alerts. Legitimate system administrators use it for routine administration, making behavioral command-line telemetry essential for differentiation.
Weaponized Parameters & Proof-of-Concepts
Documented attack commands, parameter flags, and privilege prerequisites.
Queries encrypted session cookies from the local Chrome cookie database.
sqlite3 ~/Library/Application\ Support/Google/Chrome/Default/Cookies "SELECT host_key, name, encrypted_value FROM cookies"SIEM & EDR Detection Rules
Production telemetry rules configured for Microsoft Defender, Sigma, and Splunk.
Telemetry & SIEM Detection Suite (sqlite3)
Validated against MITRE T1539, T10051DeviceProcessEvents | where FileName =~ "sqlite3" | where ProcessCommandLine has_any ("Cookies", "History", "TCC.db", "Safari") | project Timestamp, DeviceName, AccountName, ProcessCommandLineMitigation, Hardening & Prevention
Recommended defensive controls to block or constrain sqlite3 abuse.
Enforce strict Endpoint Security Framework (ESF) policies and mobile device management (MDM) profile restrictions blocking unsigned scripts.
Configure Apple Gatekeeper and restrict Terminal / osascript execution through strict Transparency, Consent, and Control (TCC) profiles.
Deploy the KQL, Sigma, and Splunk detection queries below. Alert on anomalous child processes, web requests to unrated external IPs, or encoded payload strings.
Frequently Asked Questions (FAQ) • sqlite3
Key operational questions and defensive answers about sqlite3 LOLBin tradecraft.
What is sqlite3 and why is it classified as a LOLBin?
sqlite3 is a legitimate, pre-installed or trusted utility on macOS. It is classified as a Living-off-the-Land Binary (LOLBin) because adversaries abuse its built-in functionality to perform malicious operations—such as Credential Dump—without dropping custom malware binaries on disk.
How do threat actors abuse sqlite3 in cyber intrusions?
Adversaries leverage sqlite3 to execute stealthy actions while evading signature-based security controls. For example, attackers execute commands like "sqlite3 ~/Library/Application\ Support/Google/Chrome/Default/Cookies "SELECT host_key, name, encrypted_value FROM cookies"" to achieve Credential Dump, masquerading behind legitimate system process lineage.
How can SOC analysts detect suspicious sqlite3 activity?
Detection engineers monitor process creation events (Windows Event ID 4688 or Sysmon Event ID 1; Linux auditd EXECVE; macOS Endpoint Security) inspecting anomalous command line arguments, unusual parent-child process relationships (e.g. Office apps or web servers spawning sqlite3), and unexpected network connections.
What MITRE ATT&CK techniques does sqlite3 map to?
sqlite3 maps to MITRE ATT&CK technique(s): T1539, T1005. These techniques cover adversary actions across tactics such as Defense Evasion, Execution, Persistence, and Command and Control.
How can organizations mitigate and restrict sqlite3?
Mitigation strategies include implementing Application Control policies (AppLocker or Windows Defender Application Control - WDAC), enforcing Attack Surface Reduction (ASR) rules, configuring strict privilege separation (disallowing standard users from running sensitive switches), and alerting on execution from non-standard directories.
Other High-Traffic MACOS LOLBins
Osascript executes Open Scripting Architecture (OSA) scripts such as AppleScript and JavaScript for Automation (JXA). Widely used in macOS malware to display convincing phishing dialogs, harvest credentials, control System Events, and execute shell commands.
The open command opens files, directories, URLs, and applications as if you double-clicked them in Finder. Used to launch unsigned or quarantined applications and evade Gatekeeper or security software inspection.
Curl is standard on macOS and frequently invoked in bash/zsh shell scripts by macOS stealers (e.g. Atomic macOS Stealer / AMOS) to fetch stage 2 Mach-O executables or exfiltrate keychain data.
Directory Service command-line utility (dscl) allows reading and writing Directory Service databases. Attackers use dscl for local user discovery, creating hidden administrator accounts, or extracting password hashes.