MCP Server

AI agents query ecological data directly.

A remote MCP server at mcp.rangifer.ca/mcp exposes 1.17 million enriched urban tree records to any MCP-compatible AI assistant. Claude, Cursor, Windsurf, and opencode can query trees, generate reports, and run read-only SQL — no wrapper code needed.

Direct database access

Tools query PostGIS directly via a read-only role. No intermediate API hop — fast, structured results.

Read-only & rate-limited

Dedicated Postgres role, SQL injection protection, 1,000-row result cap, 50 req/s rate limit. Public, no auth required.

7 tools, MCP-compliant

Standard MCP streamable HTTP transport. Works with any MCP-compatible client. OAuth flow for Claude.ai connectors.

Available tools

query_trees

Search trees by city, borough, species, carbon storage. Returns up to 1,000 rows.

get_borough_stats

Aggregated stats for a borough: tree count, species diversity, carbon, benefits.

get_species_distribution

Top species by count, with average carbon and economic benefit.

get_all_cities

List all cities with tree counts.

get_all_boroughs

List all boroughs/wards with tree counts (filterable by city).

get_schema

Database schema and total row count.

run_readonly_query

Execute custom read-only SQL against curated MCP-safe views.

Connect your client

Claude (claude.ai)
https://mcp.rangifer.ca/mcp

Add as a custom connector in Settings → Connectors

Claude Code (CLI)
https://mcp.rangifer.ca/mcp

claude mcp add --transport http rangifer https://mcp.rangifer.ca/mcp

OpenCode
https://mcp.rangifer.ca/mcp

Add to ~/.config/opencode/opencode.jsonc under mcp

Cursor / Windsurf
https://mcp.rangifer.ca/mcp

Add URL as a remote MCP server in settings