Save a table

To a CSV

table.to_csv('filename.csv')

To JSON

table.to_json('filename.json')

To newline-delimited JSON

table.to_json('filename.json', newline=True)

To a SQL database

Use the agate-sql extension.

import agatesql

table.to_sql('postgresql:///database', 'output_table')