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.