Command line interface to interact with CartoDB SQL API. This is basically a command line interface that wraps the CartoDB python SDK for your convenience.
It's advised to create a virtual environment. Note that this code is only tested with Python 3, it will probably work with version 2, though.
virtualenv -p python3 env
And once activated install the requirement libraries with these two commands:
$ pip install -e git+git://github.com/CartoDB/cartodb-python.git#egg=cartodb
$ pip install -r requirements.text
Run python cartodb-cli.py
to see the options and arguments, they should
be quite straight forward. You can set these environment variables so you don't need to put your credentials from the command line:
CARTODB_USER_NAME
CARTODB_API_KEY