Skip to main content
Glama
josepaulolaport

cnes-mcp-test

by josepaulolaport
OverviewSchemaSourceRelated ServersDiscussionsAdmin
Python

CNES Mapping

Brazilian CNES health establishment data → PostgreSQL schema + MCP server for AI-assisted queries.

Quick setup

git clone https://github.com/josepaulolaport/cnes-mapping.git
cd cnes-mapping
cp .env.example .env          # edit DATABASE_URL
pip install -r requirements.txt
cd mcp && npm install && npm run build

# Download CNES CSVs from DATASUS into:
# BASE_DE_DADOS_CNES_202605/

# PostgreSQL import
export DATABASE_URL=postgresql://user:pass@localhost:5432/atlasmed_test
psql "$DATABASE_URL" -f sql/create_mcp_test_schema.sql
cd scripts && python3 import_modular.py --table all

# MCP (Claude Desktop / Cursor)
cp .mcp.json.example .mcp.json   # set absolute path + CNES_DATABASE_URL

Related MCP server: MCP PostgreSQL

What's included

Path

Purpose

sql/

PostgreSQL schema, migrations, views, FKs

scripts/import_modular.py

Modular CNES CSV importer

mcp/

Read-only MCP server (cnes-mcp-test)

mcp/schema_manifest.json

Schema metadata for the AI agent

docs/

Import guides, table docs

Not in repo (gitignored)

  • BASE_DE_DADOS_CNES_202605/ — download from DATASUS CNES

  • output/, logs/, import_errors/ — generated artifacts

  • .env — credentials

MCP tools

list_tables, describe_table, execute_query, run_analysis, search_schema, get_agent_policy

See mcp/README.md and CLAUDE.md.

Data

CNES May 2026 (202605) — ~623k facilities, ~7.7M professionals, reference tables for occupations, agreements, maintainers, etc.

Schema: mcp_test on PostgreSQL.

This server cannot be deployed

One endpoint for every MCP toolRayrun runs every MCP server behind one URL and holds the credentials. Each call is decided per client, tool, and argument, then recorded.ray.runAd

Maintenance

ActivityStale
ResponsivenessNo issues

Resources

Related MCP Connectors

Related MCP Servers

  • recife-open-data-mcp

    jg-cordeiro
    A
    license
    Not graded
    quality
    D
    maintenance
    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.
    1
    MIT

  • MCP PostgreSQL

    cuevacelis
    A
    license
    Not graded
    quality
    D
    maintenance
    A read-only MCP server for PostgreSQL that enables safe database introspection and querying via natural language.
    306 npm
    MIT

  • mcp-cnes

    kevyn-castelo
    A
    license
    A
    quality
    A
    maintenance
    MCP server for loading and querying public data from the Brazilian National Registry of Health Establishments (CNES). It enables natural language searches for health facilities by municipality, CNES code, or state, along with statistics and data loading.
    6
    MIT

  • mcp-crewai-giulia-ai

    wganalytics
    A
    license
    Not graded
    quality
    C
    maintenance
    MCP server enabling text-to-SQL on PostgreSQL databases using a CrewAI multi-agent system. It generates and executes read-only SQL queries from natural language, with security layers against prompt injection.
    MIT