- **Backup/Restore Operations**: Enterprise-grade backup and restore capabilities with SQLite backup API, integrity verification, and safety confirmations

[neverinfamous]

🎉 SQLite MCP Server v2.2.0: Advanced Text Processing

🚀 Major Feature Release

This release introduces a comprehensive Advanced Text Processing toolkit, transforming SQLite MCP Server into a powerful text analysis and processing platform with 67 total tools.

✨ NEW: Advanced Text Processing (8 Tools)

Pattern Extraction & Replacement

• regex_extract: PCRE-style regex pattern extraction with capture groups and flags
• regex_replace: Text replacement with backreferences and safe preview mode

Similarity & Matching

• fuzzy_match: Levenshtein distance similarity matching with configurable thresholds
• phonetic_match: Soundex and Metaphone phonetic matching for name variations
• text_similarity: Multi-algorithm similarity analysis (Cosine, Jaccard, Levenshtein)

Text Processing & Validation

• text_normalize: Multi-operation text normalization (case, Unicode, whitespace, punctuation)
• advanced_search: Multi-method search combining exact, fuzzy, and phonetic techniques
• text_validation: Comprehensive pattern validation (email, phone, URL, custom regex)

🔧 Key Features

• PCRE Regex Support: Full Perl-compatible regex with flags (case-insensitive, multiline, dotall)
• Fuzzy Matching: Intelligent similarity scoring with configurable thresholds
• Phonetic Algorithms: Soundex implementation for sound-alike matching
• Multiple Similarity Metrics: Cosine, Jaccard, and Levenshtein distance calculations
• Safe Preview Modes: Preview destructive operations before execution
• Comprehensive Validation: Email, phone, URL, and custom pattern validation
• Performance Optimized: Configurable limits and efficient algorithms

🐛 Bug Fixes

• Fixed: Duplicate WHERE clause SQL bug in text_normalize function
• Improved: Rowid handling for better table compatibility
• Enhanced: Error handling and validation across all text processing functions

📊 Expanded Capabilities

• Total Tools: 67 (59 existing database/analytics + 8 new text processing)
• Pure SQLite: No external dependencies required
• MCP Compatible: Full Model Context Protocol integration
• Enterprise Ready: Production-ready with comprehensive error handling

🔗 Integration Examples

# Extract email addresses with regex
regex_extract(table="contacts", column="info", pattern=r"[\w.-]+@[\w.-]+\.\w+")

# Find similar customer names with fuzzy matching  
fuzzy_match(table="customers", column="name", search_term="John Smith", threshold=0.8)

# Validate email addresses in bulk
text_validation(table="users", column="email", validation_type="email")

# Normalize text data with multiple operations
text_normalize(table="reviews", column="comment", 
               operations=["lowercase", "trim", "remove_extra_spaces"])

🎯 Perfect For

• Data Cleaning: Normalize and validate text data
• Fuzzy Matching: Find similar records with typos or variations
• Pattern Extraction: Extract structured data from unstructured text
• Data Validation: Ensure data quality with pattern validation
• Text Analysis: Comprehensive text similarity and phonetic analysis

📈 Performance

• Efficient Algorithms: Optimized for large datasets
• Configurable Limits: Control performance vs accuracy trade-offs
• Memory Optimized: Streaming operations for large text processing
• SQLite Native: Leverages SQLite's performance optimizations

---

Full Documentation: See README.md for complete feature documentation and examples.

Docker: docker pull ghcr.io/neverinfamous/sqlite-mcp-server:v2.2.0

---

This discussion was created from the release - **Backup/Restore Operations**: Enterprise-grade backup and restore capabilities with SQLite backup API, integrity verification, and safety confirmations.