Skip to main content

A Python ORM for Airtable.

Project description


PyPI version Documentation Status codecov

Airstorm is a dynamic Python ORM for Airtable. It allows you to easily interact with any base using Python with minimal setup.

Main Features

  • Object-oriented interface.
  • Dynamic generation of data models from schema.
  • Automatic foreign-key resolution.
  • Caching layer to avoid abusing the Airtable API.


pip install airstorm


from airstorm.base import Base
jamba_juice = Base('your_base_id', 'your_api_key', {'your': 'schema'})
smoothy = jamba_juice.Smoothie('some_smoothie_id')  # Get your table record.
for fruit in smoothy.fruits:  # Get linked record in a breeze.
    print(  # Access any field data.
print(smoothy.fruits.names) # Access to mutliple record field data at once.

Getting the Schema

Unfortunatly currently this part of the process is not ideal. Because Airtable does not provide access to the schema via their API, you'll have to "download" the schema manually via a web browser of choice.

The following gist is a script that you can run on a Chrome console from the Airtable base API page to get back the JSON schema that airtstorm is expecting to be fed with.


  • Field validation where possible.
  • Push changes. Currently we are read-only.
  • Downlading schema automatically using pyppeteer.
  • Pythonic formulas.

Project details

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

airstorm-0.1.0.dev2.tar.gz (9.5 kB view hashes)

Uploaded source

Built Distribution

airstorm-0.1.0.dev2-py3-none-any.whl (12.0 kB view hashes)

Uploaded py3

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page