🌱 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 Free By Query.Farm Python worker

Pricing

Free

Free plan

Attach for free ← Back to the Orchard

Overview

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

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.

What you get