SQLite MCP Server v2.6.1: Complete JSON Operations Suite

Transform your JSON workflows with 6 powerful new tools and enterprise-grade automation

🆕 What's New in v2.6.1

🎯 JSON Helper Tools (6 New Tools)

Dramatically simplify JSON operations with dedicated, secure tools:

• json_insert - Secure JSON data insertion with auto-normalization
• json_update - Path-based JSON updates with validation
• json_select - Flexible JSON extraction with multiple output formats
• json_query - Advanced JSON filtering, aggregation, and sorting
• json_validate_path - JSONPath validation before operations
• json_merge - Intelligent JSON object merging with conflict resolution

🤖 JSON Auto-Normalization Enhanced

• Configurable strict mode for production environments
• Security-aware normalization with malicious pattern detection
• Automatic Python-style JSON fixes (single quotes, True/False, None, trailing commas)

🛡️ Parameter Binding Interface

• Enhanced MCP tools with optional params arrays for secure parameter binding
• SQL injection prevention using SQLite's built-in parameter binding protection
• Backward compatible - existing queries continue to work unchanged

📦 Automatic Parameter Serialization

• Direct object/array parameters - no more manual JSON.stringify() required
• Seamless integration - dict/list objects automatically serialized to JSON
• Cleaner API for both humans and AI assistants

🧠 Enhanced JSON Error Diagnostics

• Intelligent error categorization - structural, security, encoding issues identified
• Contextual guidance with specific suggestions for fixing complex JSON problems
• Security violation detection with clear messaging for suspicious patterns

📊 By the Numbers

• 73 Tools (up from 69) across 14 Categories (up from 13)
• 6 New JSON Helper Tools for simplified operations
• 5 Major Feature Enhancements across the platform
• Zero Breaking Changes - all existing code continues to work

🚀 Quick Start

# Docker (Recommended)
docker pull writenotenow/sqlite-mcp-server:v2.6.1
docker run -i --rm -v $(pwd):/workspace writenotenow/sqlite-mcp-server:v2.6.1 --db-path /workspace/database.db

# Test all 73 tools
python test_runner.py --quick

🎯 JSON Helper Tools Examples

// Insert JSON with auto-normalization
json_insert({
  "table": "products",
  "column": "metadata",
  "data": {"name": "Product", "active": true, "tags": ["new"]}
})

// Update specific JSON paths
json_update({
  "table": "products", 
  "column": "metadata",
  "path": "$.pricing.discount",
  "value": 15.5
})

// Extract with multiple output formats
json_select({
  "table": "products",
  "column": "metadata", 
  "paths": ["$.name", "$.pricing.base_price"],
  "output_format": "structured"
})

🛡️ Enhanced Security

// Before v2.6.1 - Manual serialization required
write_query({
  "query": "INSERT INTO table (data) VALUES (?)",
  "params": [JSON.stringify({"key": "value"})]
})

// After v2.6.1 - Automatic serialization!
write_query({
  "query": "INSERT INTO table (data) VALUES (?)", 
  "params": [{"key": "value"}]  // Auto-serialized with security checks
})

🔧 Migration Guide

v2.6.1 is fully backward compatible! All existing code continues to work unchanged. New features are additive and optional.

To use new JSON Helper Tools:

1. Update to v2.6.1: docker pull writenotenow/sqlite-mcp-server:v2.6.0
2. Use new json_* tools for simplified operations
3. Enjoy automatic parameter serialization and enhanced security

📚 Documentation

• Complete Documentation - Comprehensive guide with examples
• Quick Start Guide - Get up and running in minutes
• Docker Hub - Container images and deployment guides

🙏 Contributors

Special thanks to the community for feedback and testing that made this release possible!

---

Full Changelog: v2.5.0...v2.6.0