SQLite MCP Server v2.4.0 - Windows GeomFromText Compatibility + Major Optimizations

[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:

\\sql
-- These now work seamlessly on Windows:
INSERT INTO spatial_table (geom) VALUES (GeomFromText('POINT(1 2)', 4326));
UPDATE spatial_table SET geom = GeomFromText('POINT(10 20)', 3857) WHERE id = 1;
\\

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

\\�ash

Latest stable release

docker pull writenotenow/sqlite-mcp-server:latest
docker pull writenotenow/sqlite-mcp-server:v2.4.0
\\

📊 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 discussion was created from the release SQLite MCP Server v2.4.0 - Windows GeomFromText Compatibility + Major Optimizations.