Using Steampipe in Gitpod

Gitpod is an open source platform provisioning ready-to-code developer environments that integrates with GitHub. Here we integrate a Github project with Gitpod to install Steampipe, then install a plugin and run a query.

Installing Steampipe in Gitpod

To run scripts, first connect your GitHub repository to your Gitpod workspace and create a .gitpod.yml file that contains the definitions. Here's an example that installs Steampipe.

tasks:
  - name: Install Steampipe with RSS Plugin
    init: |
      sudo /bin/sh -c "$(curl -fsSL https://raw.githubusercontent.com/turbot/steampipe/main/install.sh)"
      steampipe -v

Running Steampipe in Gitpod

In order to run Steampipe commands, we will first install the RSS plugin.

tasks:
  - name: Install Steampipe with RSS Plugin
    init: |
      sudo /bin/sh -c "$(curl -fsSL https://raw.githubusercontent.com/turbot/steampipe/main/install.sh)"
      steampipe -v
      steampipe plugin install steampipe
      steampipe plugin install rss

ports:
 # Steampipe/ PostgreSQL
  - port: 9193

Next, we'll update the file with a query to list items from an RSS feed.

tasks:
  - name: Install Steampipe with RSS Plugin
    init: |
      sudo /bin/sh -c "$(curl -fsSL https://raw.githubusercontent.com/turbot/steampipe/main/install.sh)"
      steampipe -v
      steampipe plugin install steampipe
      steampipe plugin install rss
      steampipe query "select title, published, link from rss_item where feed_link = 'https://www.hardcorehumanism.com/feed/' order by published desc;"
    command: |
      steampipe service status

ports:
 # Steampipe/ PostgreSQL
  - port: 9193

That's it! Now you can use any of Steampipe's plugins and mods in your Gitpod workspace.