Table: onepassword_vault - Query 1Password Vaults using SQL

A Vault in 1Password is a secure location where users can store sensitive information, such as passwords, credit card details, and secure notes. Vaults help in organizing information, making it easier to find and share. They provide an additional layer of security as each vault can have separate permissions.

Table Usage Guide

The onepassword_vault table provides insights into Vaults within 1Password. As a security administrator, explore vault-specific details through this table, including vault UUID, name, description, and associated metadata. Utilize it to uncover information about vaults, such as their access controls, the type of information stored, and the organization of secure data.

Examples

Basic info

Explore the creation and modification details of your 1Password vaults. This allows you to keep track of vault updates and understand their types and descriptions for better management.

select
  id,
  name,
  created_at,
  description,
  type,
  updated_at
from
  onepassword_vault;

select
  id,
  name,
  created_at,
  description,
  type,
  updated_at
from
  onepassword_vault;

List vaults created in the last 30 days

Discover the segments that have recently added secure vaults in the past month. This is useful for tracking the creation of new storage spaces for sensitive information.

select
  id,
  name,
  created_at,
  description,
  type,
  updated_at
from
  onepassword_vault
where
  created_at >= now() - interval '30 day';

select
  id,
  name,
  created_at,
  description,
  type,
  updated_at
from
  onepassword_vault
where
  created_at >= datetime('now', '-30 day');

Show vaults with zero items

Discover the segments that have zero items stored in them to understand where storage is currently unused or potentially unutilized. This can be useful in identifying areas for better resource allocation or for detecting any anomalies.

select
  id,
  name,
  created_at,
  items,
  description,
  type,
  updated_at
from
  onepassword_vault
where
  items = 0;

select
  id,
  name,
  created_at,
  items,
  description,
  type,
  updated_at
from
  onepassword_vault
where
  items = 0;

Show personal vaults

Discover the segments that comprise your personal vaults. This query is useful for gaining insights into your individual vaults, including when they were created and last updated, and what items they contain.

select
  id,
  name,
  created_at,
  items,
  description,
  type,
  updated_at
from
  onepassword_vault
where
  type = 'PERSONAL';

select
  id,
  name,
  created_at,
  items,
  description,
  type,
  updated_at
from
  onepassword_vault
where
  type = 'PERSONAL';

Schema for onepassword_vault

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
attr_version	bigint		The version of the vault metadata.
content_version	bigint		The version of the vault contents.
created_at	timestamp with time zone		Date and time when the vault was created.
description	text		The description for the vault.
id	text	=	The UUID of the vault.
items	bigint		Number of active items in the vault.
name	text		The name of the vault.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
title	text		The title of the vault.
type	text		The type of vault. Possible values are EVERYONE, PERSONAL and USER_CREATED.
updated_at	timestamp with time zone		Date and time when the vault or its contents were last changed.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- onepassword

You can pass the configuration to the command with the --config argument:

steampipe_export_onepassword --config '<your_config>' onepassword_vault