# SQLite MCP Server
*Last Updated October 9, 2025 - Production/Stable v2.6.3*
*Enterprise-grade SQLite with AI-native JSON operations & intelligent workflow automation – v2.6.3*
[](https://hub.docker.com/r/writenotenow/sqlite-mcp-server)
[](https://pypi.org/project/sqlite-mcp-server-enhanced/)
Transform SQLite into a powerful, AI-ready database engine with **73 specialized tools** for advanced analytics, JSON operations, text processing, vector search, geospatial operations, and intelligent workflow automation.
<!-- mcp-name: io.github.neverinfamous/sqlite-mcp-server -->
---
## 📋 Table of Contents
### Quick Start
- [✅ Quick Test - Verify Everything Works](#-quick-test---verify-everything-works)
- [🚀 Quick Start](#-quick-start)
- [🔥 Core Capabilities](#-core-capabilities)
- [🏢 Enterprise Features](#-enterprise-features)
### Configuration & Usage
- [📚 MCP Client Configuration](#-mcp-client-configuration)
- [🎨 Usage Examples](#-usage-examples)
- [📊 Tool Categories](#-tool-categories)
### Resources & Information
- [🏆 Why Choose SQLite MCP Server?](#-why-choose-sqlite-mcp-server)
- [🔍 AI-Powered Wiki Search](#-ai-powered-wiki-search)
- [📚 Complete Documentation](#-complete-documentation)
- [🔗 Additional Resources](#-additional-resources)
- [🚀 Quick Links](#-quick-links)
- [📈 Project Stats](#-project-stats)
---
## ✅ **Quick Test - Verify Everything Works**
**Test all 73 tools in 30 seconds!**
Quick smoke test:
```bash
python test_runner.py --quick
```
Standard comprehensive test (recommended):
```bash
python test_runner.py --standard
```
Full test suite with edge cases:
```bash
python test_runner.py --full
```
**Expected output:**
```
🚀 SQLite MCP Server Comprehensive Test Suite v2.6.3
================================================================
🔍 Environment Detection:
✅ SQLite 3.50.4 (JSONB supported)
✅ Python 3.12.11
✅ MCP 1.14.0
✅ Pyright strict type checking: PASS
📊 Testing 73 Tools across 14 categories...
✅ Core Database Operations (8/8 passed)
✅ JSON Helper Tools (6/6 passed)
✅ JSON Operations (12/12 passed)
✅ Text Processing (8/8 passed)
🎉 SUCCESS: All 73 tools tested successfully!
```
### 🛡️ **Security Testing**
**NEW: Comprehensive SQL injection protection testing**
Test SQL injection protection (from tests directory):
```bash
cd tests && python test_sql_injection.py
```
Expected result: 🛡️ Overall security posture: STRONG
**What it tests:**
- Protection against the SQL injection vulnerability found in original Anthropic SQLite MCP server
- 11 different attack vectors including multiple statements, UNION injection, blind injection
- Parameter binding protection with malicious payloads
- Stacked queries and comment-based injection attempts
[⬆️ Back to Table of Contents](#-table-of-contents)
## 🚀 **Quick Start**
### **Option 1: Docker (Recommended)**
Pull and run instantly:
```bash
docker pull writenotenow/sqlite-mcp-server:latest
```
Run with volume mount:
```bash
docker run -i --rm \
-v $(pwd):/workspace \
writenotenow/sqlite-mcp-server:latest \
--db-path /workspace/database.db
```
#### 🛡️ **Supply Chain Security**
For enhanced security and reproducible builds, use SHA-pinned images:
Find available SHA tags at: https://hub.docker.com/r/writenotenow/sqlite-mcp-server/tags
Look for tags starting with "master-" or "sha256-" for cryptographically verified builds
Option 1: Human-readable timestamped builds (recommended)
```bash
docker pull writenotenow/sqlite-mcp-server:master-YYYYMMDD-HHMMSS-<commit>
```
Option 2: Multi-arch manifest digest (maximum security)
```bash
docker pull writenotenow/sqlite-mcp-server@sha256:<manifest-digest>
```
Example: Run with cryptographically verified image
```bash
docker run -i --rm \
-v $(pwd):/workspace \
writenotenow/sqlite-mcp-server:master-YYYYMMDD-HHMMSS-<commit> \
--db-path /workspace/database.db
```
**How to Find SHA Tags:**
1. Visit [Docker Hub Tags](https://hub.docker.com/r/writenotenow/sqlite-mcp-server/tags)
2. **For convenience**: Use `master-YYYYMMDD-HHMMSS-<commit>` tags (human-readable, multi-arch)
3. **For maximum security**: Use `sha256-<hash>` tags (manifest digests, immutable)
**Understanding SHA Tags:**
- 🏷️ **`master-YYYYMMDD-HHMMSS-<commit>`** - Human-readable, timestamped, multi-arch safe
- 🔒 **`sha256-<manifest-digest>`** - Multi-arch manifest digest (works on all architectures)
- ⚠️ **Architecture-specific digests** - Only for debugging specific architectures
**Security Features:**
- ✅ **Build Provenance** - Cryptographic proof of build process
- ✅ **SBOM Available** - Complete software bill of materials
- ✅ **Supply Chain Attestations** - Verifiable build integrity
- ✅ **Reproducible Builds** - Exact image verification for compliance
### **Option 2: Python Installation**
Install from PyPI:
```bash
pip install sqlite-mcp-server-enhanced
```
Or install from source:
```bash
git clone https://github.com/neverinfamous/sqlite-mcp-server.git
```
Navigate to directory:
```bash
cd sqlite-mcp-server
```
Install requirements:
```bash
pip install -r requirements.txt
```
Run the server:
```bash
python start_sqlite_mcp.py --db-path ./database.db
```
### **Option 3: Test in 30 Seconds**
Clone repository:
```bash
git clone https://github.com/neverinfamous/sqlite-mcp-server.git
```
Navigate to directory:
```bash
cd sqlite-mcp-server
```
Run quick test:
```bash
python test_runner.py --quick
```
### **🆕 NEW in v2.6.0: Complete JSON Operations Suite**
**5 Major Improvements in this release:**
- 🎯 **JSON Helper Tools** - 6 specialized tools for simplified JSON operations with path validation and merging
- 🤖 **JSON Auto-Normalization** - Automatically fixes Python-style JSON with configurable strict mode
- 🛡️ **Parameter Binding Interface** - Enhanced MCP tools with SQL injection prevention
- 📦 **Automatic Parameter Serialization** - Direct object/array parameters, no manual JSON.stringify()
- 🧠 **Enhanced JSON Error Diagnostics** - Intelligent error categorization with contextual guidance
### **🔥 Core Capabilities**
- 📊 **Statistical Analysis** - Descriptive stats, percentiles, time series analysis
- 🔍 **Advanced Text Processing** - Regex, fuzzy matching, phonetic search, similarity
- 🧠 **Vector/Semantic Search** - AI-native embeddings, cosine similarity, hybrid search
- 🗺️ **SpatiaLite Geospatial** - Enterprise GIS with spatial indexing and operations
- 🔐 **Transaction Safety** - Auto-wrapped transactions with rollback protection
- 🎛️ **73 Specialized Tools** - Complete database administration and analytics suite
### **🏢 Enterprise Features**
- 📈 **Business Intelligence** - Integrated insights memo and workflow automation
- 🔄 **Backup/Restore** - Enterprise-grade operations with integrity verification
- 🎯 **Full-Text Search (FTS5)** - Advanced search with BM25 ranking and snippets
- 🏗️ **Virtual Tables** - Smart CSV/JSON import with automatic type inference
- ⚙️ **Advanced PRAGMA** - Complete SQLite configuration and optimization
[⬆️ Back to Table of Contents](#-table-of-contents)
## 📚 **MCP Client Configuration**
### **Claude Desktop**
```json
{
"mcpServers": {
"sqlite-mcp-server": {
"command": "python",
"args": ["/path/to/sqlite-mcp-server/start_sqlite_mcp.py", "--db-path", "/path/to/database.db"]
}
}
}
```
### **Docker with Claude Desktop**
```json
{
"mcpServers": {
"sqlite-mcp-server": {
"command": "docker",
"args": ["run", "-i", "--rm", "-v", "/path/to/project:/workspace", "writenotenow/sqlite-mcp-server:latest", "--db-path", "/workspace/database.db"]
}
}
}
```
[⬆️ Back to Table of Contents](#-table-of-contents)
## 🎨 **Usage Examples**
### **Data Analysis Workflow**
1. Quick validation:
```bash
python test_runner.py --quick
```
2. Start with your data:
```bash
python start_sqlite_mcp.py --db-path ./sales_data.db
```
3. Use with Claude/Cursor for:
- Statistical analysis of your datasets
- Text processing and pattern extraction
- Vector similarity search
- Geospatial analysis and mapping
- Business intelligence insights
### **Docker Development**
Development with live reload:
```bash
docker run -i --rm \
-v $(pwd):/workspace \
-e SQLITE_DEBUG=true \
writenotenow/sqlite-mcp-server:latest \
--db-path /workspace/dev.db
```
### **🎯 JSON Helper Tools - Simplified JSON Operations**
**NEW in v2.6.0:** Six powerful JSON helper tools that make complex JSON operations simple:
```javascript
// ✅ Insert JSON with auto-normalization
json_insert({
"table": "products",
"column": "metadata",
"data": {'name': 'Product', 'active': True, 'price': None}
})
// ✅ Update JSON by path
json_update({
"table": "products",
"column": "metadata",
"path": "$.price",
"value": 29.99,
"where_clause": "id = 1"
})
// ✅ Query JSON with complex filtering
json_query({
"table": "products",
"column": "metadata",
"filter_paths": {"$.category": "electronics"},
"select_paths": ["$.name", "$.price"]
})
```
**JSON Helper Tools:**
- 🎯 **json_insert** - Insert JSON data with auto-normalization
- 🔄 **json_update** - Update JSON by path with creation support
- 🔍 **json_select** - Extract JSON data with multiple output formats
- 🔎 **json_query** - Complex JSON filtering and aggregation
- ✅ **json_validate_path** - Validate JSON paths with security checks
- 🔗 **json_merge** - Merge JSON objects with conflict resolution
**Auto-normalization still works:**
- 🔧 Single quotes → Double quotes
- 🔧 Python `True`/`False` → JSON `true`/`false`
- 🔧 Python `None` → JSON `null`
- 🔧 Trailing commas removed
- 🛡️ Security validation prevents malicious input
### **🧠 Enhanced JSON Error Diagnostics**
**Enhanced in v2.6.0:** When JSON validation fails, get intelligent, contextual error messages with specific guidance:
```javascript
// ❌ Invalid JSON input:
validate_json('{key_without_quotes: "value"}')
// ✅ Enhanced error response:
{
"valid": false,
"error": "Expecting property name enclosed in double quotes: line 1 column 2 (char 1)",
"enhanced_message": "JSON validation failed (structural_syntax): Expecting property name...",
"error_context": {
"error_type": "structural_syntax",
"security_concern": false,
"suggestions": [
"Ensure all object keys are properly quoted strings",
"Check for missing colons (:) between keys and values",
"Verify proper key-value pair structure: \"key\": \"value\""
]
}
}
```
**Enhanced Error Categories:**
- 🔧 **Structural Issues** - Missing quotes, colons, brackets with specific fix suggestions
- 🛡️ **Security Warnings** - Detects potential SQL injection patterns in JSON strings
- 📝 **Encoding Problems** - Character encoding and escape sequence guidance
- 🎯 **Context-Aware Tips** - Line/column position with targeted recommendations
### **🛡️ Enhanced Parameter Binding + Auto-Serialization**
**NEW in v2.6.0:** Built-in SQL injection protection with automatic JSON serialization:
```javascript
// ✅ SECURE: Parameter binding prevents injection
read_query({
"query": "SELECT * FROM users WHERE name = ? AND age > ?",
"params": ["John", 25]
})
// ✅ NEW: Direct object/array parameters (auto-serialized)
write_query({
"query": "INSERT INTO products (metadata, tags) VALUES (?, ?)",
"params": [
{"name": "Product", "price": 29.99, "active": true}, // Auto-serialized to JSON
["electronics", "featured", "new"] // Auto-serialized to JSON
]
})
// ✅ SIMPLIFIED: No more manual JSON.stringify()
// Before v2.6.0:
write_query({
"query": "INSERT INTO table (data) VALUES (?)",
"params": [JSON.stringify({"key": "value"})] // Manual serialization required
})
// After v2.6.0:
write_query({
"query": "INSERT INTO table (data) VALUES (?)",
"params": [{"key": "value"}] // Automatic serialization!
})
```
**v2.6.0 Benefits:**
- 🛡️ **SQL Injection Prevention** - Parameter binding treats malicious input as literal data
- 📦 **Auto-Serialization** - Objects and arrays automatically converted to JSON strings
- 🔄 **Backward Compatible** - Existing queries continue to work unchanged
- ⚡ **Better Performance** - Query plan caching and parameter optimization
- 📝 **Cleaner API** - No manual JSON.stringify() or parameter preparation needed
[⬆️ Back to Table of Contents](#-table-of-contents)
## 📊 **Tool Categories**
The SQLite MCP Server provides **73 specialized tools** across **14 categories**:
> 💡 **Want the complete tool list?** See the [**detailed tool reference**](./docs/sqlite-mcp-server.wiki/Home.md) with descriptions for all 73 tools, 7 resources, and 7 prompts.
| Category | Tool Count | Description |
|----------|------------|-------------|
| **[Core Database](./docs/sqlite-mcp-server.wiki/Core-Database-Tools.md)** | 15 | CRUD operations, schema management, transactions |
| **[JSON Helper Tools](./docs/sqlite-mcp-server.wiki/JSON-Helper-Tools.md)** | 6 | Simplified JSON operations, path validation, merging |
| **[Text Processing](./docs/sqlite-mcp-server.wiki/Advanced-Text-Processing.md)** | 9 | Regex, fuzzy matching, phonetic search, similarity |
| **[Statistical Analysis](./docs/sqlite-mcp-server.wiki/Statistical-Analysis.md)** | 8 | Descriptive stats, percentiles, time series |
| **[Virtual Tables](./docs/sqlite-mcp-server.wiki/Virtual-Tables.md)** | 8 | CSV, R-Tree, series generation |
| **[Semantic Search](./docs/sqlite-mcp-server.wiki/Semantic-Vector-Search.md)** | 8 | Embeddings, similarity, hybrid search |
| **[Geospatial](./docs/sqlite-mcp-server.wiki/SpatiaLite-Geospatial.md)** | 7 | Spatial indexing, geometric operations |
| **[PRAGMA Operations](./docs/sqlite-mcp-server.wiki/PRAGMA-Operations.md)** | 5 | Configuration, optimization, introspection |
| **[Full-Text Search](./docs/sqlite-mcp-server.wiki/Full-Text-Search.md)** | 3 | FTS5 creation, indexing, BM25 ranking |
| **[Vector Optimization](./docs/sqlite-mcp-server.wiki/Vector-Index-Optimization.md)** | 2 | ANN search, clustering, performance |
| **[Data Analysis](./docs/sqlite-mcp-server.wiki/Enhanced-Virtual-Tables.md)** | 2 | Smart CSV/JSON import with type inference |
| **[Resources](./docs/sqlite-mcp-server.wiki/MCP-Resources-and-Prompts.md)** | 7 | Database meta-awareness, performance insights |
| **[Prompts](./docs/sqlite-mcp-server.wiki/MCP-Resources-and-Prompts.md)** | 7 | Guided workflows, optimization recipes |
> 💡 **Cursor Users:** You can enable only the categories you need in your MCP client settings to reduce tool noise and improve stability. Each number above shows the **count of tools** in that category.
[⬆️ Back to Table of Contents](#-table-of-contents)
## 🏆 **Why Choose SQLite MCP Server?**
✅ **AI-Friendly** - JSON auto-normalization and intelligent error messages reduce debugging time
✅ **Just Works** - Built-in security and parameter binding with zero configuration
✅ **Smart Diagnostics** - Enhanced error context provides actionable guidance when issues occur
✅ **Type Safe** - Passes strict Pyright type checking in Cursor for maximum code quality
✅ **Instantly Testable** - Validate all 73 tools in 30 seconds
✅ **Production Ready** - Enterprise-grade testing and validation
✅ **Comprehensive** - Everything you need in one package
✅ **Docker Ready** - Containerized for easy deployment
✅ **Zero Breaking Changes** - All existing code continues to work
[⬆️ Back to Table of Contents](#-table-of-contents)
## 🔍 **AI-Powered Wiki Search**
**[→ Search the Documentation with AI](https://search.adamic.tech)**
Can't find what you're looking for? Use our **AI-powered search interface** to search both SQLite and PostgreSQL MCP Server documentation:
- 🤖 **Natural Language Queries** - Ask questions in plain English and get AI-generated answers
- ⚡ **Instant Results** - AI-enhanced answers with source attribution from both wikis
- 📚 **Comprehensive Coverage** - Searches all 73 SQLite tools + 63 PostgreSQL tools (136 total)
- 🎯 **Smart Context** - Understands technical questions and provides relevant examples
- 🔄 **Dual Search Modes** - AI-Enhanced for synthesized answers, or Raw Docs for direct chunks
**Example queries:**
- "How do I prevent SQL injection attacks?"
- "What statistical analysis tools are available?"
- "How do I set up vector search with embeddings?"
- "How do I use JSON helper tools for data normalization?"
- "What SpatiaLite geospatial operations are available?"
**[→ Try AI Search Now](https://search.adamic.tech)**
The search interface uses Cloudflare's AI Search technology to provide intelligent, context-aware answers from comprehensive wiki documentation for both SQLite and PostgreSQL MCP Servers.
[⬆️ Back to Table of Contents](#-table-of-contents)
## 📚 **Complete Documentation**
**[→ Wiki: Comprehensive Documentation & Examples](https://github.com/neverinfamous/sqlite-mcp-server/wiki)**
Comprehensive documentation including:
- **Detailed tool reference** - All 73 tools with examples
- **Advanced configuration** - Performance tuning and optimization
- **Integration guides** - MCP clients, Docker, CI/CD
- **Feature deep-dives** - Text processing, vector search, geospatial
- **Best practices** - Query patterns, troubleshooting, workflows
- **API reference** - Complete tool schemas and parameters
**[→ GitHub Gists: Practical Examples & Use Cases](https://gist.github.com/neverinfamous/0c8ed77ddaff0edbe31df4f4e18c33ce)**
9 curated gists with real-world examples:
- **JSON Helper Tools** - Simplified JSON operations with auto-normalization
- **Vector/Semantic Search** - AI-native embeddings and similarity search
- **SpatiaLite GIS** - Geospatial operations and spatial indexing
- **Performance Optimization** - Query tuning and index recommendations
- **Security Best Practices** - SQL injection prevention and safe queries
- **Real-World Use Cases** - Business intelligence and data analysis workflows
- **Database Migration** - Schema evolution and data transformation
- **Docker Deployment** - Production containerization strategies
- **Complete Feature Showcase** - All 73 tools with comprehensive examples
[⬆️ Back to Table of Contents](#-table-of-contents)
## 🔗 **Additional Resources**
- **[Testing Guide](./tests/README.md)** - Comprehensive testing documentation
- **[Contributing](./CONTRIBUTING.md)** - How to contribute to the project
- **[Security Policy](./SECURITY.md)** - Security guidelines and reporting
- **[Code of Conduct](./CODE_OF_CONDUCT.md)** - Community guidelines
- **[Docker Hub](https://hub.docker.com/r/writenotenow/sqlite-mcp-server)** - Container images
- **[GitHub Releases](https://github.com/neverinfamous/sqlite-mcp-server/releases)** - Version history
- **[Adamic Support Blog](https://adamic.tech/)** - Project announcements and releases
[⬆️ Back to Table of Contents](#-table-of-contents)
## 🚀 **Quick Links**
| Action | Command |
|--------|---------|
| **AI-Powered Search** | [search.adamic.tech](https://search.adamic.tech) |
| **Test Everything** | `python test_runner.py --standard` |
| **Docker Quick Start** | `docker run -i --rm -v $(pwd):/workspace writenotenow/sqlite-mcp-server:latest` |
| **Install from PyPI** | `pip install sqlite-mcp-server-enhanced` |
| **View Full Docs** | [docs/sqlite-mcp-server.wiki](./docs/sqlite-mcp-server.wiki/Home.md) |
| **Report Issues** | [GitHub Issues](https://github.com/neverinfamous/sqlite-mcp-server/issues) |
[⬆️ Back to Table of Contents](#-table-of-contents)
## 📈 **Project Stats**
- **73 Tools** across 14 categories (all tested and verified ✅)
- **2,000+ lines** of comprehensive documentation
- **Multi-platform** support (Windows, Linux, macOS)
- **Docker images** for amd64 and arm64
- **Strict type checking** with Pyright for code quality
- **Enterprise testing** with comprehensive validation
- **Active development** with regular updates
[⬆️ Back to Table of Contents](#-table-of-contents)
Raw data
{
"_id": null,
"home_page": null,
"name": "sqlite-mcp-server-enhanced",
"maintainer": null,
"docs_url": null,
"requires_python": ">=3.10",
"maintainer_email": null,
"keywords": "database, jsonb, mcp, model-context-protocol, sqlite",
"author": null,
"author_email": "Chris LeRoux <writenotenow@gmail.com>",
"download_url": "https://files.pythonhosted.org/packages/52/bf/61efef690b2b4cf36ac17d2c4bbaed424f3a2f08a9f6bed464894eecf210/sqlite_mcp_server_enhanced-2.6.3.tar.gz",
"platform": null,
"description": "# SQLite MCP Server\n\n*Last Updated October 9, 2025 - Production/Stable v2.6.3*\n\n*Enterprise-grade SQLite with AI-native JSON operations & intelligent workflow automation \u2013 v2.6.3*\n\n[](https://hub.docker.com/r/writenotenow/sqlite-mcp-server)\n\n\n\n[](https://pypi.org/project/sqlite-mcp-server-enhanced/)\n\nTransform SQLite into a powerful, AI-ready database engine with **73 specialized tools** for advanced analytics, JSON operations, text processing, vector search, geospatial operations, and intelligent workflow automation.\n\n<!-- mcp-name: io.github.neverinfamous/sqlite-mcp-server -->\n\n---\n\n## \ud83d\udccb Table of Contents\n\n### Quick Start\n- [\u2705 Quick Test - Verify Everything Works](#-quick-test---verify-everything-works)\n- [\ud83d\ude80 Quick Start](#-quick-start)\n- [\ud83d\udd25 Core Capabilities](#-core-capabilities)\n- [\ud83c\udfe2 Enterprise Features](#-enterprise-features)\n\n### Configuration & Usage\n- [\ud83d\udcda MCP Client Configuration](#-mcp-client-configuration)\n- [\ud83c\udfa8 Usage Examples](#-usage-examples)\n- [\ud83d\udcca Tool Categories](#-tool-categories)\n\n### Resources & Information\n- [\ud83c\udfc6 Why Choose SQLite MCP Server?](#-why-choose-sqlite-mcp-server)\n- [\ud83d\udd0d AI-Powered Wiki Search](#-ai-powered-wiki-search)\n- [\ud83d\udcda Complete Documentation](#-complete-documentation)\n- [\ud83d\udd17 Additional Resources](#-additional-resources)\n- [\ud83d\ude80 Quick Links](#-quick-links)\n- [\ud83d\udcc8 Project Stats](#-project-stats)\n\n---\n\n## \u2705 **Quick Test - Verify Everything Works**\n\n**Test all 73 tools in 30 seconds!**\n\nQuick smoke test:\n```bash\npython test_runner.py --quick\n```\n\nStandard comprehensive test (recommended):\n```bash\npython test_runner.py --standard\n```\n\nFull test suite with edge cases:\n```bash\npython test_runner.py --full\n```\n\n**Expected output:**\n```\n\ud83d\ude80 SQLite MCP Server Comprehensive Test Suite v2.6.3\n================================================================\n\n\ud83d\udd0d Environment Detection:\n \u2705 SQLite 3.50.4 (JSONB supported)\n \u2705 Python 3.12.11 \n \u2705 MCP 1.14.0\n \u2705 Pyright strict type checking: PASS\n\n\ud83d\udcca Testing 73 Tools across 14 categories...\n\n\u2705 Core Database Operations (8/8 passed)\n\u2705 JSON Helper Tools (6/6 passed) \n\u2705 JSON Operations (12/12 passed) \n\u2705 Text Processing (8/8 passed)\n\ud83c\udf89 SUCCESS: All 73 tools tested successfully!\n```\n\n### \ud83d\udee1\ufe0f **Security Testing**\n\n**NEW: Comprehensive SQL injection protection testing**\n\nTest SQL injection protection (from tests directory):\n```bash\ncd tests && python test_sql_injection.py\n```\n\nExpected result: \ud83d\udee1\ufe0f Overall security posture: STRONG\n\n**What it tests:**\n- Protection against the SQL injection vulnerability found in original Anthropic SQLite MCP server\n- 11 different attack vectors including multiple statements, UNION injection, blind injection\n- Parameter binding protection with malicious payloads\n- Stacked queries and comment-based injection attempts\n\n[\u2b06\ufe0f Back to Table of Contents](#-table-of-contents)\n\n## \ud83d\ude80 **Quick Start**\n\n### **Option 1: Docker (Recommended)**\n\nPull and run instantly:\n```bash\ndocker pull writenotenow/sqlite-mcp-server:latest\n```\n\nRun with volume mount:\n```bash\ndocker run -i --rm \\\n -v $(pwd):/workspace \\\n writenotenow/sqlite-mcp-server:latest \\\n --db-path /workspace/database.db\n```\n\n#### \ud83d\udee1\ufe0f **Supply Chain Security**\nFor enhanced security and reproducible builds, use SHA-pinned images:\n\nFind available SHA tags at: https://hub.docker.com/r/writenotenow/sqlite-mcp-server/tags\nLook for tags starting with \"master-\" or \"sha256-\" for cryptographically verified builds\n\nOption 1: Human-readable timestamped builds (recommended)\n```bash\ndocker pull writenotenow/sqlite-mcp-server:master-YYYYMMDD-HHMMSS-<commit>\n```\n\nOption 2: Multi-arch manifest digest (maximum security)\n```bash\ndocker pull writenotenow/sqlite-mcp-server@sha256:<manifest-digest>\n```\n\nExample: Run with cryptographically verified image\n```bash\ndocker run -i --rm \\\n -v $(pwd):/workspace \\\n writenotenow/sqlite-mcp-server:master-YYYYMMDD-HHMMSS-<commit> \\\n --db-path /workspace/database.db\n```\n\n**How to Find SHA Tags:**\n1. Visit [Docker Hub Tags](https://hub.docker.com/r/writenotenow/sqlite-mcp-server/tags)\n2. **For convenience**: Use `master-YYYYMMDD-HHMMSS-<commit>` tags (human-readable, multi-arch)\n3. **For maximum security**: Use `sha256-<hash>` tags (manifest digests, immutable)\n\n**Understanding SHA Tags:**\n- \ud83c\udff7\ufe0f **`master-YYYYMMDD-HHMMSS-<commit>`** - Human-readable, timestamped, multi-arch safe\n- \ud83d\udd12 **`sha256-<manifest-digest>`** - Multi-arch manifest digest (works on all architectures)\n- \u26a0\ufe0f **Architecture-specific digests** - Only for debugging specific architectures\n\n**Security Features:**\n- \u2705 **Build Provenance** - Cryptographic proof of build process\n- \u2705 **SBOM Available** - Complete software bill of materials \n- \u2705 **Supply Chain Attestations** - Verifiable build integrity\n- \u2705 **Reproducible Builds** - Exact image verification for compliance\n\n### **Option 2: Python Installation**\n\nInstall from PyPI:\n```bash\npip install sqlite-mcp-server-enhanced\n```\n\nOr install from source:\n```bash\ngit clone https://github.com/neverinfamous/sqlite-mcp-server.git\n```\n\nNavigate to directory:\n```bash\ncd sqlite-mcp-server\n```\n\nInstall requirements:\n```bash\npip install -r requirements.txt\n```\n\nRun the server:\n```bash\npython start_sqlite_mcp.py --db-path ./database.db\n```\n\n### **Option 3: Test in 30 Seconds**\n\nClone repository:\n```bash\ngit clone https://github.com/neverinfamous/sqlite-mcp-server.git\n```\n\nNavigate to directory:\n```bash\ncd sqlite-mcp-server\n```\n\nRun quick test:\n```bash\npython test_runner.py --quick\n```\n\n### **\ud83c\udd95 NEW in v2.6.0: Complete JSON Operations Suite**\n\n**5 Major Improvements in this release:**\n- \ud83c\udfaf **JSON Helper Tools** - 6 specialized tools for simplified JSON operations with path validation and merging\n- \ud83e\udd16 **JSON Auto-Normalization** - Automatically fixes Python-style JSON with configurable strict mode \n- \ud83d\udee1\ufe0f **Parameter Binding Interface** - Enhanced MCP tools with SQL injection prevention\n- \ud83d\udce6 **Automatic Parameter Serialization** - Direct object/array parameters, no manual JSON.stringify()\n- \ud83e\udde0 **Enhanced JSON Error Diagnostics** - Intelligent error categorization with contextual guidance\n\n### **\ud83d\udd25 Core Capabilities**\n- \ud83d\udcca **Statistical Analysis** - Descriptive stats, percentiles, time series analysis\n- \ud83d\udd0d **Advanced Text Processing** - Regex, fuzzy matching, phonetic search, similarity\n- \ud83e\udde0 **Vector/Semantic Search** - AI-native embeddings, cosine similarity, hybrid search\n- \ud83d\uddfa\ufe0f **SpatiaLite Geospatial** - Enterprise GIS with spatial indexing and operations\n- \ud83d\udd10 **Transaction Safety** - Auto-wrapped transactions with rollback protection\n- \ud83c\udf9b\ufe0f **73 Specialized Tools** - Complete database administration and analytics suite\n\n### **\ud83c\udfe2 Enterprise Features**\n- \ud83d\udcc8 **Business Intelligence** - Integrated insights memo and workflow automation\n- \ud83d\udd04 **Backup/Restore** - Enterprise-grade operations with integrity verification\n- \ud83c\udfaf **Full-Text Search (FTS5)** - Advanced search with BM25 ranking and snippets\n- \ud83c\udfd7\ufe0f **Virtual Tables** - Smart CSV/JSON import with automatic type inference\n- \u2699\ufe0f **Advanced PRAGMA** - Complete SQLite configuration and optimization\n\n[\u2b06\ufe0f Back to Table of Contents](#-table-of-contents)\n\n## \ud83d\udcda **MCP Client Configuration**\n\n### **Claude Desktop**\n```json\n{\n \"mcpServers\": {\n \"sqlite-mcp-server\": {\n \"command\": \"python\",\n \"args\": [\"/path/to/sqlite-mcp-server/start_sqlite_mcp.py\", \"--db-path\", \"/path/to/database.db\"]\n }\n }\n}\n```\n\n### **Docker with Claude Desktop**\n```json\n{\n \"mcpServers\": {\n \"sqlite-mcp-server\": {\n \"command\": \"docker\",\n \"args\": [\"run\", \"-i\", \"--rm\", \"-v\", \"/path/to/project:/workspace\", \"writenotenow/sqlite-mcp-server:latest\", \"--db-path\", \"/workspace/database.db\"]\n }\n }\n}\n```\n\n[\u2b06\ufe0f Back to Table of Contents](#-table-of-contents)\n\n## \ud83c\udfa8 **Usage Examples**\n\n### **Data Analysis Workflow**\n\n1. Quick validation:\n```bash\npython test_runner.py --quick\n```\n\n2. Start with your data:\n```bash\npython start_sqlite_mcp.py --db-path ./sales_data.db\n```\n\n3. Use with Claude/Cursor for:\n - Statistical analysis of your datasets\n - Text processing and pattern extraction \n - Vector similarity search\n - Geospatial analysis and mapping\n - Business intelligence insights\n\n### **Docker Development**\n\nDevelopment with live reload:\n```bash\ndocker run -i --rm \\\n -v $(pwd):/workspace \\\n -e SQLITE_DEBUG=true \\\n writenotenow/sqlite-mcp-server:latest \\\n --db-path /workspace/dev.db\n```\n\n### **\ud83c\udfaf JSON Helper Tools - Simplified JSON Operations**\n\n**NEW in v2.6.0:** Six powerful JSON helper tools that make complex JSON operations simple:\n\n```javascript\n// \u2705 Insert JSON with auto-normalization\njson_insert({\n \"table\": \"products\",\n \"column\": \"metadata\", \n \"data\": {'name': 'Product', 'active': True, 'price': None}\n})\n\n// \u2705 Update JSON by path\njson_update({\n \"table\": \"products\",\n \"column\": \"metadata\",\n \"path\": \"$.price\",\n \"value\": 29.99,\n \"where_clause\": \"id = 1\"\n})\n\n// \u2705 Query JSON with complex filtering\njson_query({\n \"table\": \"products\",\n \"column\": \"metadata\",\n \"filter_paths\": {\"$.category\": \"electronics\"},\n \"select_paths\": [\"$.name\", \"$.price\"]\n})\n```\n\n**JSON Helper Tools:**\n- \ud83c\udfaf **json_insert** - Insert JSON data with auto-normalization\n- \ud83d\udd04 **json_update** - Update JSON by path with creation support \n- \ud83d\udd0d **json_select** - Extract JSON data with multiple output formats\n- \ud83d\udd0e **json_query** - Complex JSON filtering and aggregation\n- \u2705 **json_validate_path** - Validate JSON paths with security checks\n- \ud83d\udd17 **json_merge** - Merge JSON objects with conflict resolution\n\n**Auto-normalization still works:**\n- \ud83d\udd27 Single quotes \u2192 Double quotes \n- \ud83d\udd27 Python `True`/`False` \u2192 JSON `true`/`false`\n- \ud83d\udd27 Python `None` \u2192 JSON `null`\n- \ud83d\udd27 Trailing commas removed\n- \ud83d\udee1\ufe0f Security validation prevents malicious input\n\n### **\ud83e\udde0 Enhanced JSON Error Diagnostics**\n\n**Enhanced in v2.6.0:** When JSON validation fails, get intelligent, contextual error messages with specific guidance:\n\n```javascript\n// \u274c Invalid JSON input:\nvalidate_json('{key_without_quotes: \"value\"}')\n\n// \u2705 Enhanced error response:\n{\n \"valid\": false,\n \"error\": \"Expecting property name enclosed in double quotes: line 1 column 2 (char 1)\",\n \"enhanced_message\": \"JSON validation failed (structural_syntax): Expecting property name...\",\n \"error_context\": {\n \"error_type\": \"structural_syntax\",\n \"security_concern\": false,\n \"suggestions\": [\n \"Ensure all object keys are properly quoted strings\",\n \"Check for missing colons (:) between keys and values\",\n \"Verify proper key-value pair structure: \\\"key\\\": \\\"value\\\"\"\n ]\n }\n}\n```\n\n**Enhanced Error Categories:**\n- \ud83d\udd27 **Structural Issues** - Missing quotes, colons, brackets with specific fix suggestions\n- \ud83d\udee1\ufe0f **Security Warnings** - Detects potential SQL injection patterns in JSON strings \n- \ud83d\udcdd **Encoding Problems** - Character encoding and escape sequence guidance\n- \ud83c\udfaf **Context-Aware Tips** - Line/column position with targeted recommendations\n\n### **\ud83d\udee1\ufe0f Enhanced Parameter Binding + Auto-Serialization**\n\n**NEW in v2.6.0:** Built-in SQL injection protection with automatic JSON serialization:\n\n```javascript\n// \u2705 SECURE: Parameter binding prevents injection\nread_query({\n \"query\": \"SELECT * FROM users WHERE name = ? AND age > ?\",\n \"params\": [\"John\", 25]\n})\n\n// \u2705 NEW: Direct object/array parameters (auto-serialized)\nwrite_query({\n \"query\": \"INSERT INTO products (metadata, tags) VALUES (?, ?)\",\n \"params\": [\n {\"name\": \"Product\", \"price\": 29.99, \"active\": true}, // Auto-serialized to JSON\n [\"electronics\", \"featured\", \"new\"] // Auto-serialized to JSON\n ]\n})\n\n// \u2705 SIMPLIFIED: No more manual JSON.stringify()\n// Before v2.6.0:\nwrite_query({\n \"query\": \"INSERT INTO table (data) VALUES (?)\",\n \"params\": [JSON.stringify({\"key\": \"value\"})] // Manual serialization required\n})\n\n// After v2.6.0:\nwrite_query({\n \"query\": \"INSERT INTO table (data) VALUES (?)\",\n \"params\": [{\"key\": \"value\"}] // Automatic serialization!\n})\n```\n\n**v2.6.0 Benefits:**\n- \ud83d\udee1\ufe0f **SQL Injection Prevention** - Parameter binding treats malicious input as literal data\n- \ud83d\udce6 **Auto-Serialization** - Objects and arrays automatically converted to JSON strings \n- \ud83d\udd04 **Backward Compatible** - Existing queries continue to work unchanged\n- \u26a1 **Better Performance** - Query plan caching and parameter optimization\n- \ud83d\udcdd **Cleaner API** - No manual JSON.stringify() or parameter preparation needed\n\n[\u2b06\ufe0f Back to Table of Contents](#-table-of-contents)\n\n## \ud83d\udcca **Tool Categories**\n\nThe SQLite MCP Server provides **73 specialized tools** across **14 categories**:\n\n> \ud83d\udca1 **Want the complete tool list?** See the [**detailed tool reference**](./docs/sqlite-mcp-server.wiki/Home.md) with descriptions for all 73 tools, 7 resources, and 7 prompts.\n\n| Category | Tool Count | Description |\n|----------|------------|-------------|\n| **[Core Database](./docs/sqlite-mcp-server.wiki/Core-Database-Tools.md)** | 15 | CRUD operations, schema management, transactions |\n| **[JSON Helper Tools](./docs/sqlite-mcp-server.wiki/JSON-Helper-Tools.md)** | 6 | Simplified JSON operations, path validation, merging |\n| **[Text Processing](./docs/sqlite-mcp-server.wiki/Advanced-Text-Processing.md)** | 9 | Regex, fuzzy matching, phonetic search, similarity |\n| **[Statistical Analysis](./docs/sqlite-mcp-server.wiki/Statistical-Analysis.md)** | 8 | Descriptive stats, percentiles, time series |\n| **[Virtual Tables](./docs/sqlite-mcp-server.wiki/Virtual-Tables.md)** | 8 | CSV, R-Tree, series generation |\n| **[Semantic Search](./docs/sqlite-mcp-server.wiki/Semantic-Vector-Search.md)** | 8 | Embeddings, similarity, hybrid search |\n| **[Geospatial](./docs/sqlite-mcp-server.wiki/SpatiaLite-Geospatial.md)** | 7 | Spatial indexing, geometric operations |\n| **[PRAGMA Operations](./docs/sqlite-mcp-server.wiki/PRAGMA-Operations.md)** | 5 | Configuration, optimization, introspection |\n| **[Full-Text Search](./docs/sqlite-mcp-server.wiki/Full-Text-Search.md)** | 3 | FTS5 creation, indexing, BM25 ranking |\n| **[Vector Optimization](./docs/sqlite-mcp-server.wiki/Vector-Index-Optimization.md)** | 2 | ANN search, clustering, performance |\n| **[Data Analysis](./docs/sqlite-mcp-server.wiki/Enhanced-Virtual-Tables.md)** | 2 | Smart CSV/JSON import with type inference |\n| **[Resources](./docs/sqlite-mcp-server.wiki/MCP-Resources-and-Prompts.md)** | 7 | Database meta-awareness, performance insights |\n| **[Prompts](./docs/sqlite-mcp-server.wiki/MCP-Resources-and-Prompts.md)** | 7 | Guided workflows, optimization recipes |\n\n> \ud83d\udca1 **Cursor Users:** You can enable only the categories you need in your MCP client settings to reduce tool noise and improve stability. Each number above shows the **count of tools** in that category.\n\n[\u2b06\ufe0f Back to Table of Contents](#-table-of-contents)\n\n## \ud83c\udfc6 **Why Choose SQLite MCP Server?**\n\n\u2705 **AI-Friendly** - JSON auto-normalization and intelligent error messages reduce debugging time \n\u2705 **Just Works** - Built-in security and parameter binding with zero configuration \n\u2705 **Smart Diagnostics** - Enhanced error context provides actionable guidance when issues occur \n\u2705 **Type Safe** - Passes strict Pyright type checking in Cursor for maximum code quality \n\u2705 **Instantly Testable** - Validate all 73 tools in 30 seconds \n\u2705 **Production Ready** - Enterprise-grade testing and validation \n\u2705 **Comprehensive** - Everything you need in one package \n\u2705 **Docker Ready** - Containerized for easy deployment \n\u2705 **Zero Breaking Changes** - All existing code continues to work\n\n[\u2b06\ufe0f Back to Table of Contents](#-table-of-contents) \n\n## \ud83d\udd0d **AI-Powered Wiki Search**\n\n**[\u2192 Search the Documentation with AI](https://search.adamic.tech)**\n\nCan't find what you're looking for? Use our **AI-powered search interface** to search both SQLite and PostgreSQL MCP Server documentation:\n\n- \ud83e\udd16 **Natural Language Queries** - Ask questions in plain English and get AI-generated answers\n- \u26a1 **Instant Results** - AI-enhanced answers with source attribution from both wikis\n- \ud83d\udcda **Comprehensive Coverage** - Searches all 73 SQLite tools + 63 PostgreSQL tools (136 total)\n- \ud83c\udfaf **Smart Context** - Understands technical questions and provides relevant examples\n- \ud83d\udd04 **Dual Search Modes** - AI-Enhanced for synthesized answers, or Raw Docs for direct chunks\n\n**Example queries:**\n- \"How do I prevent SQL injection attacks?\"\n- \"What statistical analysis tools are available?\"\n- \"How do I set up vector search with embeddings?\"\n- \"How do I use JSON helper tools for data normalization?\"\n- \"What SpatiaLite geospatial operations are available?\"\n\n**[\u2192 Try AI Search Now](https://search.adamic.tech)**\n\nThe search interface uses Cloudflare's AI Search technology to provide intelligent, context-aware answers from comprehensive wiki documentation for both SQLite and PostgreSQL MCP Servers.\n\n[\u2b06\ufe0f Back to Table of Contents](#-table-of-contents)\n\n## \ud83d\udcda **Complete Documentation**\n\n**[\u2192 Wiki: Comprehensive Documentation & Examples](https://github.com/neverinfamous/sqlite-mcp-server/wiki)**\n\nComprehensive documentation including:\n- **Detailed tool reference** - All 73 tools with examples\n- **Advanced configuration** - Performance tuning and optimization\n- **Integration guides** - MCP clients, Docker, CI/CD\n- **Feature deep-dives** - Text processing, vector search, geospatial\n- **Best practices** - Query patterns, troubleshooting, workflows\n- **API reference** - Complete tool schemas and parameters\n\n**[\u2192 GitHub Gists: Practical Examples & Use Cases](https://gist.github.com/neverinfamous/0c8ed77ddaff0edbe31df4f4e18c33ce)**\n\n9 curated gists with real-world examples:\n- **JSON Helper Tools** - Simplified JSON operations with auto-normalization\n- **Vector/Semantic Search** - AI-native embeddings and similarity search\n- **SpatiaLite GIS** - Geospatial operations and spatial indexing\n- **Performance Optimization** - Query tuning and index recommendations\n- **Security Best Practices** - SQL injection prevention and safe queries\n- **Real-World Use Cases** - Business intelligence and data analysis workflows\n- **Database Migration** - Schema evolution and data transformation\n- **Docker Deployment** - Production containerization strategies\n- **Complete Feature Showcase** - All 73 tools with comprehensive examples\n\n[\u2b06\ufe0f Back to Table of Contents](#-table-of-contents)\n\n## \ud83d\udd17 **Additional Resources**\n\n- **[Testing Guide](./tests/README.md)** - Comprehensive testing documentation\n- **[Contributing](./CONTRIBUTING.md)** - How to contribute to the project\n- **[Security Policy](./SECURITY.md)** - Security guidelines and reporting\n- **[Code of Conduct](./CODE_OF_CONDUCT.md)** - Community guidelines\n- **[Docker Hub](https://hub.docker.com/r/writenotenow/sqlite-mcp-server)** - Container images\n- **[GitHub Releases](https://github.com/neverinfamous/sqlite-mcp-server/releases)** - Version history\n- **[Adamic Support Blog](https://adamic.tech/)** - Project announcements and releases\n\n[\u2b06\ufe0f Back to Table of Contents](#-table-of-contents)\n\n## \ud83d\ude80 **Quick Links**\n\n| Action | Command |\n|--------|---------|\n| **AI-Powered Search** | [search.adamic.tech](https://search.adamic.tech) |\n| **Test Everything** | `python test_runner.py --standard` |\n| **Docker Quick Start** | `docker run -i --rm -v $(pwd):/workspace writenotenow/sqlite-mcp-server:latest` |\n| **Install from PyPI** | `pip install sqlite-mcp-server-enhanced` |\n| **View Full Docs** | [docs/sqlite-mcp-server.wiki](./docs/sqlite-mcp-server.wiki/Home.md) |\n| **Report Issues** | [GitHub Issues](https://github.com/neverinfamous/sqlite-mcp-server/issues) |\n\n[\u2b06\ufe0f Back to Table of Contents](#-table-of-contents)\n\n## \ud83d\udcc8 **Project Stats**\n\n- **73 Tools** across 14 categories (all tested and verified \u2705)\n- **2,000+ lines** of comprehensive documentation \n- **Multi-platform** support (Windows, Linux, macOS)\n- **Docker images** for amd64 and arm64\n- **Strict type checking** with Pyright for code quality\n- **Enterprise testing** with comprehensive validation\n- **Active development** with regular updates\n\n[\u2b06\ufe0f Back to Table of Contents](#-table-of-contents)",
"bugtrack_url": null,
"license": "MIT",
"summary": "A SQLite MCP server with JSONB support, database administration tools, and advanced database operations",
"version": "2.6.3",
"project_urls": {
"Documentation": "https://github.com/neverinfamous/sqlite-mcp-server#readme",
"Homepage": "https://github.com/neverinfamous/sqlite-mcp-server",
"Issues": "https://github.com/neverinfamous/sqlite-mcp-server/issues",
"Repository": "https://github.com/neverinfamous/sqlite-mcp-server"
},
"split_keywords": [
"database",
" jsonb",
" mcp",
" model-context-protocol",
" sqlite"
],
"urls": [
{
"comment_text": null,
"digests": {
"blake2b_256": "8b21b7738b9284c23e4ac1d8196e447f013cbbb958cdf93802d396d8e6b27842",
"md5": "651f7070ab801b71873a935d71ab9841",
"sha256": "0f98265aa0db1c361a443fafb883d0139a0f9e04d9901a56a1f7b4b0f0601fe6"
},
"downloads": -1,
"filename": "sqlite_mcp_server_enhanced-2.6.3-py3-none-any.whl",
"has_sig": false,
"md5_digest": "651f7070ab801b71873a935d71ab9841",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": ">=3.10",
"size": 85678,
"upload_time": "2025-10-09T04:43:35",
"upload_time_iso_8601": "2025-10-09T04:43:35.350988Z",
"url": "https://files.pythonhosted.org/packages/8b/21/b7738b9284c23e4ac1d8196e447f013cbbb958cdf93802d396d8e6b27842/sqlite_mcp_server_enhanced-2.6.3-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": null,
"digests": {
"blake2b_256": "52bf61efef690b2b4cf36ac17d2c4bbaed424f3a2f08a9f6bed464894eecf210",
"md5": "301dc54590475bf6577317b49106b102",
"sha256": "d4314da917f29cd26a7bc7d68297bb0289ec9d5101003422f28ad5e72097e1c2"
},
"downloads": -1,
"filename": "sqlite_mcp_server_enhanced-2.6.3.tar.gz",
"has_sig": false,
"md5_digest": "301dc54590475bf6577317b49106b102",
"packagetype": "sdist",
"python_version": "source",
"requires_python": ">=3.10",
"size": 205501,
"upload_time": "2025-10-09T04:43:36",
"upload_time_iso_8601": "2025-10-09T04:43:36.641456Z",
"url": "https://files.pythonhosted.org/packages/52/bf/61efef690b2b4cf36ac17d2c4bbaed424f3a2f08a9f6bed464894eecf210/sqlite_mcp_server_enhanced-2.6.3.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2025-10-09 04:43:36",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "neverinfamous",
"github_project": "sqlite-mcp-server#readme",
"travis_ci": false,
"coveralls": false,
"github_actions": true,
"requirements": [
{
"name": "mcp",
"specs": [
[
">=",
"1.14.0"
]
]
},
{
"name": "h11",
"specs": [
[
">=",
"0.16.0"
]
]
},
{
"name": "starlette",
"specs": [
[
">=",
"0.47.2"
]
]
}
],
"lcname": "sqlite-mcp-server-enhanced"
}
JSON
