Table: hcloud_server_type - Query Hetzner Cloud Server Types using SQL

Hetzner Cloud Server Types are predefined configurations of servers available for use in Hetzner Cloud. Each server type comes with a specific set of resources, such as CPU cores, memory, and disk space. These server types are designed to accommodate a wide range of computing needs, from small-scale applications to large-scale enterprise projects.

Table Usage Guide

The hcloud_server_type table provides insights into the server types within Hetzner Cloud. As a system administrator or a DevOps engineer, explore server type-specific details through this table, including CPU cores, memory, disk size, and more. Utilize it to uncover information about server types, such as those with specific resource configurations, to help in selecting the most suitable server type for your application or project.

Examples

List all server types

Discover the different server types available in your infrastructure, which can help you understand your resource distribution and inform decisions about capacity planning or resource allocation.

select
  name,
  description
from
  hcloud_server_type
order by
  name;

select
  name,
  description
from
  hcloud_server_type
order by
  name;

Get all server types with pricing

Explore various server types alongside their pricing details to make informed decisions about cost management and resource allocation. This can help in optimizing your spending by choosing the most cost-effective server type for your needs.

select
  st.name,
  st.description,
  (p -> 'Hourly' ->> 'Net') :: float as hourly_net,
  (p -> 'Monthly' ->> 'Net') :: float as monthly_net
from
  hcloud_server_type as st,
  jsonb_array_elements(st.prices) as p
order by
  hourly_net;

select
  st.name,
  st.description,
  cast(json_extract(p.value, '$.Hourly.Net') as float) as hourly_net,
  cast(json_extract(p.value, '$.Monthly.Net') as float) as monthly_net
from
  hcloud_server_type as st,
  json_each(st.prices) as p
order by
  hourly_net;

Schema for hcloud_server_type

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
cores	bigint		Number of cpu cores a Server of this type will have.
cpu_type	text		Type of CPU: shared, dedicated.
description	text		Description of the Server Type.
disk	bigint		Disk size a Server of this type will have in GB.
id	bigint	=	ID of the Server Type.
memory	double precision		Memory a Server of this type will have in GB.
name	text	=	Unique identifier of the Server Type.
prices	jsonb		Prices in different Locations.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
storage_type	text		Type of Server boot drive. local has higher speed. network has better availability.

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_server_type