Table: hcloud_ssh_key - Query Hetzner Cloud SSH Keys using SQL

Hetzner Cloud SSH Key is a resource in Hetzner Cloud that allows users to authenticate without using a password. SSH keys provide a more secure way of logging into a virtual private server with SSH than using a password alone. It is a highly recommended way of managing server authentication.

Table Usage Guide

The hcloud_ssh_key table provides insights into SSH keys within Hetzner Cloud. As a system administrator, explore key-specific details through this table, including names, fingerprints, and associated metadata. Utilize it to uncover information about keys, such as their fingerprints, the creation and modification dates, and the verification of key details.

Examples

List all SSH keys

Explore all SSH keys within your system to gain a comprehensive overview of your security mechanisms. This can be particularly useful when auditing system security or troubleshooting access issues.

select
  *
from
  hcloud_ssh_key;

select
  *
from
  hcloud_ssh_key;

Oldest SSH keys

Explore which SSH keys have been in use the longest to assess potential security vulnerabilities and update protocols as necessary.

select
  name,
  fingerprint,
  created
from
  hcloud_ssh_key
order by
  created
limit
  5;

select
  name,
  fingerprint,
  created
from
  hcloud_ssh_key
order by
  created
limit
  5;

Schema for hcloud_ssh_key

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
created	timestamp with time zone		Point in time when the SSH key was created.
fingerprint	text	=	Fingerprint of public key.
id	bigint	=	ID of the SSH key.
labels	jsonb		User-defined labels (key-value pairs).
name	text	=	Name of the SSH key. Must be unique per project.
public_key	text		Public key.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.

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)" -- hcloud

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

steampipe_export_hcloud --config '<your_config>' hcloud_ssh_key