Encrypted SQLite

About

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

• Execute Arbitrary SQL Queries (SELECT, INSERT, UPDATE, DELETE, DDL)
• SQLCipher 4 Encrypted SQLite Support
• Database Schema Exploration (tables, columns, indexes)
• Full CRUD Operations with Filtering and Pagination
• 0 GitHub stars
• AES-256-GCM Encrypted Passphrases with macOS Keychain integration

Use Cases

• Accessing data from applications like MoneyMoney, 1Password, Signal, and WhatsApp that utilize SQLCipher for local data storage.
• Performing CRUD operations on sensitive information stored in SQLCipher 4 encrypted SQLite databases.
• Exploring the schema and executing custom SQL queries on encrypted SQLite files for development or analysis.