%load_ext sql
%sql mysql+pymysql://readonlyguest:readonlypassword@mysql.guaminsects.net/oryctes

%sql SHOW TABLES

%sql SELECT * FROM YigoBarrelObs LIMIT 5
  @article { bestWaySQL,
    title = {Best Way to Access Data in the Guam Coconut Rhinoceros Project Database},
    year = {2015},
    type = {CRB Technical Report},
    url = {http://nbviewer.ipython.org/url/guaminsects.net/anr/sites/default/files/bestWaySQL.ipynb},
    author = {Aubrey Moore}
  }