{"id":"d8519095-7fff-47a7-8ca7-124e07fc75d3","slug":"sqlite-mcp-server-enhanced-filterable","kind":"mcp","name":"sqlite-mcp-server-enhanced-filterable","summary":"SQLite MCP server with AI-native features, Vector Search, foreign key enforcement, Enhanced Virtual Tables, Advanced PRAGMA operations, Intelligent MCP Resources, FTS5 search, JSONB support, enterpris","owner":"Insighttful","repoUrl":"https://github.com/Insighttful/sqlite-mcp-server-enhanced-filterable","license":"MIT","licenseTier":"permissive","trust":"community","stars":2,"match":null,"fewStars":true,"format":"mcp","createdAt":"2025-12-06T00:12:39.000Z","addedAt":"2026-10-21T16:26:01.491Z","logoUrl":"https://avatars.githubusercontent.com/u/116014557?u=cccf19be296b8e62eceed62e32c2caba9d06ad39&v=4","linkOnly":false,"collection":null,"skillPath":null,"categories":["databases","search","cloud-infra"],"tags":[],"runtime":"python","local":true,"cloudCapable":false,"cloudCapability":"unknown","cloudReadyOnPlatform":false,"needsApiKey":false,"reviewed":false,"syncedAt":"2026-10-26T21:49:41.423Z","sample":false,"url":"https://conduits.dev/tools/sqlite-mcp-server-enhanced-filterable","language":"Python","transports":["stdio"],"install":{"pypi":"sqlite-mcp-server-enhanced"},"requirements":{"env":[],"upstreamMayCharge":false},"tools":null,"readme":"# SQLite MCP Server\r\n\r\nLast Updated November 24, 2025 - Production/Stable v2.6.3\r\n\r\n*Enterprise-grade SQLite with AI-native JSON operations & intelligent workflow automation – v2.6.3*\r\n\r\n[![GitHub](https://img.shields.io/badge/GitHub-neverinfamous/sqlite--mcp--server-blue?logo=github)](https://github.com/neverinfamous/sqlite-mcp-server)\r\n[![Docker Pulls](https://img.shields.io/docker/pulls/writenotenow/sqlite-mcp-server)](https://hub.docker.com/r/writenotenow/sqlite-mcp-server)\r\n[![License: MIT](https://img.shields.io/badge/License-MIT-blue.svg)](https://opensource.org/licenses/MIT)\r\n![Version](https://img.shields.io/badge/version-v2.6.3-green)\r\n![Status](https://img.shields.io/badge/status-Production%2FStable-brightgreen)\r\n[![MCP Registry](https://img.shields.io/badge/MCP_Registry-Published-green)](https://registry.modelcontextprotocol.io/v0/servers?search=io.github.neverinfamous/sqlite-mcp-server)\r\n[![PyPI](https://img.shields.io/pypi/v/sqlite-mcp-server-enhanced)](https://pypi.org/project/sqlite-mcp-server-enhanced/)\r\n[![Security](https://img.shields.io/badge/Security-Enhanced-green.svg)](SECURITY.md)\r\n[![CodeQL](https://img.shields.io/badge/CodeQL-Passing-brightgreen.svg)](https://github.com/neverinfamous/sqlite-mcp-server/security/code-scanning)\r\n[![Type Safety](https://img.shields.io/badge/Pyright-Strict-blue.svg)](https://github.com/neverinfamous/sqlite-mcp-server)\r\n\r\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.\r\n\r\n<!-- mcp-name: io.github.neverinfamous/sqlite-mcp-server -->\r\n\r\n---\r\n\r\n## 📋 Table of Contents\r\n\r\n### Quick Start\r\n- [✅ Quick Test - Verify Everything Works](#-quick-test---verify-everything-works)\r\n- [🚀 Quick Start](#-quick-start)\r\n- [🔥 Core Capabilities](#-core-capabilities)\r\n- [🏢 Enterprise Features](#-enterprise-features)\r\n\r\n### Configuration & Usage\r\n- [📚 MCP Client Configuration](#-mcp-client-configuration)\r\n- [🎨 Usage Examples](#-usage-examples)\r\n- [📊 Tool Categories](#-tool-categories)\r\n\r\n### Resources & Information\r\n- [🏆 Why Choose SQLite MCP Server?](#-why-choose-sqlite-mcp-server)\r\n- [🔍 AI-Powered Wiki Search](#-ai-powered-wiki-search)\r\n- [📚 Complete Documentation](#-complete-documentation)\r\n- [🔗 Additional Resources](#-additional-resources)\r\n- [🚀 Quick Links](#-quick-links)\r\n- [📈 Project Stats](#-project-stats)\r\n\r\n---\r\n\r\n## ✅ **Quick Test - Verify Everything Works**\r\n\r\n**Test all 73 tools in 30 seconds!**\r\n\r\nQuick smoke test:\r\n```bash\r\npython test_runner.py --quick\r\n```\r\n\r\nStandard comprehensive test (recommended):\r\n```bash\r\npython test_runner.py --standard\r\n```\r\n\r\nFull test suite with edge cases:\r\n```bash\r\npython test_runner.py --full\r\n```\r\n\r\n**Expected output:**\r\n```\r\n🚀 SQLite MCP Server Comprehensive Test Suite v2.6.3\r\n================================================================\r\n\r\n🔍 Environment Detection:\r\n  ✅ SQLite 3.50.4 (JSONB supported)\r\n  ✅ Python 3.13.x  \r\n  ✅ MCP 1.14.0\r\n  ✅ Pyright strict type checking: PASS\r\n\r\n📊 Testing 73 Tools across 14 categories...\r\n\r\n✅ Core Database Operations (8/8 passed)\r\n✅ JSON Helper Tools (6/6 passed)  \r\n✅ JSON Operations (12/12 passed)  \r\n✅ Text Processing (8/8 passed)\r\n🎉 SUCCESS: All 73 tools tested successfully!\r\n```\r\n\r\n### 🛡️ **Security Testing**\r\n\r\n**NEW: Comprehensive SQL injection protection testing**\r\n\r\nTest SQL injection protection (from tests directory):\r\n```bash\r\ncd tests && python test_sql_injection.py\r\n```\r\n\r\nExpected result: 🛡️ Overall security posture: STRONG\r\n\r\n**What it tests:**\r\n- Protection against the SQL injection vulnerability found in original Anthropic SQLite MCP server\r\n- 11 different attack vectors including multiple statements, UNION injection, blind injection\r\n- Parameter binding protection with malicious payloads\r\n- Stacked queries and comment-based injection attempts\r\n\r\n[⬆️ Back to Table of Contents](#-table-of-contents)\r\n\r\n## 🚀 **Quick Start**\r\n\r\n### **Option 1: Docker (Recommended)**\r\n\r\nPull and run instantly:\r\n```bash\r\ndocker pull writenotenow/sqlite-mcp-server:latest\r\n```\r\n\r\nRun with volume mount:\r\n```bash\r\ndocker run -i --rm \\\r\n  -v $(pwd):/workspace \\\r\n  writenotenow/sqlite-mcp-server:latest \\\r\n  --db-path /workspace/database.db\r\n```\r\n\r\n#### 🛡️ **Supply Chain Security**\r\nFor enhanced security and reproducible builds, use SHA-pinned images:\r\n\r\nFind available SHA tags at: https://hub.docker.com/r/writenotenow/sqlite-mcp-server/tags\r\nLook for tags starting with \"master-\" or \"sha256-\" for cryptographically verified builds\r\n\r\nOption 1: Human-readable timestamped builds (recommended)\r\n```bash\r\ndocker pull writenotenow/sqlite-mcp-server:master-YYYYMMDD-HHMMSS-<commit>\r\n```\r\n\r\nOption 2: Multi-arch manifest digest (maximum security)\r\n```bash\r\ndocker pull writenotenow/sqlite-mcp-server@sha256:<manifest-digest>\r\n```\r\n\r\nExample: Run with cryptographically verified image\r\n```bash\r\ndocker run -i --rm \\\r\n  -v $(pwd):/workspace \\\r\n  writenotenow/sqlite-mcp-server:master-YYYYMMDD-HHMMSS-<commit> \\\r\n  --db-path /workspace/database.db\r\n```\r\n\r\n**How to Find SHA Tags:**\r\n1. Visit [Docker Hub Tags](https://hub.docker.com/r/writenotenow/sqlite-mcp-server/tags)\r\n2. **For convenience**: Use `master-YYYYMMDD-HHMMSS-<commit>` tags (human-readable, multi-arch)\r\n3. **For maximum security**: Use `sha256-<hash>` tags (manifest digests, immutable)\r\n\r\n**Understanding SHA Tags:**\r\n- 🏷️ **`master-YYYYMMDD-HHMMSS-<commit>`** - Human-readable, timestamped, multi-arch safe\r\n- 🔒 **`sha256-<manifest-digest>`** - Multi-arch manifest digest (works on all architectures)\r\n- ⚠️ **Architecture-specific digests** - Only for debugging specific architectures\r\n\r\n**Security Features:**\r\n- ✅ **Build Provenance** - Cryptographic proof of build process\r\n- ✅ **SBOM Available** - Complete software bill of materials  \r\n- ✅ **Supply Chain Attestations** - Verifiable build integrity\r\n- ✅ **Reproducible Builds** - Exact image verification for compliance\r\n\r\n### **Option 2: Python Installation**\r\n\r\nInstall from PyPI:\r\n```bash\r\npip install sqlite-mcp-server-enhanced\r\n```\r\n\r\nOr install from source:\r\n```bash\r\ngit clone https://github.com/neverinfamous/sqlite-mcp-server.git\r\n```\r\n\r\nNavigate to directory:\r\n```bash\r\ncd sqlite-mcp-server\r\n```\r\n\r\nInstall requirements:\r\n```bash\r\npip install -r requirements.txt\r\n```\r\n\r\nRun the server:\r\n```bash\r\npython start_sqlite_mcp.py --db-path ./database.db\r\n```\r\n\r\n### **Option 3: Test in 30 Seconds**\r\n\r\nClone repository:\r\n```bash\r\ngit clone https://github.com/neverinfamous/sqlite-mcp-server.git\r\n```\r\n\r\nNavigate to directory:\r\n```bash\r\ncd sqlite-mcp-server\r\n```\r\n\r\nRun quick test:\r\n```bash\r\npython test_runner.py --quick\r\n```\r\n\r\n### **🆕 NEW in v2.6.0: Complete JSON Operations Suite**\r\n\r\n**5 Major Improvements in this release:**\r\n- 🎯 **JSON Helper Tools** - 6 specialized tools for simplified JSON operations with path validation and merging\r\n- 🤖 **JSON Auto-Normalization** - Automatically fixes Python-style JSON with configurable strict mode  \r\n- 🛡️ **Parameter Binding Interface** - Enhanced MCP tools with SQL injection prevention\r\n- 📦 **Automatic Parameter Serialization** - Direct object/array parameters, no manual JSON.stringify()\r\n- 🧠 **Enhanced JSON Error Diagnostics** - Intelligent error categorization with contextual guidance\r\n\r\n---\r\n\r\n## ⚡ **Install to Cursor IDE**\r\n\r\n### **One-Click Installation**\r\n\r\nClick the button below to install directly into Cursor:\r\n\r\n[![Install to Cursor](https://img.shields.io/badge/Install%20to%20Cursor-Click%20Here-blue?style=for-the-badge)](cursor://anysphere.cursor-deeplink/mcp/install?name=SQLite%20MCP%20Server&config=eyJzcWxpdGUtbWNwIjp7ImFyZ3MiOlsicnVuIiwiLWkiLCItLXJtIiwiLXYiLCIkKHB3ZCk6L3dvcmtzcGFjZSIsIndyaXRlbm90ZW5vdy9zcWxpdGUtbWNwLXNlcnZlcjpsYXRlc3QiLCItLWRiLXBhdGgiLCIvd29ya3NwYWNlL3NxbGl0ZV9tY3AuZGIiXSwiY29tbWFuZCI6ImRvY2tlciJ9fQ==)\r\n\r\nOr copy this deep link:\r\n```\r\ncursor://anysphere.cursor-deeplink/mcp/install?name=SQLite%20MCP%20Server&config=eyJzcWxpdGUtbWNwIjp7ImFyZ3MiOlsicnVuIiwiLWkiLCItLXJtIiwiLXYiLCIkKHB3ZCk6L3dvcmtzcGFjZSIsIndyaXRlbm90ZW5vdy9zcWxpdGUtbWNwLXNlcnZlcjpsYXRlc3QiLCItLWRiLXBhdGgiLCIvd29ya3NwYWNlL3NxbGl0ZV9tY3AuZGIiXSwiY29tbWFuZCI6ImRvY2tlciJ9fQ==\r\n```\r\n\r\n### **Prerequisites**\r\n- ✅ Docker installed and running\r\n- ✅ ~500MB disk space available\r\n\r\n### **Configuration**\r\nAfter installation, Cursor will use this Docker-based configuration:\r\n```json\r\n{\r\n  \"sqlite-mcp\": {\r\n    \"command\": \"docker\",\r\n    \"args\": [\r\n      \"run\", \"-i\", \"--rm\",\r\n      \"-v\", \"$(pwd):/workspace\",\r\n      \"writenotenow/sqlite-mcp-server:latest\",\r\n      \"--db-path\", \"/workspace/sqlite_mcp.db\"\r\n    ]\r\n  }\r\n}\r\n```\r\n\r\n**📖 [See Full Installation Guide →](https://github.com/neverinfamous/sqlite-mcp-server/wiki/Installation-and-Configuration)**\r\n\r\n---\r\n\r\n## 🔥 **Core Capabilities**\r\n- 📊 **Statistical Analysis** - Descriptive stats, percentiles, time series analysis\r\n- 🔍 **Advanced Text Processing** - Regex, fuzzy matching, phonetic search, similarity\r\n- 🧠 **Vector/Semantic Search** - AI-native embeddings, cosine similarity, hybrid search\r\n- 🗺️ **SpatiaLite Geospatial** - Enterprise GIS with spatial indexing and operations\r\n- 🔐 **Transaction Safety** - Auto-wrapped transactions with rollback protection\r\n- 🎛️ **73 Specialized Tools** - Complete database administration and analytics suite\r\n\r\n### **🏢 Enterprise Features**\r\n- 📈 **Business Intelligence** - Integrated insights memo and workflow automation\r\n- 🔄 **Backup/Restore** - Enterprise-grade operations with integrity verification\r\n- 🎯 **Full-Text Search (FTS5)** - Advanced search with BM25 ranking and snippets\r\n- 🏗️ **Virtual Tables** - Smart CSV/JSON import with automatic type inference\r\n- ⚙️ **Advanced PRAGMA** - Complete SQLite configuration and optimization\r\n\r\n[⬆️ Back to Table of Contents](#-table-of-contents)\r\n\r\n## 📚 **MCP Client Configuration**\r\n\r\n### **Claude Desktop**\r\n```json\r\n{\r\n  \"mcpServers\": {\r\n    \"sqlite-mcp-server\": {\r\n      \"command\": \"python\",\r\n      \"args\": [\"/path/to/sqlite-mcp-server/start_sqlite_mcp.py\", \"--db-path\", \"/path/to/database.db\"]\r\n    }\r\n  }\r\n}\r\n```\r\n\r\n### **Docker with Claude Desktop**\r\n```json\r\n{\r\n  \"mcpServers\": {\r\n    \"sqlite-mcp-server\": {\r\n      \"command\": \"docker\",\r\n      \"args\": [\"run\", \"-i\", \"--rm\", \"-v\", \"/path/to/project:/workspace\", \"writenotenow/sqlite-mcp-server:latest\", \"--db-path\", \"/workspace/database.db\"]\r\n    }\r\n  }\r\n}\r\n```\r\n\r\n[⬆️ Back to Table of Contents](#-table-of-contents)\r\n\r\n## 🎨 **Usage Examples**\r\n\r\n### **Data Analysis Workflow**\r\n\r\n1. Quick validation:\r\n```bash\r\npython test_runner.py --quick\r\n```\r\n\r\n2. Start with your data:\r\n```bash\r\npython start_sqlite_mcp.py --db-path ./sales_data.db\r\n```\r\n\r\n3. Use with Claude/Cursor for:\r\n   - Statistical analysis of your datasets\r\n   - Text processing and pattern extraction  \r\n   - Vector similarity search\r\n   - Geospatial analysis and mapping\r\n   - Business intelligence insights\r\n\r\n### **Docker Development**\r\n\r\nDevelopment with live reload:\r\n```bash\r\ndocker run -i --rm \\\r\n  -v $(pwd):/workspace \\\r\n  -e SQLITE_DEBUG=true \\\r\n  writenotenow/sqlite-mcp-server:latest \\\r\n  --db-path /workspace/dev.db\r\n```\r\n\r\n### **🎯 JSON Helper Tools - Simplified JSON Operations**\r\n\r\n**NEW in v2.6.0:** Six powerful JSON helper tools that make complex JSON operations simple:\r\n\r\n```javascript\r\n// ✅ Insert JSON with auto-normalization\r\njson_insert({\r\n  \"table\": \"products\",\r\n  \"column\": \"metadata\", \r\n  \"data\": {'name': 'Product', 'active': True, 'price': None}\r\n})\r\n\r\n// ✅ Update JSON by path\r\njson_update({\r\n  \"table\": \"products\",\r\n  \"column\": \"metadata\",\r\n  \"path\": \"$.price\",\r\n  \"value\": 29.99,\r\n  \"where_clause\": \"id = 1\"\r\n})\r\n\r\n// ✅ Query JSON with complex filtering\r\njson_query({\r\n  \"table\": \"products\",\r\n  \"column\": \"metadata\",\r\n  \"filter_paths\": {\"$.category\": \"electronics\"},\r\n  \"select_paths\": [\"$.name\", \"$.price\"]\r\n})\r\n```\r\n\r\n**JSON Helper Tools:**\r\n- 🎯 **json_insert** - Insert JSON data with auto-normalization\r\n- 🔄 **json_update** - Update JSON by path with creation support  \r\n- 🔍 **json_select** - Extract JSON data with multiple output formats\r\n- 🔎 **json_query** - Complex JSON filtering and aggregation\r\n- ✅ **json_validate_path** - Validate JSON paths with security checks\r\n- 🔗 **json_merge** - Merge JSON objects with conflict resolution\r\n\r\n**Auto-normalization still works:**\r\n- 🔧 Single quotes → Double quotes  \r\n- 🔧 Python `True`/`False` → JSON `true`/`false`\r\n- 🔧 Python `None` → JSON `null`\r\n- 🔧 Trailing commas removed\r\n- 🛡️ Security validation prevents malicious input\r\n\r\n### **🧠 Enhanced JSON Error Diagnostics**\r\n\r\n**Enhanced in v2.6.0:** When JSON validation fails, get intelligent, contextual error messages with specific guidance:\r\n\r\n```javascript\r\n// ❌ Invalid JSON input:\r\nvalidate_json('{key_without_quotes: \"value\"}')\r\n\r\n// ✅ Enhanced error response:\r\n{\r\n  \"valid\": false,\r\n  \"error\": \"Expecting property name enclosed in double quotes: line 1 column 2 (char 1)\",\r\n  \"enhanced_message\": \"JSON validation failed (structural_syntax): Expecting property name...\",\r\n  \"error_context\": {\r\n    \"error_type\": \"structural_syntax\",\r\n    \"security_concern\": false,\r\n    \"suggestions\": [\r\n      \"Ensure all object keys are properly quoted strings\",\r\n      \"Check for missing colons (:) between keys and values\",\r\n      \"Verify proper key-value pair structure: \\\"key\\\": \\\"value\\\"\"\r\n    ]\r\n  }\r\n}\r\n```\r\n\r\n**Enhanced Error Categories:**\r\n- 🔧 **Structural Issues** - Missing quotes, colons, brackets with specific fix suggestions\r\n- 🛡️ **Security Warnings** - Detects potential SQL injection patterns in JSON strings  \r\n- 📝 **Encoding Problems** - Character encoding and escape sequence guidance\r\n- 🎯 **Context-Aware Tips** - Line/column position with targeted recommendations\r\n\r\n### **🛡️ Enhanced Parameter Binding + Auto-Serialization**\r\n\r\n**NEW in v2.6.0:** Built-in SQL injection protection with automatic JSON serialization:\r\n\r\n```javascript\r\n// ✅ SECURE: Parameter binding prevents injection\r\nread_query({\r\n  \"query\": \"SELECT * FROM users WHERE name = ? AND age > ?\",\r\n  \"params\": [\"John\", 25]\r\n})\r\n\r\n// ✅ NEW: Direct object/array parameters (auto-serialized)\r\nwrite_query({\r\n  \"query\": \"INSERT INTO products (metadata, tags) VALUES (?, ?)\",\r\n  \"params\": [\r\n    {\"name\": \"Product\", \"price\": 29.99, \"active\": true},  // Auto-serialized to JSON\r\n    [\"electronics\", \"featured\", \"new\"]                    // Auto-serialized to JSON\r\n  ]\r\n})\r\n\r\n// ✅ SIMPLIFIED: No more manual JSON.stringify()\r\n// Before v2.6.0:\r\nwrite_query({\r\n  \"query\": \"INSERT INTO table (data) VALUES (?)\",\r\n  \"params\": [JSON.stringify({\"key\": \"value\"})]  // Manual serialization required\r\n})\r\n\r\n// After v2.6.0:\r\nwrite_query({\r\n  \"query\": \"INSERT INTO table (data) VALUES (?)\",\r\n  \"params\": [{\"key\": \"value\"}]  // Automatic serialization!\r\n})\r\n```\r\n\r\n**v2.6.0 Benefits:**\r\n- 🛡️ **SQL Injection Prevention** - Parameter binding treats malicious input as literal data\r\n- 📦 **Auto-Serialization** - Objects and arrays automatically converted to JSON strings  \r\n- 🔄 **Backward Compatible** - Existing queries continue to work unchanged\r\n- ⚡ **Better Performance** - Query plan caching and parameter optimization\r\n- 📝 **Cleaner API** - No manual JSON.stringify() or parameter preparation needed\r\n\r\n[⬆️ Back to Table of Contents](#-table-of-contents)\r\n\r\n## 📊 **Tool Categories**\r\n\r\nThe SQLite MCP Server provides **73 specialized tools** across **14 categories**:\r\n\r\n> 💡 **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.\r\n\r\n| Category | Tool Count | Description |\r\n|----------|------------|-------------|\r\n| **[Core Database](./docs/sqlite-mcp-server.wiki/Core-Database-Tools.md)** | 15 | CRUD operations, schema management, transactions |\r\n| **[JSON Helper Tools](./docs/sqlite-mcp-server.wiki/JSON-Helper-Tools.md)** | 6 | Simplified JSON operations, path validation, merging |\r\n| **[Text Processing](./docs/sqlite-mcp-server.wiki/Advanced-Text-Processing.md)** | 9 | Regex, fuzzy matching, phonetic search, similarity |\r\n| **[Statistical Analysis](./docs/sqlite-mcp-server.wiki/Statistical-Analysis.md)** | 8 | Descriptive stats, percentiles, time series |\r\n| **[Virtual Tables](./docs/sqlite-mcp-server.wiki/Virtual-Tables.md)** | 8 | CSV, R-Tree, series generation |\r\n| **[Semantic Search](./docs/sqlite-mcp-server.wiki/Semantic-Vector-Search.md)** | 8 | Embeddings, similarity, hybrid search |\r\n| **[Geospatial](./docs/sqlite-mcp-server.wiki/SpatiaLite-Geospatial.md)** | 7 | Spatial indexing, geometric operations |\r\n| **[PRAGMA Operations](./docs/sqlite-mcp-server.wiki/PRAGMA-Operations.md)** | 5 | Configuration, optimization, introspection |\r\n| **[Full-Text Search](./docs/sqlite-mcp-server.wiki/Full-Text-Search.md)** | 3 | FTS5 creation, indexing, BM25 ranking |\r\n| **[Vector Optimization](./docs/sqlite-mcp-server.wiki/Vector-Index-Optimization.md)** | 2 | ANN search, clustering, performance |\r\n| **[Data Analysis](./docs/sqlite-mcp-server.wiki/Enhanced-Virtual-Tables.md)** | 2 | Smart CSV/JSON import with type inference |\r\n| **[Resources](./docs/sqlite-mcp-server.wiki/MCP-Resources-and-Prompts.md)** | 7 | Database meta-awareness, performance insights |\r\n| **[Prompts](./docs/sqlite-mcp-server.wiki/MCP-Resources-and-Prompts.md)** | 7 | Guided workflows, optimization recipes |\r\n\r\n> 💡 **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.\r\n\r\n[⬆️ Back to Table of Contents](#-table-of-contents)\r\n\r\n## 🏆 **Why Choose SQLite MCP Server?**\r\n\r\n✅ **AI-Friendly** - JSON auto-normalization and intelligent error messages reduce debugging time  \r\n✅ **Just Works** - Built-in security and parameter binding with zero configuration  \r\n✅ **Smart Diagnostics** - Enhanced error context provides actionable guidance when issues occur  \r\n✅ **Type Safe** - Passes strict Pyright type checking in Cursor for maximum code quality  \r\n✅ **Instantly Testable** - Validate all 73 tools in 30 seconds  \r\n✅ **Production Ready** - Enterprise-grade testing and validation  \r\n✅ **Comprehensive** - Everything you need in one package  \r\n✅ **Docker Ready** - Containerized for easy deployment  \r\n✅ **Zero Breaking Changes** - All existing code continues to work\r\n\r\n[⬆️ Back to Table of Contents](#-table-of-contents)  \r\n\r\n## 🔍 **AI-Powered Wiki Search**\r\n\r\n**[→ Search the Documentation with AI](https://search.adamic.tech)**\r\n\r\nCan't find what you're looking for? Use our **AI-powered search interface** to search both SQLite and PostgreSQL MCP Server documentation:\r\n\r\n- 🤖 **Natural Language Queries** - Ask questions in plain English and get AI-generated answers\r\n- ⚡ **Instant Results** - AI-enhanced answers with source attribution from both wikis\r\n- 📚 **Comprehensive Coverage** - Searches all 73 SQLite tools + 63 PostgreSQL tools (136 total)\r\n- 🎯 **Smart Context** - Understands technical questions and provides relevant examples\r\n- 🔄 **Dual Search Modes** - AI-Enhanced for synthesized answers, or Raw Docs for direct chunks\r\n\r\n**Example queries:**\r\n- \"How do I prevent SQL injection attacks?\"\r\n- \"What statistical analysis tools are available?\"\r\n- \"How do I set up vector search with embeddings?\"\r\n- \"How do I use JSON helper tools for data normalization?\"\r\n- \"What SpatiaLite geospatial operations are available?\"\r\n\r\n**[→ Try AI Search Now](https://search.adamic.tech)**\r\n\r\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.\r\n\r\n[⬆️ Back to Table of Contents](#-table-of-contents)\r\n\r\n## 📚 **Complete Documentation**\r\n\r\n**[→ Wiki: Comprehensive Documentation & Examples](https://github.com/neverinfamous/sqlite-mcp-server/wiki)**\r\n\r\nComprehensive documentation including:\r\n- **Detailed tool reference** - All 73 tools with examples\r\n- **Advanced configuration** - Performance tuning and optimization\r\n- **Integration guides** - MCP clients, Docker, CI/CD\r\n- **Feature deep-dives** - Text processing, vector search, geospatial\r\n- **Best practices** - Query patterns, troubleshooting, workflows\r\n- **API reference** - Complete tool schemas and parameters\r\n\r\n**📰 [Read the v2.6.0 Release Article](https://adamic.tech/articles/2025-09-22-sqlite-mcp-server-v2-6-0)** - Learn about JSON operations, auto-normalization, and enhanced security\r\n\r\n**[→ GitHub Gists: Practical Examples & Use Cases](https://gist.github.com/neverinfamous/0c8ed77ddaff0edbe31df4f4e18c33ce)**\r\n\r\n9 curated gists with real-world examples:\r\n- **JSON Helper Tools** - Simplified JSON operations with auto-normalization\r\n- **Vector/Semantic Search** - AI-native embeddings and similarity search\r\n- **SpatiaLite GIS** - Geospatial operations and spatial indexing\r\n- **Performance Optimization** - Query tuning and index recommendations\r\n- **Security Best Practices** - SQL injection prevention and safe queries\r\n- **Real-World Use Cases** - Business intelligence and data analysis workflows\r\n- **Database Migration** - Schema evolution and data transformation\r\n- **Docker Deployment** - Production containerization strategies\r\n- **Complete Feature Showcase** - All 73 tools with comprehensive examples\r\n\r\n[⬆️ Back to Table of Contents](#-table-of-contents)\r\n\r\n## 🔗 **Additional Resources**\r\n\r\n- **[Testing Guide](./tests/README.md)** - Comprehensive testing documentation\r\n- **[Contributing](./CONTRIBUTING.md)** - How to contribute to the project\r\n- **[Security Policy](./SECURITY.md)** - Security guidelines and reporting\r\n- **[Code of Conduct](./CODE_OF_CONDUCT.md)** - Community guidelines\r\n- **[Docker Hub](https://hub.docker.com/r/writenotenow/sqlite-mcp-server)** - Container images\r\n- **[GitHub Releases](https://github.com/neverinfamous/sqlite-mcp-server/releases)** - Version history\r\n- **[Adamic Support Blog](https://adamic.tech/)** - Project announcements and releases\r\n\r\n[⬆️ Back to Table of Contents](#-table-of-contents)\r\n\r\n## 🚀 **Quick Links**\r\n\r\n| Action | Command |\r\n|--------|---------|\r\n| **AI-Powered Search** | [search.adamic.tech](https://search.adamic.tech) |\r\n| **Test Everything** | `python test_runner.py --standard` |\r\n| **Docker Quick Start** | `docker run -i --rm -v $(pwd):/workspace writenotenow/sqlite-mcp-server:latest` |\r\n| **Install from PyPI** | `pip install sqlite-mcp-server-enhanced` |\r\n| **View Full Docs** | [docs/sqlite-mcp-server.wiki](./docs/sqlite-mcp-server.wiki/Home.md) |\r\n| **Report Issues** | [GitHub Issues](https://github.com/neverinfamous/sqlite-mcp-server/issues) |\r\n\r\n[⬆️ Back to Table of Contents](#-table-of-contents)\r\n\r\n## 📈 **Project Stats**\r\n\r\n- **73 Tools** across 14 categories (all tested and verified ✅)\r\n- **2,000+ lines** of comprehensive documentation  \r\n- **Multi-platform** support (Windows, Linux, macOS)\r\n- **Docker images** for amd64 and arm64\r\n- **Strict type checking** with Pyright for code quality\r\n- **Enterprise testing** with comprehensive validation\r\n- **Active development** with regular updates\r\n\r\n[⬆️ Back to Table of Contents](#-table-of-contents)"}