SQLite MCP Server

SQLite MCP Server transforms 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. Built for the Model Context Protocol, it provides enterprise-grade database capabilities that work seamlessly with AI assistants like Claude and development environments like Cursor IDE.

🚀 What is SQLite MCP Server?

SQLite MCP Server is an enterprise-grade database toolkit that extends SQLite with comprehensive capabilities for modern AI-driven applications. Whether you're building data analysis workflows, implementing semantic search, processing geospatial data, or managing complex JSON structures, SQLite MCP Server provides the tools you need with zero configuration required.

• 73 Specialized Tools across 14 categories including JSON operations, vector search, text processing, and statistical analysis
• AI-Native Design with automatic JSON normalization, intelligent error messages, and parameter serialization
• Production Ready with comprehensive testing, SQL injection protection, and enterprise-grade security
• Universal Compatibility works with Claude Desktop, Cursor IDE, Windsurf, and all MCP clients
• Zero Configuration - works out of the box with sensible defaults and automatic optimization

🔥 Core Capabilities

JSON Operations Suite: Comprehensive JSON support with 6 specialized helper tools that simplify complex operations. Includes automatic normalization that fixes Python-style JSON (single quotes, True/False/None) and intelligent error diagnostics. Tools include json_insert, json_update, json_select, json_query, json_validate_path, and json_merge with conflict resolution strategies.

Vector & Semantic Search: AI-native embedding support with cosine similarity search, hybrid search capabilities, and vector index optimization. Perfect for building semantic search, recommendation systems, and similarity-based retrieval.

Advanced Text Processing: Powerful text analysis with regex operations, fuzzy matching, phonetic search (Soundex, Metaphone), and similarity scoring. Ideal for data cleaning, deduplication, and natural language processing workflows.

Statistical Analysis: Built-in statistical functions including descriptive statistics, percentile calculations, correlation analysis, and time series operations. Transform your database into a complete analytics platform.

SpatiaLite Geospatial: Enterprise GIS capabilities with spatial indexing, geometric operations, coordinate transformations, and spatial relationship analysis. Full SpatiaLite integration for professional geospatial applications.

Full-Text Search (FTS5): Advanced search with BM25 ranking, snippet generation, and phrase matching. Create powerful search experiences with SQLite's battle-tested FTS5 engine.

🆕 Latest in v2.6.4: Tool Filtering

The newest release introduces selective tool filtering through the SQLITE_MCP_TOOL_FILTER environment variable, addressing real-world challenges like Windsurf's 100-tool limit and reducing token overhead in AI conversations. Tools are organized into 10 logical groups: core, fts, vector, json, virtual, spatial, text, stats, admin, and misc. You can enable or disable entire groups or individual tools with simple syntax.

# Windsurf-compatible (~50 tools)
SQLITE_MCP_TOOL_FILTER="-vector,-stats,-spatial,-text"

# Core + JSON only
SQLITE_MCP_TOOL_FILTER="-fts,-vector,-virtual,-spatial,-text,-stats,-admin,-misc"

# Read-only mode
SQLITE_MCP_TOOL_FILTER="-write_query,-create_table"

🏢 Enterprise Features

Security & Safety: SQL injection protection through parameter binding, transaction safety with automatic rollback, enhanced security validation in JSON operations, and comprehensive security testing suite.

Performance & Optimization: Query plan caching and parameter optimization, vector index optimization with ANN search, spatial indexing for geospatial queries, and PRAGMA operations for fine-tuned control.

Data Import & Export: Smart CSV import with automatic type inference, JSON import with schema validation, virtual table support for external data, and backup and restore operations with integrity verification.

📦 Installation & Quick Start

Docker (Recommended): Pull and run instantly with Docker:

docker pull writenotenow/sqlite-mcp-server:latest

docker run -i --rm \
  -v $(pwd):/workspace \
  writenotenow/sqlite-mcp-server:latest \
  --db-path /workspace/database.db

Python Installation: Install from PyPI or GitHub:

# Install from PyPI
pip install sqlite-mcp-server-enhanced

# Or install from source
git clone https://github.com/neverinfamous/sqlite-mcp-server.git
cd sqlite-mcp-server
pip install -r requirements.txt

One-Click Cursor Installation: Install directly into Cursor IDE with a single click:

cursor://anysphere.cursor-deeplink/mcp/install?name=SQLite%20MCP%20Server&config=...

Test in 30 Seconds: Verify all 73 tools work correctly:

python test_runner.py --quick

🎯 MCP Client Configuration

Claude Desktop:

{
  "mcpServers": {
    "sqlite": {
      "command": "docker",
      "args": [
        "run", "-i", "--rm",
        "-v", "/path/to/project:/workspace",
        "writenotenow/sqlite-mcp-server:latest",
        "--db-path", "/workspace/database.db"
      ]
    }
  }
}

Cursor IDE:

{
  "mcpServers": {
    "sqlite": {
      "command": "uvx",
      "args": [
        "--from", "git+https://github.com/neverinfamous/sqlite-mcp-server.git",
        "mcp-server-sqlite", "--db-path", "./database.db"
      ]
    }
  }
}

💡 Real-World Use Cases

Data Analysis & Business Intelligence: Build comprehensive analytics pipelines with statistical analysis tools, time series operations, and automated insights generation. Perfect for business intelligence dashboards and data exploration.

Semantic Search & Recommendations: Implement AI-powered search with vector embeddings, cosine similarity, and hybrid search. Create recommendation engines, duplicate detection systems, and content discovery platforms.

Geospatial Applications: Develop location-based services with SpatiaLite integration. Perform spatial queries, calculate distances, analyze geographic relationships, and visualize map data.

Content Management & Search: Power full-text search applications with FTS5, implement fuzzy matching for typo tolerance, and use phonetic search for name matching and deduplication.

API Backend & Data Processing: Process JSON APIs, validate and normalize data structures, perform text analysis, and build robust data transformation pipelines with enterprise-grade reliability.

📊 Complete Tool Categories

🏆 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
• Type Safe - Passes strict Pyright type checking 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

📚 Hands-On Learning Resources

Master SQLite MCP Server with comprehensive hands-on guides and tutorials. Each guide includes runnable Python examples and production-ready patterns:

💡 Pro Tip: Start with the JSON Helper Tools Masterclass for comprehensive hands-on learning, then explore the specific implementation and optimization guides based on your use case. All guides include runnable Python examples and production-ready patterns.

🔍 AI-Powered Documentation Search

Can't find what you're looking for? Use our AI-powered search interface to search the complete documentation with natural language queries. The AI understands technical questions and provides relevant examples with source attribution.

📚 Resources & Documentation

• 📚 GitHub Repository - Full source code and documentation
• 📖 Wiki Documentation - Comprehensive guides and examples
• 🎛️ Tool Filtering Guide - Complete filtering documentation
• 🐳 Docker Hub - Container images for all architectures
• 🔍 AI Documentation Search - Natural language search interface
• 📦 PyPI Package - Python package installation

👏 Community & Contributing

SQLite MCP Server is built by the community, for the community. Special thanks to @Insighttful for contributing the tool filtering feature in v2.6.4. We welcome contributions! Check out our Contributing Guide to get started.

🚀 Get Started Today

Transform your SQLite databases into AI-ready powerhouses with 73 specialized tools, enterprise-grade security, and production-ready reliability. Whether you're building analytics pipelines, implementing semantic search, or processing geospatial data, SQLite MCP Server provides everything you need.

# Quick start with Docker
docker pull writenotenow/sqlite-mcp-server:latest
docker run -i --rm -v $(pwd):/workspace \
  writenotenow/sqlite-mcp-server:latest \
  --db-path /workspace/database.db

# Test everything works
python test_runner.py --quick

💡 Pro Tip: Start with the quick test to verify your installation, then explore the comprehensive documentation and example gists to discover all the capabilities. The AI-powered search helps you find exactly what you need with natural language queries.