Table: fly_app - Query Fly Apps using SQL

Fly App is a resource within Fly.io that allows you to deploy and manage applications. It provides a platform for developers to build, deploy, and scale applications in a consistent manner. Fly App helps you manage the lifecycle of your applications, ensuring they are always up-to-date and running efficiently.

Table Usage Guide

The fly_app table provides insights into Fly Apps. As a developer or a DevOps engineer, explore app-specific details through this table, including configurations, statuses, and associated metadata. Utilize it to uncover information about apps, such as their current status, configurations, and other crucial details that can help in managing and scaling applications efficiently.

Examples

Basic info

Explore which applications are currently active, by assessing their status and associated URLs. This can help in managing and monitoring the applications more effectively.

select
  name,
  app_url,
  status,
  hostname
from
  fly_app;

select
  name,
  app_url,
  status,
  hostname
from
  fly_app;

List suspended apps

Explore which applications have been suspended, providing a way to manage and review their status and further action. This is useful for maintaining the health and efficiency of your application environment.

select
  name,
  app_url,
  status,
  hostname
from
  fly_app
where
  status = 'suspended';

select
  name,
  app_url,
  status,
  hostname
from
  fly_app
where
  status = 'suspended';

List unencrypted volumes attached to the instances

This query helps to identify any unencrypted volumes attached to applications, which is crucial for maintaining data security and compliance. It's a practical tool for reviewing and rectifying potential vulnerabilities in your system.

select
  a.name,
  v.name,
  v.encrypted
from
  fly_app as a
  join fly_volume as v on v.app_id = a.id
  and not v.encrypted;

select
  a.name,
  v.name,
  v.encrypted
from
  fly_app as a
  join fly_volume as v on v.app_id = a.id
  and v.encrypted = 0;

List apps with unverified certificates

Discover the segments that contain applications with unverified certificates. This is useful in identifying potential security risks within your system.

select
  a.name as app_name,
  a.status,
  c.domain,
  c.hostname
from
  fly_app as a
  join fly_app_certificate as c on a.id = c.app_id
  and not c.verified;

select
  a.name as app_name,
  a.status,
  c.domain,
  c.hostname
from
  fly_app as a
  join fly_app_certificate as c on a.id = c.app_id
  and c.verified = 0;

Schema for fly_app

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
app_url	text		The URL of the app.
autoscaling	jsonb		Specifies the autoscaling information.
config	jsonb		Specifies the app configuration.
current_release_id	text		Specifies the ID of the current app release.
deployed	boolean		If true, the app is successfully deployed.
health_checks	jsonb		Specifies the app health check information.
hostname	text		The hostname of the app.
id	text		A unique identifier of the app.
ip_addresses	jsonb		A list of IP addresses associated with the app.
name	text	=	The name of the app.
network	text		Specifies the app network.
organization	jsonb		Specifies the organization details where the app is deployed.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
status	text		The status of the app.

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

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

steampipe_export_fly --config '<your_config>' fly_app