Skip to content
agentusehub

Hunt for unpatched vulnerabilities in SQLite commits

Google's Big Sleep agent reviewed recent SQLite commits starting from a patched bug and found an exploitable flaw, which was fixed before release.

Time saved
Not reported
Setup time
Not reported
Running cost
Not reported
Cost range
Not reported

Use case overview

Google's Big Sleep agent reviewed recent SQLite commits starting from a patched bug and found an exploitable flaw, which was fixed before release.

Reported experience

  1. What they did

    A Gemini 1.5 Pro agent ran in Project Zero's Naptime framework, which gives it a code browser, debugger, reporter tool and a sandbox for Python scripts. Researchers gave it a previously fixed SQLite bug, plus recent commit messages and diffs, and asked it to look for unresolved similar issues. It linked the old bug to other code, wrote a test case, triggered a crash, and produced a root-cause analysis.

  2. How it went

    It found a stack buffer underflow in seriesBestIndex, and SQLite fixed it the same day, before any release. Fuzzing for 150 CPU hours failed to rediscover it. The team calls Big Sleep highly experimental.

  3. Worth knowing

    The bug was in a development version only. The researchers think a target-specific fuzzer would likely be at least as effective as the agent today.

Example prompts

Try with Gemini
In this repo [path or URL], review the commits from the last [time period or number], starting with the fix for [known patched bug or commit]. Look for similar flaws that the fix may have missed, especially [bug class, e.g. memory safety]. Write a report listing each suspect commit, why it looks vulnerable, and how you'd confirm it. Don't modify the code or disclose anything publicly.
Operations · Intermediate
  1. Label contract email
  2. Extract terms
  3. Log in Sheets

Track vendor contract renewals before they auto-renew

Make pulls contracts from Gmail, Gemini extracts the term and notice period, and a Sheets register emails the owner 60, 30 and 7 days before each deadline.

Gmail · Make · Gemini · Google Sheets
Personal Productivity · Intermediate
  1. 7am schedule
  2. Gather inputs
  3. Prioritise

Morning brief of your meetings, emails and open tasks

A self-hosted n8n job reads your calendar, unread email and Notion tasks at 7am and sends one short brief of what matters today.

n8n · Gmail · Notion · Gemini