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