Download data from Airtable to a SQL database.
Project description
Airtable DB Export (ADBE)
Export Airtable tables to a SQL database.
Background
Airtable is a low-code platform that allows individuals, teams, and businesses to build database-backed applications. As a low-code tool Airtable is optimized for non-technical users to be able to create new tables, forms and interfaces quickly.
An individual or organization using Airtable may find that after building a quick solution or prototype in Airtable, they want to export this data into a structure that is optimized for use in tranditional developement or for further analysis.
Airtable DB Export enables developers to download tables of data from Airtable as JSON files, configure the mapping of Airtable tables and fields to SQL tables and columns, and (currently) create and load a DuckDB SQL database with downloaded data.
Documentation
Read more on ReadTheDocs.
Using pip
pip install airtable-db-export
Using uv
uv add airtable-db-export
Usage
Usage: adbe [OPTIONS] COMMAND [ARGS]...
Main entry point for the CLI.
Options:
-c, --config TEXT
--base-dir TEXT
--schemas-file TEXT
--data-dir TEXT
--sql-dir TEXT
--db-file TEXT
--help Show this message and exit.
Commands:
all
create-db Generate database definitions
create-sql Generate database definitions
download-json
generate-schema-map
load-db
Configuration
Similar projects
- Simon WIllison's Airtable Export
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Filter files by name, interpreter, ABI, and platform.
If you're not sure about the file name format, learn more about wheel file names.
Copy a direct link to the current filters
File details
Details for the file airtable_db_export-0.4.2.tar.gz.
File metadata
- Download URL: airtable_db_export-0.4.2.tar.gz
- Upload date:
- Size: 246.4 kB
- Tags: Source
- Uploaded using Trusted Publishing? Yes
- Uploaded via: uv/0.9.28 {"installer":{"name":"uv","version":"0.9.28","subcommand":["publish"]},"python":null,"implementation":{"name":null,"version":null},"distro":{"name":"Ubuntu","version":"24.04","id":"noble","libc":null},"system":{"name":null,"release":null},"cpu":null,"openssl_version":null,"setuptools_version":null,"rustc_version":null,"ci":true}
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
975feb99d3c77dd50819999f6bce5353a49e58dbe552f475a51ec86b9e0ebcfa
|
|
| MD5 |
c07293b06c7d164ed0dd638d812cd245
|
|
| BLAKE2b-256 |
4bb1456681115a076661942e27083b555e904fb6954ae0464a8d020bf5cb520e
|
File details
Details for the file airtable_db_export-0.4.2-py3-none-any.whl.
File metadata
- Download URL: airtable_db_export-0.4.2-py3-none-any.whl
- Upload date:
- Size: 24.4 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? Yes
- Uploaded via: uv/0.9.28 {"installer":{"name":"uv","version":"0.9.28","subcommand":["publish"]},"python":null,"implementation":{"name":null,"version":null},"distro":{"name":"Ubuntu","version":"24.04","id":"noble","libc":null},"system":{"name":null,"release":null},"cpu":null,"openssl_version":null,"setuptools_version":null,"rustc_version":null,"ci":true}
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
39daa9941e0ce50ff62945011c7b79834627e9fb3e16e3ba0378345e70806339
|
|
| MD5 |
070dd1d1e4afc3ca4357caa0b8582cfd
|
|
| BLAKE2b-256 |
6b3e675272fb194efcfc792fb607ed14f06ea5877404454964ea59b6c46b3c89
|
