sqlite-mcp-server
Verified Safeby lksrpp
Overview
Enables LLMs to interact with SQLite databases through read-only tools for schema inspection and SQL query execution.
Installation
uv run sqlite_mcp_server.pySecurity Notes
The server implements robust validation for the 'query' tool, explicitly checking that queries start with 'SELECT' or 'WITH' and blocking a comprehensive list of forbidden keywords (e.g., INSERT, UPDATE, DELETE, DROP) using word boundaries to prevent write operations and common SQL injection vectors. The 'describe_table' tool also pre-validates table names against 'sqlite_master' using parameterized queries before executing PRAGMA commands. While the 'query' tool executes raw SQL (after validation) rather than using parameterized queries for user-supplied SQL, the strict read-only enforcement significantly mitigates major risks.
Similar Servers
DBchat
Transforms a database into an intelligent conversational partner, enabling natural language queries, instant answers, and data visualizations via MCP clients.
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.