recife-open-data-mcp

Item: recife-open-data-mcp
Rating: 69
Author: M8ven

MCP server to query public open data from Recife, Brazil using natural language. It exposes tools for schema exploration and SQL query generation via Gemini 2.5 Flash, backed by a local DuckDB database.

→ jg-cordeiro/recife-open-data-mcp · listed on glama

Is this your MCP?

Claim it to get a verified publisher badge, a free copy of our full audit findings, and direct contact for any high-priority issues we find.

Install from

Glama

M8ven verifies MCPs across every public registry — install directly from whichever one you prefer.

// key findings

✅

No credential exfiltration, no sensitive file access, no obfuscation

Static analysis found nothing flowing your secrets to unexpected places.

✅

Open source with a license and README

Anyone can audit the code, the license is declared, and the publisher documents what it does.

🔐

You'll be asked for 1 credential: OPENROUTER_API_KEY

These are read from process.env at runtime. Make sure you trust where they’ll be sent.

// required environment variables

This server reads these from process.env. You'll be asked to provide them before it can run.

configDUCKDB_DATA_DIR— ./data Diretorio do banco DuckDB

🔐 secretOPENROUTER_API_KEY— Edite .env e preencha

configOPENROUTER_MODEL— google/gemini-2.5-flash Modelo LLM usado para geracao de SQL

configMAX_RESULT_ROWS— 200 Limite de linhas retornadas

configHTTP_PORT— 8000 Porta do servidor HTTP

// full audit trail

The full breakdown of what we checked, the deductions that landed, the network hosts, the dependency advisories, and concrete fix guidance is available to verified publishers.

// improvement guidance — verified publishers only

We have 5 concrete improvements we can share with the publisher of this MCP. Each comes with specific guidance to raise the trust score.

// embed badge in your README

[![M8ven Score](https://m8ven.ai/badge/mcp/jg-cordeiro-recife-open-data-mcp-gxf7ow)](https://m8ven.ai/mcp/jg-cordeiro-recife-open-data-mcp-gxf7ow)

commit: c6bc317e646620e1107e2fb9464cba535a4cae5d

code hash: 001f4e630d88095492e801933f47cec1123b0e36c69ef114e3ee2c523f63a1df

verified: 7/14/2026, 8:38:28 AM

view raw JSON →