SQLite MCP Server

# Changelog All notable changes to this project will be documented in this file. ## [1.3.0] - 2025-12-20 ### Added - **New Tool: `sqlite_column_statistics`**: Detailed column statistics and data profiling - Column data type, distinct values, null counts - Min/max values for numeric columns - Average values and null percentages - **New Tool: `sqlite_database_summary`**: Comprehensive database metadata and statistics - File size (formatted and raw bytes) - Table, view, index, and trigger counts - Total row count across all tables - WAL mode status and read-only status - **New Tool: `sqlite_schema_erd`**: Entity Relationship Diagram data generation - Entities with columns and primary keys - Relationships with foreign key information - Supports visualization tool integration - **New Tool: `sqlite_schema_rag_context`**: RAG context generation for AI models - Markdown-formatted schema documentation - Table structures with column types and constraints - Foreign key relationships and defaults - Optimized for AI/LLM consumption - **New Tool: `sqlite_analyze_query`**: SQL query analysis and optimization - EXPLAIN QUERY PLAN output - Query type detection (SELECT, MODIFY, etc.) - Table extraction and complexity assessment - **New Tool: `sqlite_optimization_hints`**: Query optimization recommendations - Detects SELECT * usage - Identifies leading wildcard LIKE patterns - Suggests missing indexes - Recommends query structure improvements - **New Tool: `sqlite_database_health_check`**: Database integrity and health monitoring - PRAGMA integrity_check results - Foreign key consistency validation - Schema validity assessment - Overall database health status - **New Tool: `sqlite_unused_indexes`**: Index optimization analysis - Identifies potentially unused indexes - Detects redundant/duplicate indexes - Provides removal recommendations - **New Tool: `sqlite_connection_pool_stats`**: Connection pool monitoring - Active connection count - Pool size and availability statistics ### Changed - Incremented tool count from 18 to 28 in documentation - Updated version in package.json and server implementation to 1.3.0 - Enhanced README with new data analysis and query optimization tools ## [1.2.0] - 2025-12-20 ### Added - **New Tool: `sqlite_views`**: Comprehensive database view management - `create_view` - Create new views with SELECT queries - `drop_view` - Drop existing views - `list_views` - List all views in the database - `get_view_info` - Retrieve detailed view information and definitions - Support for IF NOT EXISTS and IF EXISTS clauses - **New Tool: `sqlite_indexes`**: Index management and performance optimization - `list_indexes` - List all indexes in the database - `get_index_info` - Get detailed index information including columns and uniqueness - `analyze_index` - Analyze index statistics for query optimization - **New Tool: `sqlite_constraints`**: Constraint and data integrity management - `list_constraints` - View all constraints across tables or specific table - `list_foreign_keys` - List all foreign key relationships with cascade rules - **New Tool: `sqlite_migrate`**: Data migration and synchronization between tables - `clone_table` - Clone table structure and optionally data - `compare_structure` - Compare table structures to identify differences - `copy_data` - Copy data between tables with optional filtering (WHERE clause) - **New Tool: `sqlite_backup_restore`**: Backup and restore operations - `backup_table` - Backup specific table to SQL file with data and schema - `restore_from_sql` - Restore database from SQL file - `get_create_statement` - Retrieve CREATE TABLE statement for any table - **Database Manager Methods**: 25+ new methods supporting view, index, constraint, and migration operations - View operations: `createView`, `dropView`, `getViewInfo`, `listViews` - Index operations: `getIndexInfo`, `listIndexes`, `analyzeIndex` - Constraint operations: `listConstraints`, `listForeignKeys` - Migration operations: `cloneTable`, `compareTableStructure`, `copyTableData` - Backup operations: `backupTable`, `restoreFromSQL`, `getCreateTableStatement` ### Changed - Incremented tool count from 13 to 18 in documentation - Updated total available tools from 13 to 18 in README and AGENTS.md ## [1.1.8] - 2025-12-20 ### Added - **New Tool: `sqlite_relations`**: Comprehensive table relationship analysis tool for analyzing foreign key constraints and dependencies - Supports incoming and outgoing relationship analysis - Configurable depth traversal (1-5 levels) for deep relationship mapping - Detailed cascade rule information (CASCADE, SET NULL, RESTRICT, NO ACTION) - Related tables statistics and relationship tree building - Enables understanding of data dependencies before deletion or schema changes - **Relationship Analysis Methods**: New DatabaseManager methods for analyzing table relationships - `analyzeTableRelations()` - Main analysis method with filtering options - `getOutgoingRelations()` - Foreign keys this table references - `getIncomingRelations()` - Tables that reference this table with fallback support - `buildRelationshipTree()` - Recursive traversal for deep analysis ### Changed - Incremented tool count from 12 to 13 in README.md and documentation - Updated tool numbering in tools summary table ## [1.1.7] - 2025-12-20 ### Fixed - **SQL Injection in Bulk Operations**: Added `safeIdentifier` validation for table and column names in `bulkInsert`, `bulkUpdate`, and `bulkDelete` operations - **SQL Injection in PRAGMA Calls**: Added `isValidIdentifier` validation for table names in schema introspection PRAGMA commands (`table_info`, `foreign_key_list`, `index_list`) - **Overly Aggressive Security Pattern**: Refined SQL injection detection patterns to avoid false positives on legitimate queries (e.g., normal SELECT statements) - **Unused Imports**: Removed unused `ImageContent` and `EmbeddedResource` imports from mcp-server.ts ## [1.1.6] - 2025-12-20 ### Improved - **Tool Descriptions**: Enhanced all 12 MCP tool descriptions with detailed explanations, usage guidance, examples, and return value information - **Parameter Documentation**: Added concrete examples for all input parameters (e.g., table names, query syntax, WHERE conditions) - **Tool Selection Guidance**: Added context about when to use each tool vs alternatives (e.g., sqlite_insert vs sqlite_bulk_insert) - **Default Value Documentation**: Clarified default values for optional parameters in bulk operations and DDL ## [1.1.5] - 2025-12-20 ### Fixed - **SQL Injection Vulnerability**: Added proper validation and escaping for table and column names in INSERT, UPDATE, DELETE, and DDL operations using new `safeIdentifier` utility function - **Backup Function**: Fixed incorrect better-sqlite3 backup API usage - **DatabaseManager Singleton**: Changed from single instance to Map-based instances keyed by database path to support multiple database connections - **Version Mismatch**: Updated hardcoded server version in mcp-server.ts to match package.json - **Package Scripts**: Fixed incorrect CLI paths in package.json start and dev scripts - **Parameter Sanitization**: Removed over-aggressive character stripping that broke legitimate data; SQLite parameterized queries handle escaping automatically - **Permission Check**: Added fallback to default client permissions and explicit error when no permissions are configured ### Changed - Removed unused tsconfig path alias (`@/*`) that required additional tooling to work ## [1.1.4] - 2025-12-20 ### Changed - Removed Roadmap section from README.md - Removed Version History section from README.md - Updated Table of Contents to reflect removed sections ## [1.1.3] - 2024-12-20 ### Added - **Comprehensive Integration Guide**: Detailed setup instructions for multiple MCP clients - Claude Desktop (macOS, Windows, Linux) - Cursor IDE (global and project-specific) - Continue.dev - Cline (VS Code Extension) - Windsurf IDE - Generic MCP client configuration - **Tools Summary Table**: Quick reference table listing all 12 tools with descriptions - **Tool Categories**: Organized tools by functionality (Query, CRUD, Bulk, Schema, Operations) - **Table of Contents**: Added navigation for easier documentation browsing - **Quick Start Section**: 30-second setup guide for new users - **Multiple Database Configuration**: Example for configuring multiple SQLite databases ### Changed - Enhanced README.md with better formatting and organization - Updated badges with npm version and MIT license ## [1.1.2] - 2024-12-20 ### Added - **DDL Tool** (`sqlite_ddl`): New dedicated tool for schema management operations - CREATE TABLE with full column definition support (primary key, auto-increment, foreign keys, constraints) - DROP TABLE with IF EXISTS support - ALTER TABLE (add column, rename table, rename column) - CREATE INDEX (unique and non-unique indexes) - DROP INDEX with IF EXISTS support - **Procedure Permission**: Added `procedure` permission type for future compatibility (N/A for SQLite) ### Changed - Updated ENHANCEMENTS.md with proper markdown formatting and status tracking ## [1.1.1] - 2024-12-XX ### Added - **Bulk Operations**: Advanced bulk insert, update, and delete operations with progress tracking - **Relational Data Support**: Bulk insert with foreign key mappings and related table data - **Progress Tracking**: Real-time progress monitoring for bulk operations with error handling - **Performance Optimization**: Batch processing with configurable batch sizes for large datasets - **Enhanced Error Handling**: Improved error reporting and continue-on-error options ## [1.0.1] - 2024-XX-XX ### Added - Database and directory auto-creation functionality - Enhanced initialization logging with database status - Comprehensive roadmap for future development ### Fixed - Minor improvements and stability enhancements ## [1.0.0] - 2024-XX-XX ### Added - Initial release - Full MCP protocol implementation - Comprehensive 9-tier permission system - Security features including SQL injection protection - Audit logging for compliance - CLI interface with schema introspection - Connection pooling and performance optimization