Orchard is an early preview — connector details below are illustrative while we iterate.

Public data

Volcanos

A free, ready-to-attach connector serving the Smithsonian Global Volcanism Program catalog — volcanoes, eruptions, and types — as clean SQL tables.

Stable By Query.Farm Python worker

Pricing

What Volcanos does

The Volcanos connector wraps the Smithsonian Global Volcanism Program data into an attachable SQL catalog. Query volcanoes by region, type, and last-known eruption without scraping or downloading anything yourself.

It is the reference worker behind several Query.Farm VGI examples and is free to attach. Use it to learn the Orchard workflow or to practice geospatial joins against other public datasets.

Highlights

Smithsonian volcano catalog as tables
Eruption history and volcano types
Latitude / longitude ready for geospatial joins
No token required — free to attach
Backs the Query.Farm VGI demos

Tables & functions it exposes

Once attached, the connector adds these objects to your SQL session.

Table smithsonian.volcanoes: One row per volcano with region and type.
Table smithsonian.eruptions: Recorded eruptions with dates and VEI.
Table smithsonian.pleistocene_volcanoes: Pleistocene-era volcanoes subset.

What teams build with Volcanos

Learn the Orchard attach-and-query workflow for free.

Join volcano locations against weather or air-quality data.

Teach geospatial SQL with a real, tidy dataset.

Ready to attach Volcanos?

Pricing

Attach & query

volcanos.sql

-- Attach the free Volcanos connector (no token required)
ATTACH 'volcanos' AS volcanos (
  TYPE vgi,
  LOCATION 'https://vgi-volcanos.fly.dev/'
);

-- The ten most recently active volcanoes by country
SELECT name, country, primary_type, last_eruption_year
FROM volcanos.smithsonian.volcanoes
WHERE last_eruption_year IS NOT NULL
ORDER BY last_eruption_year DESC
LIMIT 10;

Requires the VGI extension. Set ORCHARD_TOKEN after subscribing.

Keep exploring