Docker + Steampipe

select
  instruction,
  data
from
  dockerfile_instruction
order by
  start_line;

+-------------+--------------------------------------------------------------------------+
| instruction | data                                                                     |
+-------------+--------------------------------------------------------------------------+
| from        | {"image":"node","tag":"12-alpine"}                                       |
| run         | {"commands":["apk add --no-cache python g++ make"],"prepend_shell":true} |
| workdir     | {"path":"/app"}                                                          |
| copy        | {"dest":".","sources":["."]}                                             |
| run         | {"commands":["yarn install --production"],"prepend_shell":true}          |
| cmd         | {"commands":["node","src/index.js"]}                                     |
+-------------+--------------------------------------------------------------------------+

steampipe plugin install docker

connection "docker" {
  plugin = "docker"

  # dockerfile_paths is a list of locations to search for Dockerfiles
  # dockerfile_paths can be configured with a local directory, a remote Git repository URL, or an S3 bucket URL
  # Wildcard based searches are supported, including recursive searches
  # Local dockerfile_paths are resolved relative to the current working directory (CWD)

  # For example:
  #  - "*.dockerfile" matches all Dockerfiles in the CWD
  #  - "**/*.dockerfile" matches all Dockerfiles in the CWD and all sub-directories
  #  - "../*.dockerfile" matches all Dockerfiles in the CWD's parent directory
  #  - "Dockerfile.*" matches all Dockerfiles starting with "Dockerfile" in the CWD
  #  - "/path/to/dir/*.dockerfile" matches all Dockerfiles in a specific directory
  #  - "/path/to/dir/Dockerfile" matches a specific Dockerfile

  # If dockerfile_paths includes "*", all files (including non-Dockerfiles) in
  # the CWD will be matched, which may cause errors if incompatible file types exist

  # Defaults to CWD
  dockerfile_paths = [ "Dockerfile", "*.dockerfile" ]

  # docker_compose_file_paths is a list of locations to search for Docker Compose files
  # docker_compose_file_paths can be configured with a local directory, a remote Git repository URL, or an S3 bucket URL
  # Wildcard based searches are supported, including recursive searches
  # Local docker_compose_file_paths are resolved relative to the current working directory (CWD)

  # For example:
  #  - "*.yml" or "*.yaml" matches all Docker Compose files in the CWD
  #  - "**/*.yml" matches all Docker Compose files in the CWD and all sub-directories
  #  - "../*.yml" matches all Docker Compose files in the CWD's parent directory
  #  - "/path/to/dir/*.yml" matches all Docker Compose files in a specific directory
  #  - "/path/to/dir/compose.yml" matches a specific Docker Compose file

  # If docker_compose_file_paths includes "*", all files (including non-DockerComposefiles) in
  # the CWD will be matched, which may cause errors if incompatible file types exist

  # Defaults to CWD
  docker_compose_file_paths = ["compose.yml", "*compose.yml"]

  # Optional docker engine configuration.
  # host        = "tcp://192.168.59.103:2376"
  # cert_path   = "/path/to/my-cert"
  # api_version = "1.41"
  # tls_verify  = true
}

connection "docker" {
  plugin = "docker"

  dockerfile_paths = [
    "Dockerfile",
    "*.dockerfile",
    "~/*.dockerfile",
    "github.com/komljen/dockerfile-examples//*.dockerfile",
    "github.com/komljen/dockerfile-examples//**/Dockerfile",
    "gitlab.com/gitlab-examples/docker//Dockerfile",
    "bitbucket.org/fscm/docker-docker//Dockerfile",
    "s3::https://bucket.s3.ap-southeast-1.amazonaws.com/Dockerfile"
  ]

  docker_compose_file_paths = [
    "compose.yml",
    "*.yml",
    "~/*.yml",
    "github.com/komljen/dockercomposefile-examples//*.yml",
    "github.com/komljen/dockercomposefile-examples//**/DockerComposefile",
    "gitlab.com/gitlab-examples/docker//DockerComposefile",
    "bitbucket.org/fscm/docker-docker//DockerComposefile",
    "s3::https://bucket.s3.ap-southeast-1.amazonaws.com/DockerComposefile"
  ]
}

connection "docker" {
  plugin = "docker"

  dockerfile_paths = [ "*.dockerfile", "~/*.dockerfile", "/path/to/dir/Dockerfile" ]

  docker_compose_file_paths = [ "*compose.yml", "~/*.yml", "/path/to/dir/compose.yml" ]
}

connection "docker" {
  plugin = "docker"

  dockerfile_paths = [ "github.com/komljen/dockerfile-examples//ghost//Dockerfile" ]

  docker_compose_file_paths = [ "github.com/komljen/dockerComposefile-examples//ghost//DockerComposefile" ]
}

connection "docker" {
  plugin = "docker"

  dockerfile_paths = [
    "github.com/komljen/dockerfile-examples//**/Dockerfile",
    "github.com/komljen/dockerfile-examples//ghost//Dockerfile",
    "gitlab.com/gitlab-examples/docker//Dockerfile",
    "gitlab.com/gitlab-examples/docker//**/Dockerfile"
    "bitbucket.org/fscm/docker-docker//Dockerfile",
    "bitbucket.org/fscm/docker-docker//**/Dockerfile"
  ]

  docker_compose_file_paths = [
    "github.com/komljen/dockerComposefile-examples//**/DockerComposefile",
    "github.com/komljen/dockerComposefile-examples//ghost//DockerComposefile",
    "gitlab.com/gitlab-examples/docker//DockerComposefile",
    "gitlab.com/gitlab-examples/docker//**/DockerComposefile"
    "bitbucket.org/fscm/docker-docker//DockerComposefile",
    "bitbucket.org/fscm/docker-docker//**/DockerComposefile"
  ]
}

connection "docker" {
  plugin = "docker"

  dockerfile_paths = [
    "s3::https://bucket-2.s3.us-east-1.amazonaws.com//Dockerfile?aws_profile=<AWS_PROFILE>",
    "s3::https://bucket-2.s3.us-east-1.amazonaws.com/test_folder//*.dockerfile?aws_profile=<AWS_PROFILE>"
  ]

  docker_compose_file_paths = [
    "s3::https://bucket-2.s3.us-east-1.amazonaws.com//DockerComposefile?aws_profile=<AWS_PROFILE>",
    "s3::https://bucket-2.s3.us-east-1.amazonaws.com/test_folder//*.yml?aws_profile=<AWS_PROFILE>"
  ]
}

{
  "Version": "2012-10-17",
  "Statement": [
    {
      "Sid": "ReadBucketObject",
      "Effect": "Allow",
      "Principal": {
        "AWS": "arn:aws:iam::123456789012:user/YOUR_USER"
      },
      "Action": ["s3:ListBucket", "s3:GetObject", "s3:GetObjectVersion"],
      "Resource": ["arn:aws:s3:::test-bucket1", "arn:aws:s3:::test-bucket1/*"]
    }
  ]
}

connection "docker" {
  plugin = "docker"

  dockerfile_paths = [
    "s3::https://bucket-1.s3.us-east-1.amazonaws.com/test_folder//Dockerfile",
    "s3::https://bucket-2.s3.us-east-1.amazonaws.com/test_folder//**/*.dockerfile"
  ]

  docker_compose_file_paths = [
    "s3::https://bucket-1.s3.us-east-1.amazonaws.com/test_folder//DockerComposefile",
    "s3::https://bucket-2.s3.us-east-1.amazonaws.com/test_folder//**/*.yml"
  ]
}

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

CREATE EXTENSION IF NOT EXISTS steampipe_postgres_docker;
CREATE SERVER steampipe_docker FOREIGN DATA WRAPPER steampipe_postgres_docker OPTIONS (config '<your_config>');
CREATE SCHEMA docker;
IMPORT FOREIGN SCHEMA docker FROM SERVER steampipe_docker INTO docker;

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

$ sqlite3
sqlite> .load ./steampipe_sqlite_extension_docker.so
sqlite> select steampipe_configure_docker('<your_config>');

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

steampipe_export_docker --config '<your_config>' <table_name>