Faostat MCP server

online · 100% uptime

by cyanheads·io.github.cyanheads/faostat-mcp-server·v0.6.0·2 stars

No reviews yet

UN FAOSTAT global food & agriculture statistics over a local SQLite mirror, via MCP.

A86/100grade A

Write a review Run it

What users say

No reviews yet

Be the first

Safety scan

A86/100

not scanned yet

Adoption

Growing

2 stars180 downloads/wk

Reviews

Write one

Nobody has reviewed Faostat yet.

If you have run it, two minutes of your experience saves the next person an afternoon.

Faostat tools

Tool list not cached yet. `describe` through the gateway fetches it live.

Not scanned yet. New listings are scanned within a day or two of arriving.

How Faostat compares

Against every graded Databases MCP server, from our own scans and uptime checks. Updated after each scan run.

Safety score: 86/100; higher than 68% of 802 Databases servers
Uptime: 100%; of our recent checks; the typical remote Databases server answers 100%
Response time: 545 ms; faster than 18% of 292 Databases servers
GitHub stars: 2; more than 60% of 602 Databases servers
Downloads a week: 180; more than 70% of 328 Databases servers with a package

Release history: 8 versions in the registry since 2026-08-25, latest 2026-11-03, typically one every 7 days.

Install Faostat in Claude Code, Cursor or VS Code

claude mcp add --transport http faostat-mcp-server https://faostat.caseyjhand.com/mcp

Add to Cursor

What the publisher says

From the Faostat repository's README, as published. We do not edit it. Read it on GitHub

@cyanheads/faostat-mcp-server Global food & agriculture statistics from the UN FAOSTAT bulk-download corpus, served from a local SQLite mirror with a DataCanvas SQL surface, over MCP. STDIO & Streamable HTTP. 6 Tools • 0 Resources • 0 Prompts

Public Hosted Server: https://faostat.caseyjhand.com/mcp

Overview

Global food and agriculture statistics from the UN FAOSTAT bulk-download corpus — crop and livestock production, agricultural trade, food balances, food security and nutrition, land use, fertilizer use, and agrifood-systems emissions for 245+ countries and territories from 1961 to the present. Discover a domain, resolve area/item/element codes, then query the cube; large or merged result sets spill to a DataCanvas SQL surface for GROUP BY, ranking, and time-series analysis. Runs as a stdio process, a local Streamable HTTP server, or the public hosted endpoint above.

Tools

Capability reference

faostatlistdomains tool

Shortened. The full README is on GitHub.

Nothing above is checked by us. What we check is on the safety report.

Grade history

2026-09-19restoreC → Ascore 86: Write-action tools reachable without authentication

Faostat: common questions

Is Faostat MCP server safe?: Yes, by our scan: it is graded A (86/100). Read the Faostat safety report
How do I install Faostat?: It runs remotely at faostat.caseyjhand.com. Add it to Claude Code, Cursor, VS Code or Claude Desktop with the snippets above, or call it through the mcp.market gateway without installing anything.
Does Faostat need an API key?: No secret keys are declared. It reads 18 settings from the environment.
Is Faostat maintained?: The last commit was 31 days ago (2026-10-04). The latest release is v0.6.0.
Is Faostat up?: 100% of our last 28 checks got an answer. We check remote servers about four times a day.
What can I use instead of Faostat?: Servers from other publishers that do the same job: sqlite-graph-memory MCP server, gadak MCP server and DBHub MCP server.
How does Faostat compare with other Databases MCP servers?: safety score 86/100 (higher than 68% of 802 Databases servers); uptime 100% (of our recent checks; the typical remote Databases server answers 100%); response time 545 ms (faster than 18% of 292 Databases servers). Full comparison.

Alternatives to Faostat

Same job from other publishers: the closest match first, then the best rated.

sqlite-graph-memory
Recall over your markdown notes: vector search plus your [[wikilinks]] as a graph, in SQLite.
not reviewed
Growing
A
gadak
Ask a local SQLite mirror of your Jira and Confluence: SQL, full-text search, issue detail.
not reviewed
Growing
A
DBHub
Token-efficient database MCP server for PostgreSQL, MySQL, MariaDB, SQL Server, Oracle, SQLite
not reviewed
Widely used
A
Mindwtr
Task automation via SQLite, desktop Local API, or Mindwtr Cloud; read-only by default.
not reviewed
Established
A
Sequential Thinking Working Notes
Local working notes, decisions, evidence and resumable sessions with SQLite persistence.
not reviewed
Established
A

Run it through the gateway

With the gateway added, ask your agent for it by name:

agent prompt

call io.github.cyanheads/faostat-mcp-server → <tool>

Free per call. Metered, capped by your key, logged for reliability.

Add the gateway (gw.mcp.market)

Rating: —
Safety grade: A · 86/100
Stars: 2
Downloads/wk: 180
Price: Free
Licence: Apache-2.0
Transport: Remote · mixed
Uptime: 100% · 28/28 checks
Version: 0.6.0
Category: Databases
Last release: 2026-10-04

Credentials it needs

FAOSTAT_DOMAINSComma-separated FAOSTAT domain codes to index into the local mirror.
FAOSTAT_MIRROR_PATHDirectory holding the per-domain SQLite mirror databases and the shared dimension database.
FAOSTAT_BULK_BASE_URLFAOSTAT bulk-download service base URL (manifest + per-domain ZIPs).
CANVAS_PROVIDER_TYPEDataCanvas engine for SQL over large result sets. Defaults to 'duckdb'; set 'none' to disable analytical staging.
FAOSTAT_DATAFRAME_DROP_ENABLEDSet to 'true' to make faostat_dataframe_drop callable, so a staged table can be dropped before its 2-hour TTL. Off by default: the tool is registered disabled.
MCP_LOG_LEVELSets the minimum log level for output (e.g., 'debug', 'info', 'warn').
MCP_TRANSPORT_TYPESelects the HTTP transport.
MCP_HTTP_HOSTThe hostname for the HTTP server.
MCP_HTTP_PORTThe port to run the HTTP server on.
MCP_HTTP_ENDPOINT_PATHThe endpoint path for the MCP server.
MCP_AUTH_MODEAuthentication mode to use: 'none', 'jwt', or 'oauth'.
FAOSTAT_DOMAINSComma-separated FAOSTAT domain codes to index into the local mirror.
FAOSTAT_MIRROR_PATHDirectory holding the per-domain SQLite mirror databases and the shared dimension database.
FAOSTAT_BULK_BASE_URLFAOSTAT bulk-download service base URL (manifest + per-domain ZIPs).
FAOSTAT_REFRESH_CRONCron expression for the in-process incremental mirror refresh (HTTP transport only). Omit to disable.
CANVAS_PROVIDER_TYPEDataCanvas engine for SQL over large result sets. Defaults to 'duckdb'; set 'none' to disable analytical staging.
FAOSTAT_DATAFRAME_DROP_ENABLEDSet to 'true' to make faostat_dataframe_drop callable, so a staged table can be dropped before its 2-hour TTL. Off by default: the tool is registered disabled.
MCP_LOG_LEVELSets the minimum log level for output (e.g., 'debug', 'info', 'warn').

Endpoint

https://faostat.caseyjhand.com/mcp

streamable-http

Own this server?

Claim it to keep the listing current and reply to reviews. Claiming never changes the grade or hides a review.

Claim listing

Badge for your README

Shows the safety grade and links back to this page. It updates itself after every scan and review.

[![mcp.market](https://mcp.market/badge/cyanheads-faostat-mcp-server.svg)](https://mcp.market/server/cyanheads-faostat-mcp-server)

How the badge works