Skip to main content
Glama
josepaulolaport

cnes-mcp-test

by josepaulolaport
OverviewSchemaSourceRelated ServersScoreDiscussionsAdmin
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.

Tool Schema Changelog

Recent tool additions, removals, and schema changes observed during successful MCP inspections. Dates show when Glama detected each change.

No tool schema history has been recorded yet.

This server cannot be installed

RayrunBuild, deploy, and operate MCP servers without becoming an infrastructure team.ray.runAd

Maintenance

ActivitySlowing
ResponsivenessNo issues

Resources

Unclaimed servers have limited discoverability.

Looking for Admin?

If you are the server author, to access and configure the admin panel.

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.
    607
    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

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/josepaulolaport/cnes-mapping'

If you have feedback or need assistance with the MCP directory API, please join our Discord server