MCP

Generate JSON Schemas and Filter Data

JSON MCP Server: Generates TypeScript schemas and filters JSON data from local files or URLs.

Works with githubnpm

14
Spark score
out of 100
Updated 2 months ago
Version 1.0.0
Models

Add to Favorites

Why it matters

Automate data processing by generating JSON schemas and filtering local or remote JSON files. This asset helps extract specific data structures and provides TypeScript interfaces for better code integration.

Outcomes

What it gets done

01

Generate TypeScript interfaces from JSON data using quicktype.

02

Filter JSON files and API responses to extract specific fields.

03

Analyze large datasets and recommend chunking strategies.

04

Process data from HTTP/HTTPS endpoints and local files.

Install

Add it to your toolbox

Run in your project directory:

curl -fsSL https://spark.entire.vc/get/vb-json | bash

Capabilities

Tools your agent gets

json_schema

Generates TypeScript interfaces from JSON data using quicktype

json_filter

Extracts specific fields using shape-based filtering and automatic chunking of large datasets

json_dry_run

Analyzes data size and provides chunking recommendations before filtering

Overview

JSON MCP Server

What it does

Connect to JSON data, generate TypeScript interfaces, and filter out unnecessary information. This tool is built with quicktype for robust TypeScript type generation.

For example, to get started without installation, you can use:

npx json-mcp-filter@latest

This allows you to perform tasks like:

// Simple field extraction
json_filter({
  filePath: "https://api.example.com/users",
  shape: {"name": true, "email": true}
})

Or analyze large datasets first:

// 1. Check size first
json_dry_run({filePath: "./large.json", shape: {"users": {"id": true}}})
// โ†’ "Recommended chunks: 6"

How it connects

2024-05-15T11:30:00Z

Source README

MseeP.ai Security Assessment Badge

JSON MCP Filter

A powerful Model Context Protocol (MCP) server that provides JSON schema generation and filtering tools for local files and remote HTTP/HTTPS endpoints. Built with quicktype for robust TypeScript type generation.

JSON Server MCP server

Perfect for: Filtering large JSON files and API responses to extract only relevant data for LLM context, while maintaining type safety.

โœจ Key Features

  • ๐Ÿ”„ Schema Generation - Convert JSON to TypeScript interfaces using quicktype
  • ๐ŸŽฏ Smart Filtering - Extract specific fields with shape-based filtering
  • ๐ŸŒ Remote Support - Works with HTTP/HTTPS URLs and API endpoints
  • ๐Ÿ“ฆ Auto Chunking - Handles large datasets with automatic 400KB chunking
  • ๐Ÿ›ก๏ธ Size Protection - Built-in 50MB limit with memory safety
  • โšก MCP Ready - Seamless integration with Claude Desktop and Claude Code
  • ๐Ÿšจ Smart Errors - Clear, actionable error messages with debugging info

๐Ÿ› ๏ธ Available Tools

json_schema

Generates TypeScript interfaces from JSON data.

Parameters:

  • filePath: Local file path or HTTP/HTTPS URL

Example:

// Input JSON
{"name": "John", "age": 30, "city": "New York"}

// Generated TypeScript
export interface GeneratedType {
    name: string;
    age:  number;
    city: string;
}

json_filter

Extracts specific fields using shape-based filtering with automatic chunking for large datasets.

Parameters:

  • filePath: Local file path or HTTP/HTTPS URL
  • shape: Object defining which fields to extract
  • chunkIndex (optional): Chunk index for large datasets (0-based)

Auto-Chunking:

  • โ‰ค400KB: Returns all data
  • 400KB: Auto-chunks with metadata

json_dry_run

Analyzes data size and provides chunking recommendations before filtering.

Parameters:

  • filePath: Local file path or HTTP/HTTPS URL
  • shape: Object defining what to analyze

Returns: Size breakdown and chunk recommendations

๐Ÿ“‹ Usage Examples

Basic Filtering

// Simple field extraction
json_filter({
  filePath: "https://api.example.com/users",
  shape: {"name": true, "email": true}
})

Shape Patterns

// Single field
{"name": true}

// Nested objects
{"user": {"name": true, "email": true}}

// Arrays (applies to each item)
{"users": {"name": true, "age": true}}

// Complex nested
{
  "results": {
    "profile": {"name": true, "location": {"city": true}}
  }
}

Large Dataset Workflow

// 1. Check size first
json_dry_run({filePath: "./large.json", shape: {"users": {"id": true}}})
// โ†’ "Recommended chunks: 6"

// 2. Get chunks
json_filter({filePath: "./large.json", shape: {"users": {"id": true}}})
// โ†’ Chunk 0 + metadata

json_filter({filePath: "./large.json", shape: {"users": {"id": true}}, chunkIndex: 1})
// โ†’ Chunk 1 + metadata

๐Ÿ”’ Security Notice

Remote Data Fetching: This tool fetches data from HTTP/HTTPS URLs. Users are responsible for:

โœ… Safe Practices:

  • Verify URLs point to legitimate endpoints
  • Use trusted, public APIs only
  • Respect API rate limits and terms of service
  • Review data sources before processing

โŒ Maintainers Not Responsible For:

  • External URL content
  • Privacy implications of remote requests
  • Third-party API abuse or violations

๐Ÿ’ก Recommendation: Only use trusted, public data sources.

๐Ÿš€ Quick Start

Option 1: NPX (Recommended)

# No installation required
npx json-mcp-filter@latest

Option 2: Global Install

npm install -g json-mcp-filter@latest
json-mcp-server

Option 3: From Source

git clone <repository-url>
cd json-mcp-filter
npm install
npm run build

โš™๏ธ MCP Integration

Claude Desktop

Add to your configuration file:

{
  "mcpServers": {
    "json-mcp-filter": {
      "command": "npx",
      "args": ["-y", "json-mcp-filter@latest"]
    }
  }
}

Claude Code

# Add via CLI
claude mcp add json-mcp-filter npx -y json-mcp-filter@latest

Or add manually:

  • Name: json-mcp-filter
  • Command: npx
  • Args: ["-y", "json-mcp-filter@latest"]

๐Ÿ”ง Development

Commands

npm run build      # Compile TypeScript
npm run start      # Run compiled server  
npm run inspect    # Debug with MCP inspector
npx tsc --noEmit   # Type check only

Testing

npm run inspect    # Interactive testing interface

๐Ÿ“ Project Structure

src/
โ”œโ”€โ”€ index.ts                    # Main server + tools
โ”œโ”€โ”€ strategies/                 # Data ingestion strategies
โ”‚   โ”œโ”€โ”€ JsonIngestionStrategy.ts  # Abstract interface
โ”‚   โ”œโ”€โ”€ LocalFileStrategy.ts      # Local file access
โ”‚   โ””โ”€โ”€ HttpJsonStrategy.ts       # HTTP/HTTPS fetching
โ”œโ”€โ”€ context/
โ”‚   โ””โ”€โ”€ JsonIngestionContext.ts   # Strategy management
โ””โ”€โ”€ types/
    โ””โ”€โ”€ JsonIngestion.ts          # Type definitions

๐Ÿšจ Error Handling

Comprehensive Coverage

  • Local Files: Not found, permissions, invalid JSON
  • Remote URLs: Network failures, auth errors (401/403), server errors (500+)
  • Content Size: Auto-reject >50MB with clear messages
  • Format Detection: Smart detection of HTML/XML with guidance
  • Rate Limiting: 429 responses with retry instructions
  • Processing: Quicktype errors, shape filtering issues

All errors include actionable debugging information.

โšก Performance

Processing Times

File Size Processing Time
< 100 KB < 10ms
1-10 MB 100ms - 1s
10-50 MB 1s - 5s
> 50 MB Blocked

Size Protection

  • 50MB maximum for all sources
  • Pre-download checking via Content-Length
  • Memory safety prevents OOM errors
  • Clear error messages with actual vs. limit sizes

Best Practices

  • Use json_dry_run first for large files
  • Filter with json_filter before schema generation
  • Focus shapes on essential fields only

๐ŸŒ Supported Sources

  • Public APIs - REST endpoints with JSON responses
  • Static Files - JSON files on web servers
  • Local Dev - http://localhost during development
  • Local Files - File system access

๐Ÿ’ก Common Workflows

LLM Integration:

  1. API returns large response
  2. json_filter extracts relevant fields
  3. Process clean data without noise
  4. json_schema generates types for safety

Hosted deployment

A hosted deployment is available on Fronteir AI.

Discussion

Questions & comments ยท 0

Sign In Sign in to leave a comment.