steampipe plugin install francois2metz/airtable

Airtable + Steampipe

Airtable is an easy-to-use online platform for creating and sharing relational databases.

Steampipe is an open source CLI to instantly query cloud APIs using SQL.

For example:

select
id,
"Name"
from
appid_design_projects
+--------------------+--------------------------+
| id | Name |
+--------------------+--------------------------+
| recHQSd02Tjhba3ue | Coffee packaging |
| rec1x6H2wuyJArcwM | EngineerU brand identity |
+--------------------+--------------------------+

Documentation

Get started

Install

Download and install the latest Airtable plugin:

steampipe plugin install francois2metz/airtable

Configuration

Installing the latest airtable plugin will create a config file (~/.steampipe/config/airtable.spc) with a single connection named airtable:

connection "airtable" {
plugin = "francois2metz/airtable"
# Personal Access Token (get it on https://airtable.com/create/tokens)
# Scopes:
# - data.records:read
# - schema.bases:read
# token = "pat.xxx"
}

You can also set the token via the AIRTABLE_TOKEN environment variable.

Get Involved