francois2metz/airtable

steampipe plugin install francois2metz/airtablesteampipe 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,
fields->'Name' as name
from
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"
# API token (get it on https://airtable.com/account)
token = "YOUR_AIRTABLE_TOKEN"
# Database ID (get it by clicking "help -> api documentation". The Base ID is in the URL and in all of the examples).
database_id = "YOUR_DATABASE_ID"
# Tables to expose
# For instance: ["Design Projects", "Tasks", "Client"]
tables = []
}

Get Involved