JSON Mapping & Context MCP Servers
This server does not currently have a deployable release on Glama. Follow the repository's setup instructions to install and configure it for your MCP client, including any required credentials and local dependencies.
JSON Mapping & Context MCP Servers
This repo hosts two small MCP servers that showcase schema-aware JSON exploration and live data retrieval:
JSON Mapping Finder (
json_mapping_server.py): Upload any JSON sample, flatten its schema, and use heuristic search (token overlap + fuzzy matching) to find paths for target field names. Great for accelerating ETL/API onboarding.
It is intentionally lightweight and fully HTTP-based for easy inspection with the MCP Inspector or Copilot Chat.
Highlights
Schema-aware parsing: Flattens nested JSON, captures types/examples, and tracks depth.
Heuristic mapping: Token overlap, substring checks, and fuzzy matching to suggest likely field paths.
Plug-and-play MCP: Uses
StreamableHTTPSessionManagerfor modern MCP HTTP transport.Portable: Pure Python, no external services beyond Open-Meteo.
Related MCP server: MCP JSON Navigator
Quick Start
Prereqs: Python 3.12+ and a virtual environment (.venv recommended).
python -m venv .venv
source .venv/bin/activate
pip install -r <(python - <<'PY'
import tomllib, sys
deps = tomllib.load(open("pyproject.toml","rb"))["project"]["dependencies"]
print("\n".join(deps))
PY)Run the JSON Mapping Finder (port 3004)
.venv/bin/python json_mapping_server.pyThen inspect with:
npx -y @modelcontextprotocol/inspector http://localhost:3004Exposed tools:
upload_json_sample(json_data): load a JSON sample (e.g.,sample_json.json) and build the schema index.list_schema(limit=200): view flattened paths with type + example values.search_fields(query, top_k=10): find likely paths for a single query.map_targets(targets, top_k=5): bulk mapping suggestions for multiple field names.clear_samples(): reset the index.
Sample Data
sample_json.json: a non-medical, nested sample for testing the JSON Mapping Finder.
Configuration
If you want to wire these into Copilot Chat, add entries like:
{
"mcpServers": {
"json-mapping": { "url": "http://localhost:3004" }
}
}How it works (JSON Mapping Finder)
Indexing: Walks objects/arrays, records paths (
$.foo.bar[*]), types, example values, and depth.Scoring: Combines exact/substring boosts, Jaccard token overlap, and fuzzy ratio; lightly penalizes deep paths.
Suggestions: Returns top matches with scores so you can review/accept quickly.
Notes
No API keys required.
All code is ASCII-only and dependency-light.
Tool Schema Changelog
Recent tool additions, removals, and schema changes observed during successful MCP inspections.
Loading tool schema changelog…
This server cannot be deployed
Maintenance
Related MCP Connectors
Dedupe, flatten and clean messy JSON rows (emails, phones, URLs, HTML) in one call, as JSON or CSV.
Entity resolution — data mapping, SDK code generation, docs search, and error troubleshooting
Turn any PDF into structured JSON via AI + OCR: invoices, bank statements, contracts.
The AI that understands raw data: Schema over your tables and databases, as MCP tools.
Related MCP Servers
- -licenseCqualityNot gradedmaintenanceEnables AI to create, edit, and batch generate JSON data with advanced rule engines. Supports CRUD operations, node-level editing, template management, and multi-format file exports (JSON, JSONL, CSV).3179 npm-
- AlicenseNot gradedqualityDmaintenanceEnables efficient navigation and search of large JSON files (>10MB) through intelligent path exploration and fuzzy search capabilities, designed to save tokens by avoiding loading entire files into context.1MIT
- AlicenseAqualityDmaintenanceExtracts structured JSON data from unstructured text using predefined schemas for receipts, invoices, resumes, and emails. It allows users to transform messy text into organized data through built-in or custom-defined fields.1MIT
- AlicenseBqualityBmaintenanceEnables natural language interaction with JSON files, providing tools to load, query, aggregate, transform, and export data directly from AI editors.2642 PyPI3MIT