# recife-open-data-mcp

> Use this tool when you need to query public open data from Recife, Brazil using natural language, and generate SQL queries via Gemini 2.5 Flash. It solves problems related to data exploration and querying, providing an interface to explore schema and generate queries, with inputs in natural language and outputs in SQL. Ideal for use cases requiring easy access to Recife's public data, with a local DuckDB database backing the queries.

Canonical page: https://skillsregistry.net/skills/jg-cordeiro-recife-open-data-mcp  
JSON: https://api.skillsregistry.net/v1/skills/jg-cordeiro-recife-open-data-mcp

## Description

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.

## Trust

- **Trust score (0–1):** 0.68
- **Verification tier:** scanned
- **Last scanned:** 2026-09-01

## Facts

- **Version:** 1.0.0
- **Skill type:** atomic
- **Execution layer:** mcp-remote
- **Runtime environment:** api
- **Category:** database
- **Updated:** 2026-09-01

## Source

- **Source listing:** [Glama](https://glama.ai/mcp/servers/cj82zibss8)
- **Repository:** <https://github.com/jg-cordeiro/recife-open-data-mcp>

## Use it

Resolve this record through the SkillsRegistry MCP server (no auth, read-only):

```
claude mcp add --transport http --scope user skillsregistry https://api.skillsregistry.net/mcp
```

```json
{
  "jsonrpc": "2.0",
  "id": 1,
  "method": "tools/call",
  "params": {
    "name": "get_skill",
    "arguments": {
      "slug": "jg-cordeiro-recife-open-data-mcp"
    }
  }
}
```

REST: `GET https://api.skillsregistry.net/v1/skills/jg-cordeiro-recife-open-data-mcp` · pull for local use: `GET https://api.skillsregistry.net/v1/skills/jg-cordeiro-recife-open-data-mcp/pull`

---
SkillsRegistry indexes agent skills from public registries and GitHub. Skills we have analysed are scanned with Circle-IR and scored on six dimensions; each listing states its scan coverage. More: https://skillsregistry.net/llms.txt