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.
Setup
Choose your client, copy the config, then fill in any required environment variables.
Local
claude mcp add faostat -- npx -y @cyanheads/faostat-mcp-server~/.codex/config.toml
[mcp_servers.faostat]
command = "npx"
args = ["-y", "@cyanheads/faostat-mcp-server"]
# codex mcp add faostat -- npx -y @cyanheads/faostat-mcp-server~/.cursor/mcp.json
{
"mcpServers": {
"faostat": {
"command": "npx",
"args": [
"-y",
"@cyanheads/faostat-mcp-server"
]
}
}
}.vscode/mcp.json
{
"servers": {
"faostat": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"@cyanheads/faostat-mcp-server"
]
}
}
}~/.gemini/settings.json
{
"mcpServers": {
"faostat": {
"command": "npx",
"args": [
"-y",
"@cyanheads/faostat-mcp-server"
]
}
}
}claude_desktop_config.json
{
"mcpServers": {
"faostat": {
"command": "npx",
"args": [
"-y",
"@cyanheads/faostat-mcp-server"
]
}
}
}.trae/mcp.json
{
"mcpServers": {
"faostat": {
"command": "npx",
"args": [
"-y",
"@cyanheads/faostat-mcp-server"
]
}
}
}Remote
claude mcp add --transport http faostat https://faostat.caseyjhand.com/mcp~/.codex/config.toml
[mcp_servers.faostat]
url = "https://faostat.caseyjhand.com/mcp"
# codex mcp add faostat --url https://faostat.caseyjhand.com/mcp~/.cursor/mcp.json
{
"mcpServers": {
"faostat": {
"url": "https://faostat.caseyjhand.com/mcp"
}
}
}.vscode/mcp.json
{
"servers": {
"faostat": {
"type": "http",
"url": "https://faostat.caseyjhand.com/mcp"
}
}
}~/.gemini/settings.json
{
"mcpServers": {
"faostat": {
"httpUrl": "https://faostat.caseyjhand.com/mcp"
}
}
}claude_desktop_config.json · Customize › Connectors › Add custom connector
{
"mcpServers": {
"faostat": {
"command": "npx",
"args": [
"-y",
"mcp-remote",
"https://faostat.caseyjhand.com/mcp"
]
}
}
}.trae/mcp.json
{
"mcpServers": {
"faostat": {
"url": "https://faostat.caseyjhand.com/mcp"
}
}
}