@gabrielahn/gtfs-viz-cli

Visualize, analyze, and edit GTFS transit data with a local DuckDB database and browser dashboard.

GitHub | Web App | DuckDB Extension | Agent Skills

Features

• Import GTFS zips — all data stored locally in DuckDB, no backend required
• Browse stations, stops, and pathways with filters
• Edit stations, stops, and pathway connections with live preview
• Pathfinding between station parts with traversal times
• Export edited data back to GTFS CSV format
• Browser dashboard with interactive maps, tables, and flow editor
• DuckDB SQL extension loadable from any DuckDB instance
• AI agent skills for coding assistants

Install

npm install -g @gabrielahn/gtfs-viz-cli

Requires DuckDB CLI (duckdb on PATH or DUCKDB_BIN).

Quick Start

gtfs-viz import /path/to/feed.zip     # Import GTFS zip
gtfs-viz stations --name "Park"       # Filter stations
gtfs-viz station "Park Street"        # Open dashboard
gtfs-viz station "Park Street" --data # Print data in terminal
gtfs-viz examples                     # See all commands

Commands

| Command | Description | | --- | --- | | import <feed.zip> | Import GTFS zip into local DuckDB | | stations [--name --pathways --wheelchair] | Browse stations with filters | | stops [--name --location-type --wheelchair] | Browse stops with filters | | station <name\|id> | Station info (dashboard or --data) | | stop-info <name\|id> | Stop map with popup (dashboard or --data) | | station_connections <name\|id> | Connection flow graph | | station_pathways <name\|id> | Station parts and pathways | | station_routes <name\|id> | Timed routes between parts | | station_shortest_route <name\|id> | Fastest entrance-to-exit route | | add_connection / update_connection / delete_connection | Edit pathways | | add_node / update_node / delete_node | Edit stops | | export [--output --no-stops --no-pathways] | Export edited GTFS as CSV | | query --sql <sql> | Run SQL | | edit_table [pathways\|stops] | View pending edits | | stop | Stop dashboard session and clear session state | | restart | Stop session and remove local DuckDB/feed import | | examples | Show usage examples | | clean | Remove all local data |

Add --data for terminal output, --format json for JSON, --dashboard for browser.

DuckDB Extension

The CLI uses the same GTFS DuckDB extension as the web app. Install it in any DuckDB instance:

INSTALL gtfs FROM 'https://github.com/gabrielAHN/gtfs-viz/releases/download';
LOAD gtfs;
-- After loading GTFS data:
SELECT * FROM gtfs_init();

Agent Skills

Install reference docs for AI coding agents (Claude Code, Cursor, etc.):

gtfs-viz install-skill

Installs: SKILL.md | commands.md | tables.md | procedures.md | gtfs-schedule-reference.md | examples.sql