Back to Home
spences10 icon

mcp-sqlite-tools

Verified Safe

by 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

Run Command
npx -y mcp-sqlite-tools

Environment 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

Stats

Interest Score36
Security Score9
Cost ClassHigh
Avg Tokens2500
Stars6
Forks2
Last Update2026-01-17

Tags

SQLiteDatabaseLLMAILocal Storage