An MCP (Model Context Protocol) server designed to interact with encrypted SQLite databases, particularly those secured with SQLCipher 4. It enables users to perform comprehensive CRUD (Create, Read, Update, Delete) operations, explore database structures, and execute custom SQL queries on protected data. This tool is especially valuable for accessing information from common applications like MoneyMoney, 1Password, Signal, WhatsApp, Firefox, Telegram, and KeePass, which utilize encrypted SQLite for sensitive local data storage, requiring the correct passphrase for access.
Key Features
01Execute Arbitrary SQL Queries (SELECT, INSERT, UPDATE, DELETE, DDL)
02SQLCipher 4 Encrypted SQLite Support
03Database Schema Exploration (tables, columns, indexes)
04Full CRUD Operations with Filtering and Pagination
050 GitHub stars
06AES-256-GCM Encrypted Passphrases with macOS Keychain integration
Use Cases
01Accessing data from applications like MoneyMoney, 1Password, Signal, and WhatsApp that utilize SQLCipher for local data storage.
02Performing CRUD operations on sensitive information stored in SQLCipher 4 encrypted SQLite databases.
03Exploring the schema and executing custom SQL queries on encrypted SQLite files for development or analysis.