Skip to main content
Glama
Sign In
cnes-mcp-test

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.

Tool Schema Changelog

Recent tool additions, removals, and schema changes observed during successful MCP inspections.

Loading tool schema changelog…

    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

    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.
      432 npm
      MIT

    • mcp-cnes

      kevyn-castelo
      A
      license
      A
      quality
      C
      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
      A
      quality
      D
      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.
      2
      MIT