mcp-encrypted-sqlite

rosch100/mcp-encrypted-sqlite

3.1

If you are the rightful owner of mcp-encrypted-sqlite and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to dayong@mcphub.com.

MCP server for encrypted SQLite databases using SQLCipher.

Tools

Functions exposed to the LLM to take actions

list_tables

List all tables in the database with optional column details.

get_table_data

Read data from a table with optional filtering, column selection, and pagination.

execute_sql

Execute arbitrary SQL statements (SELECT, INSERT, UPDATE, DELETE, DDL).

insert_or_update

Perform UPSERT operations (INSERT or UPDATE on conflict).

delete_rows

Delete rows from a table based on filters.

get_table_schema

Retrieves detailed schema information for a table.

list_indexes

Lists all indexes of a table.

Prompts

Interactive templates invoked by user choice

No prompts

Resources

Contextual data attached and managed by the client

No resources