Skip to content

Latest commit

 

History

History
73 lines (53 loc) · 1.78 KB

index.md

File metadata and controls

73 lines (53 loc) · 1.78 KB
Raw
organization category brand_color display_name short_name description og_description icon_url og_image
francois2metz
saas
#18BFFF
Airtable
Airtable
Steampipe plugin for querying Airtable.
Query Airtable with SQL! Open source CLI. No DB required.
/images/plugins/francois2metz/airtable.svg
/images/plugins/francois2metz/airtable-social-graphic.png

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