mcp-sqlite-tools
Verified Safeby spences10
Overview
A Model Context Protocol (MCP) server for LLMs to safely and efficiently interact with local SQLite databases, providing comprehensive operations from schema management to query execution and transactions.
Installation
npx -y mcp-sqlite-toolsEnvironment Variables
- SQLITE_DEFAULT_PATH
- SQLITE_ALLOW_ABSOLUTE_PATHS
- SQLITE_MAX_QUERY_TIME
- SQLITE_BACKUP_PATH
- DEBUG
- SQLITE_DEFAULT_DATABASE
Security Notes
The server implements robust security features including comprehensive input validation (Valibot), strict query classification (separating read-only, write, and schema operations), and path validation to prevent directory traversal attacks. It supports configurable path restrictions and uses parameterized queries to mitigate SQL injection. Resources are gracefully cleaned up on shutdown, and transaction safety is built-in. No direct 'eval' or other highly dangerous dynamic code execution patterns were identified. Its local nature, combined with these protections, makes it generally safe, provided the host environment is secure and configurations like `SQLITE_ALLOW_ABSOLUTE_PATHS` are managed carefully.
Similar Servers
sqlite-mcp
A Model Context Protocol (MCP) server that enables LLMs to interact with SQLite databases by providing tools and resources for querying and managing data.
sqlite-mcp-server
Provides an MCP interface for an SQLite database, offering a wide range of data management, advanced analytics, JSON processing, text/vector search, and geospatial capabilities.
sqlite-mcp
Integrates Model Context Protocol (MCP) servers, enabling SQLite databases to call their AI tools directly from SQL queries.
db-mcp
An enterprise-grade Model Context Protocol (MCP) server providing advanced database operations, AI-native functionalities like vector search, and OAuth 2.1 authentication for SQLite databases.