io.github.cyanheads/faostat-mcp-server MCP Server
io.github.cyanheads/faostat-mcp-server
What this kind of tool is for
- Query, inspect, or seed a database without writing a one-off script.
- Let your agent look up schema details before it writes migration code.
- Move a small dataset between tools without leaving the terminal.
How to compare servers like this
- Engine match:
- Confirm it speaks your exact database and version, not just the family.
- Access scope:
- Read-only connections are the safe default — start there before granting writes.
- Safety rails:
- Check whether destructive statements need an explicit confirmation before they run.
- Maintenance signal:
- Database drivers change; a recently updated tool is less likely to break mid-query.
This page carries your copy-paste config: pick your MCP client in the install section on this page and use the copy button.
What is the io.github.cyanheads/faostat-mcp-server MCP server?
UN FAOSTAT global food & agriculture statistics over a local SQLite mirror, via MCP.
How to install io.github.cyanheads/faostat-mcp-server
Copy-paste configuration for popular MCP clients.
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_TYPESet to 'duckdb' to enable the DataCanvas SQL surface (default), or 'none' to disable analytical staging.
MCP_LOG_LEVELSets the minimum log level for output (e.g., 'debug', 'info', 'warn').
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_REFRESH_CRONCron expression for the in-process incremental mirror refresh (HTTP transport only). Omit to disable.
{
"mcpServers": {
"faostat-mcp-server": {
"command": "node",
"args": [
"-y",
"@cyanheads/faostat-mcp-server",
"run",
"start:stdio"
],
"env": {
"FAOSTAT_DOMAINS": "<YOUR_FAOSTAT_DOMAINS>",
"FAOSTAT_MIRROR_PATH": "<YOUR_FAOSTAT_MIRROR_PATH>",
"FAOSTAT_BULK_BASE_URL": "<YOUR_FAOSTAT_BULK_BASE_URL>",
"CANVAS_PROVIDER_TYPE": "<YOUR_CANVAS_PROVIDER_TYPE>",
"MCP_LOG_LEVEL": "<YOUR_MCP_LOG_LEVEL>",
"MCP_HTTP_HOST": "<YOUR_MCP_HTTP_HOST>",
"MCP_HTTP_PORT": "<YOUR_MCP_HTTP_PORT>",
"MCP_HTTP_ENDPOINT_PATH": "<YOUR_MCP_HTTP_ENDPOINT_PATH>",
"MCP_AUTH_MODE": "<YOUR_MCP_AUTH_MODE>",
"FAOSTAT_REFRESH_CRON": "<YOUR_FAOSTAT_REFRESH_CRON>"
}
}
}
}Related MCP servers
FBI Crime Data Explorer — UCR estimates, NIBRS breakdowns, hate crimes, arrests, and agency data.
FCC broadband availability, coverage analysis, and digital divide data for US geographies.
Search FDIC-insured banks, Call Report financials, peer rankings, failures, deposit market share.
Search and trace US federal rules across the Federal Register, eCFR, and Regulations.gov.
Search and fetch ~800K Federal Reserve economic time-series from the FRED API via MCP.
Query FEMA disaster declarations, public assistance grants, housing aid, and NFIP claims.
