Home
Last Updated: January 13, 2026 - Production/Stable v2.6.5
🤖 Can't find what you're looking for? Try our AI-Powered Wiki Search - Ask questions in natural language and get instant answers with source attribution. Example: "How do I prevent SQL injection attacks?"
The SQLite MCP Server transforms SQLite into a powerful, AI-ready database engine. It combines standard relational operations with advanced analytics, text and vector search, geospatial capabilities, and intelligent workflow automation. By layering business intelligence tools, semantic resources, and guided prompts on top of SQLite, it enables both developers and AI assistants to interact with data more naturally and effectively.
This makes it not just a database interface, but a workflow-aware assistant for developers and AI systems.
🐍 Python 3.14 Upgrade - Docker images now use Python 3.14 Alpine base:
- CI matrix tests Python 3.11, 3.12, 3.13, and 3.14
- Dependency updates: mcp 1.25.0, starlette 0.51.0, pydantic-core 2.41.5
- All 73 tools verified working on Python 3.14
See Changelog for full version history.
- Quick-Start - Installation, configuration, and first steps
- Core-Database-Tools - Essential CRUD operations (15 tools)
- JSON-Helper-Tools - v2.6.0+: Complete JSON manipulation suite (6 tools)
- Security-and-Data-Integrity - Parameter binding, JSONB, transactions
- Advanced-Text-Processing - Regex, fuzzy matching, similarity (8 tools)
- Statistical-Analysis - Descriptive stats, percentiles, time series (8 tools)
- Full-Text-Search - FTS5 implementation with BM25 ranking (3 tools)
- Backup-and-Restore - Enterprise-grade backup operations (5 tools)
- PRAGMA-Operations - Database configuration and optimization (5 tools)
- Virtual-Tables - R-Tree spatial indexing, CSV import/export (6 tools)
- Enhanced-Virtual-Tables - Smart CSV/JSON import with schema inference (4 tools)
- Semantic-Vector-Search - AI-native embeddings and similarity search (6 tools)
- SpatiaLite-Geospatial - Enterprise GIS with spatial analytics (7 tools)
- Vector-Index-Optimization - ANN search with k-means clustering (4 tools)
- Tool-Filtering - 🆕 v2.6.4: Selectively enable/disable tools for client compatibility
- MCP-Resources-and-Prompts - Intelligent workflow automation (7 resources + 7 prompts)
- Best-Practices - Usage patterns and recommendations
- Troubleshooting - Common issues and solutions
- Changelog - Version history and release notes
73 Total Tools Across 10 Groups (all tested and verified ✅):
| Group | Tools | Description |
|---|---|---|
| Core | 5 | Basic CRUD: read_query, write_query, create_table, list_tables, describe_table |
| FTS | 4 | Full-text search: fts_search, create_fts_table, rebuild_fts_index, hybrid_search |
| Vector | 11 | Semantic/vector search and embeddings |
| JSON | 9 | JSON operations and validation |
| Virtual | 8 | Virtual tables: CSV, R-Tree, series |
| Spatial | 7 | SpatiaLite geospatial operations |
| Text | 7 | Text processing: fuzzy, phonetic, regex |
| Stats | 8 | Statistical analysis |
| Admin | 14 | Database administration and PRAGMA |
| Misc | 5 | Miscellaneous utilities |
Additional Capabilities:
- 🤖 MCP Resources (7) - Dynamic database meta-awareness resources
- 🎯 MCP Prompts (7) - Guided workflow automation
Reduce tool count for MCP clients with limits:
# Reduce to ~40 tools (Windsurf-compatible)
SQLITE_MCP_TOOL_FILTER="-vector,-stats,-spatial,-text"
# Read-only mode
SQLITE_MCP_TOOL_FILTER="-write_query,-create_table"
# Core + JSON only (~14 tools)
SQLITE_MCP_TOOL_FILTER="-fts,-vector,-virtual,-spatial,-text,-stats,-admin,-misc"See Tool Filtering for complete documentation.
Run instantly with Docker (creates a project-local database):
docker run -i --rm \
-v $(pwd):/workspace \
writenotenow/sqlite-mcp-server:latest \
--db-path /workspace/sqlite_mcp.dbWith tool filtering for Windsurf:
docker run -i --rm \
-e SQLITE_MCP_TOOL_FILTER="-vector,-stats,-spatial,-text" \
-v $(pwd):/workspace \
writenotenow/sqlite-mcp-server:latest \
--db-path /workspace/sqlite_mcp.db- 📋 Changelog - Version history and release notes
- 📰 v2.6.0 Release Article - JSON operations, auto-normalization, and enhanced security
- 🤖 AI-Powered Wiki Search - Search this documentation with natural language queries
- GitHub Repository - Source code and issues
- Docker Hub - Container images
- PyPI Package - Python package
- GitHub Gists - 9 practical examples and use cases
- Testing Guide - Comprehensive testing documentation
- Security Policy - Security guidelines and reporting
- Contributing - How to contribute to the project
- GitHub Releases - Version history
📝 Note: MCP Resources (7) and Prompts (7) are separate from the tool count - they provide metadata and workflow guidance but don't count toward the 73-tool limit.
🎛️ Tool Filtering: The server exposes 73 tools by default. Use SQLITE_MCP_TOOL_FILTER to reduce tool count for clients with limits. See Tool Filtering for details.