SQLite MCP Server v1.9.3 - Enhanced Virtual Tables

🚀 SQLite MCP Server v1.9.3 - Enhanced Virtual Tables

🎯 NEW: Enhanced Virtual Tables (4 New Tools)

✨ Smart CSV Import with Type Inference

• create_enhanced_csv_table - Automatic data type detection (INTEGER, REAL, TEXT, DATE)
• analyze_csv_schema - Deep CSV analysis with statistics and confidence scores
• Configurable null value handling and sampling
• Clean column name sanitization for SQL compatibility

✨ JSON Collection Virtual Tables

• create_json_collection_table - Support for JSONL and JSON array files
• analyze_json_schema - Comprehensive nested structure analysis
• Auto-format detection (JSONL vs JSON arrays)
• Nested object flattening with configurable depth
• Smart schema inference from sample records

🧠 INTELLIGENT FEATURES

• Smart Type Inference Engine: Statistical analysis of sample data
• Flexible Null Handling: Configurable null value patterns
• Nested Data Support: Flatten JSON objects with dot notation
• Performance Optimized: Configurable sampling for large files
• Error Resilient: Graceful handling of malformed data
• Schema Validation: Pre-flight analysis before table creation

📊 ENHANCED CAPABILITIES

• 44 Tools Total (was 40) - 4 new enhanced virtual table tools
• Intelligent Type Detection for CSV numeric, date, boolean patterns
• JSON Structure Analysis with nested object flattening
• File Format Auto-Detection for JSON collections
• Comprehensive Schema Reports with statistics and examples

🎯 PERFECT FOR

• Data Import Workflows: Smart CSV/JSON ingestion with type inference
• Schema Discovery: Analyze file structure before import
• ETL Processes: Automated data type conversion and validation
• Data Analysis: Quick exploration of file-based datasets
• Business Intelligence: Seamless data source integration

🚀 QUICK START

// Analyze CSV structure
analyze_csv_schema({"csv_file_path": "./data.csv"})

// Create table with smart type inference
create_enhanced_csv_table({
  "table_name": "imported_data",
  "csv_file_path": "./data.csv"
})

// Import JSON collections with flattening
create_json_collection_table({
  "table_name": "events", 
  "json_file_path": "./events.jsonl",
  "flatten_nested": true
})

Transform any CSV or JSON file into a queryable SQLite table with intelligent type inference!