SQLite Tools

关于

Empowering Large Language Models (LLMs) with secure and efficient interaction with local SQLite databases, this Model Context Protocol (MCP) server offers a full suite of database operations. It ensures data integrity and safety through advanced transaction management, robust security features like query classification and path validation, and a clear separation between read-only and destructive operations, making it ideal for building intelligent AI assistants that manage data while providing granular control over operations.

主要功能

• Advanced Transaction Management: Includes begin, commit, rollback with savepoint support and automatic cleanup of stale transactions.
• Robust Security Features: Implements query classification, path validation, input validation, and secure connection pooling.
• Database Maintenance & Efficiency: Offers backup, vacuum, bulk insert capabilities, and health-monitored connection pooling.
• Comprehensive SQLite Operations: Supports CRUD, schema management, and database administration.
• 6 GitHub stars
• Granular Tool Separation: Distinguishes between read-only, destructive, and schema modification operations for fine-grained client approval.

使用案例

• Empowering LLM agents to query and modify local SQLite databases securely.
• Automating database schema management and data migration tasks through AI interaction.
• Building AI-powered applications that require structured data storage and retrieval capabilities.