Introducing AI-assisted query creation in 1Password Device Trust

Today we're shipping a new capability directly into 1Password Device Trust that lets admins query their fleets faster, without needing to be SQL experts. Now you can describe what you want to investigate in plain English, and Device Trust generates a ready-to-run SQL query you can execute across your devices in a single click.

What Device Trust does

1Password Device Trust gives IT and security teams visibility and control over every device accessing company resources. It continuously checks devices against your security policies, surfacing issues like outdated software, disabled firewalls, and missing encryption, and blocks access when a device falls out of compliance. Under the hood, it uses both osquery and additional proprietary information that collect real-time data directly from endpoints, giving admins a live, queryable view across their devices.

That last part is where this new capability comes in.

The pain with writing queries today

Osquery is powerful, but writing correct, performant SQL takes specialized SQL and DB schema knowledge that most admins don't have on demand, especially during an active investigation. Even experienced users spend time getting syntax right, scoping predicates correctly, and avoiding patterns that are heavy on resources, or return noisy or slow results at scale. This capability clears that barrier while keeping the admin in control.

From question to query in seconds

To use this AI-assisted query builder, open it from the Device Trust Tools section, describe what you want to find, and leverage it to find real-time information across your fleet.

Some examples of what you can ask:

• "Check all Windows devices to see if PowerShell is disabled"

• "Which devices have AI desktop apps like ChatGPT, Claude, or Cursor installed?"

• "Which macOS devices have FileVault disabled?"

• "Find devices running Chrome older than a specific version"

• "Which devices have remote-access tools like AnyDesk or TeamViewer installed?"

It also works on queries you've already written. Paste existing SQL in the builder and it will tighten your filters, narrow the query to only the columns you need, and recommend more efficient patterns so it runs faster and returns cleaner results.

Transparent by design

Every generated query also allows you to preview the SQL before anything runs. You can review the query before running it and select the devices you wish to run it on, whether that’s a subset of the devices or all of them. For admins who want to sharpen their osquery skills, that output is also a reference for what a well-scoped, efficient query looks like in practice.

Part of how 1Password builds with AI

This is one of several AI capabilities we're building across 1Password’s suite of products, all designed around the same idea: AI should make security teams faster without asking them to give up control. You describe what you need, you see exactly what will run, and you decide what to do next.