ADBE CLI

Airtable DB Export is a command line utility, available after installing as airtable-db-export or adbe (same tool).

adbe

Main entry point for the CLI.

adbe [OPTIONS] COMMAND [ARGS]...

Options

-c, --config-file <config_file>

Config file with options and table definitions. See Configuration for more.

--no-config-file

Flag to stop option processing. Only use before create-config command.

--base-dir <base_dir>

Directory in which to put all generated files. Can be absolute or relative to the current directory.

--schemas-file <schemas_file>

Filename for the intermediate mapping file that maps Airtable tables and fields to SQL tables and columns.

--data-dir <data_dir>

The directory to download and save Airtable JSON data. If <base_dir> is set, will be treated as relative to <base_dir> unless it’s an absolute path.

--sql-dir <sql_dir>

The directory to put generated CREATE DDL files. If <base_dir> is set, will be treated as relative to <base_dir> unless it’s an absolute path.

--db-file <db_file>

The file path for the generated database. If <base_dir> is set, will be treated as relative to <base_dir> unless it’s an absolute path.

--backend <backend>

Database backend to use (duckdb or sqlite). If not specified, will be auto-detected from db-file extension.

all

adbe all [OPTIONS]

create-config

Generate a starting config file that you can adapt for your needs.

adbe create-config [OPTIONS] FILENAME

Arguments

FILENAME

Required argument

create-db

Create database from generated DDL.

adbe create-db [OPTIONS]

create-sql

Generate CREATE DDL for database tables based on Airtable schema and table configuration in the config.yml.

adbe create-sql [OPTIONS]

download-data

Download Airtable data. Files will be stored in <data_dir>.

adbe download-data [OPTIONS]

Options

-f, --format <formats>

Formats to export downloaded data as.

Options:

json | csv

generate-schema-map

Generate schemas.json file. This file is intermediary and contains the information needed to map the selected Airtable fields to SQL tables and columns

adbe generate-schema-map [OPTIONS]

load-db

Load JSON data from Airtable into the database.

adbe load-db [OPTIONS]

reference-schemas

adbe reference-schemas [OPTIONS] [FILENAME]

Arguments

FILENAME

Optional argument