SQLite MCP Server v2.4.0 🚀

[neverinfamous]

SQLite MCP Server v2.4.0 🚀
Released September 19, 2025
🎯 Major Improvements
✅ Windows SpatiaLite Compatibility Resolved
New Feature: Automatic GeomFromText preprocessing for Windows compatibility
Smart Conversions: Seamlessly converts GeomFromText calls in INSERT/UPDATE statements
Zero Breaking Changes: Existing code continues to work unchanged
Standards Compliant: Uses proper OGC GeomFromText syntax
📦 Massive Container Optimization
34% Size Reduction: Compressed container size reduced from 74.1MB to 47.3MB
Improved Performance: Faster pulls and deployments
Resource Efficiency: Lower storage and bandwidth requirements
🔧 What's New
Automatic Spatial Function Preprocessing
The server now intelligently converts GeomFromText calls for Windows compatibility:
Automatic Conversions:
GeomFromText('POINT(x y)', srid) → MakePoint(x, y, srid)
GeomFromText('POINT(x y z)', srid) → MakePointZ(x, y, z, srid) (3D points)
GeomFromText('LINESTRING(...)', srid) → GeomFromWKB(GeomFromText(...)) (complex geometries)
🐳 Docker Images
📊 Release Stats
Container Size: 47.3MB (down from 74.1MB)
New Features: 1 major (GeomFromText preprocessing)
Test Coverage: +9 comprehensive test cases
Breaking Changes: None
Platform Support: Enhanced Windows compatibility
Full Changelog: v2.3.0...v2.4.0
This release represents a significant milestone with both performance optimizations and feature enhancements that directly benefit Windows users working with spatial data. The 34% container size reduction combined with resolving the GeomFromText limitation makes this a compelling upgrade! 🎉

---

This discussion was created from the release SQLite MCP Server v2.4.0 🚀.