This tool functions as a Model Context Protocol (MCP) server, designed to facilitate secure interaction with SQLCipher encrypted SQLite databases. It provides a comprehensive suite of functionalities, including detailed database exploration (listing tables, columns, indexes, schema), execution of arbitrary SQL queries (SELECT, INSERT, UPDATE, DELETE, DDL), and full CRUD (Create, Read, Update, Delete) operations. A core focus is on security, offering robust SQLCipher 4 support, AES-256-GCM encrypted passphrases with macOS Keychain integration, configurable cipher profiles, and SQL identifier validation to prevent injection attacks.
Key Features
01Secure SQL identifier and input validation to prevent injection
02SQLCipher 4 encrypted database support
03Full CRUD operations and arbitrary SQL query execution
040 GitHub stars
05AES-256-GCM encrypted passphrases with macOS Keychain integration
06Comprehensive database exploration (schema, tables, columns, indexes)
