faostat-mcp-server
If you've ever wanted an LLM to answer questions about world food production, trade, or land use without scraping the FAOSTAT site, this one is worth a look. It ships a local SQLite mirror of the UN FAOSTAT bulk downloads, so queries run against indexed data rather than hitting upstream each time. The tools cover domain discovery, resolving country and commodity codes, querying observations by area, item, element, and year, and a one-call commodity profile that pulls top producers, trade flows, and a production trend. Larger result sets get staged into a SQL-queryable canvas, so you can run read-only SELECTs over them. It runs over stdio or Streamable HTTP, and there's a public hosted instance if you just want to try it.
- tools
- 7
- transport
- HTTP
- last updated
- Jul 10, 2026
Tools
7 toolsPublic tool metadata for what this MCP can expose to an agent.
faostat_list_domainsDiscover FAOSTAT statistical domains with codes, descriptions, last-update date, upstream row count, and local index status.
Discover FAOSTAT statistical domains with codes, descriptions, last-update date, upstream row count, and local index status.
No parameter schema in public metadata yet.
faostat_resolve_codesResolve human terms to the codes a query needs (areas, items, elements), flagging each area as a country or an aggregate region.
Resolve human terms to the codes a query needs (areas, items, elements), flagging each area as a country or an aggregate region.
No parameter schema in public metadata yet.
faostat_query_observationsQuery a domain's cube by area(s), item(s), element(s), and year range. Inline preview for small results; large sets spill to a DataCanvas table.
Query a domain's cube by area(s), item(s), element(s), and year range. Inline preview for small results; large sets spill to a DataCanvas table.
No parameter schema in public metadata yet.
faostat_commodity_profileWorkflow: assemble top producers, the production trend, and trade flows for one commodity from the production and trade domains in a single call.
Workflow: assemble top producers, the production trend, and trade flows for one commodity from the production and trade domains in a single call.
No parameter schema in public metadata yet.
faostat_dataframe_queryRun a read-only SQL SELECT against the canvas tables staged by the analytical tools.
Run a read-only SQL SELECT against the canvas tables staged by the analytical tools.
No parameter schema in public metadata yet.
faostat_dataframe_describeList the canvas tables staged this session, each with provenance, row count, and column schema.
List the canvas tables staged this session, each with provenance, row count, and column schema.
No parameter schema in public metadata yet.
faostat_dataframe_dropDrop one staged canvas table before its 2-hour TTL. Opt-in — callable only with FAOSTAT_DATAFRAME_DROP_ENABLED=true.
Drop one staged canvas table before its 2-hour TTL. Opt-in — callable only with FAOSTAT_DATAFRAME_DROP_ENABLED=true.
No parameter schema in public metadata yet.
Sponsors
Agent CaffeineSponsoredClose your lid, come back to finished work
SnugSponsoredThe clipboard manager for the AI eraPromote your product hereReach 125k+ visitors monthly
WaxSponsoredBlock anything with supervision, without erasing your iPhonePromote your product hereReach 125k+ visitors monthly
knobsSponsoredSee your site on any phone, any day, in any languageReadme
@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, via MCP. STDIO or Streamable HTTP.
Details
- Repository
- github.com/cyanheads/faostat-mcp-server
- Website
- faostat.caseyjhand.com/mcp
- Category
- Databases
- Transport
- HTTP
More from cyanheads
- fema-mcp-server
- libofcongress-mcp-server
- openfoodfacts-mcp-server
- orcid-mcp-server
- reference-data-mcp-server
- usaspending-mcp-server
- arxiv-mcp-server
- exchange-rates-mcp-server
- openlibrary-mcp-server
- protein-mcp-server
- Pubmed Mcp Server167
- Clinicaltrialsgov Mcp Server100
- Openalex Mcp Server17
- Faostat Mcp Server3
- National Parks Mcp Server3
- Federal Regulations Mcp Server2
- Calculator Mcp Server3
- Congressgov Mcp Server2
- Nws Weather Mcp Server2
- Obsidian Mcp Server705
- Toolkit Mcp Server20
- Nhtsa Vehicle Safety Mcp Server3
- Eur Lex Mcp Server12
- Hn Mcp Server7
Related Databases MCP servers
View all
Mcp Server Mssqldaedalus/mcp-server-mssqlMCP server for Microsoft SQL Server using mssql-python0stars
Mcp Data Pipeline Connectordbsectrainer/mcp-data-pipeline-connectorUniversal data connector for CSV, Postgres, and REST APIs via DuckDB0stars
Mcpinstanode-dev/mcpProvision Postgres databases + webhooks from AI coding agents in one HTTP call.0stars
Mcp Datainfoinlet-marketplace/marketplaceTabular data for AI agents — load CSV/JSON/XLSX, query, group-by, stats (no database).0stars
AgentBuilderssirarchiemccarthy-oss/clawdDeploy full-stack web apps with database, file storage, auth, and RBAC via a single API call.0stars
Warehouse Mcpkalehdoo/warehouse-mcpProduction MCP server for Postgres, Oracle, Snowflake, BigQuery, Redshift, DuckDB, MotherDuck.0stars