Thales Cdsp Cakm MCP 伺服器 | PlugMCP
跳到正文 Thales CipherTrust Data Security Platform CAKM MCP Server
A Model Context Protocol (MCP) server for Database EKM/TDE operations using CipherTrust Application Key Management (CAKM).
🔑 Features
Resource-Based Management : Tools are organized by the database objects they manage (e.g., keys, encryption, wallets), not just by actions.
MCP Server to manage encryption for Ms SQL and Oracle databases using Thales CAKM connector
把任意工具接入任意代理。面向非開發者的 MCP 伺服器目錄;閘道承載流量,n8n 承載應用。
產品
目錄
開發者
公司
Operational Grouping : Each tool exposes multiple operations (e.g., create, list, rotate) for comprehensive lifecycle management.
Unified Status & Auditing : A single tool (status_tde_ekm) provides health, compliance, and configuration monitoring across all supported databases.Advanced Oracle TDE Detection : Intelligent detection of Oracle TDE configurations including:
HSM-only TDE : Direct HSM wallet usage
HSM with Auto-login : Forward migrated configurations (HSM primary, auto-login secondary)
FILE wallet TDE : Password-based software wallets
FILE with Auto-login : Standard or reverse migrated configurations
Migration Status Recognition : Automatically identifies forward/reverse migration states based on wallet order and types
Database TDE Operations : Encrypt, decrypt, and manage TDE on multiple database types.
CipherTrust Integration : Seamless integration with CipherTrust Manager via CAKM EKM.
Multi-Database Support : SQL Server and Oracle Database.
Key Rotation : Automated encryption key rotation with key management on Thales CipherTrust Manager.
🚀 Quick Start
Clone the Repository # Clone the repository
git clone https://github.com/sanyambassi/thales-cdsp-cakm-mcp-server.git
cd thales-cdsp-cakm-mcp-server
Installation # Install dependencies
uv venv && source .venv/bin/activate # Linux/Mac
# uv venv && .venv\Scripts\activate # Windows
uv pip install -e .
# Configure (copy the example configuration)
# Note: Create your own .env file with database connection details
# See docs/PREREQUISITES.md for configuration examples
# Test connections
uv run python -m database_tde_server --test-connections
Usage # Start the MCP server
uv run python -m database_tde_server
📦 Installing uv This project uses uv to manage dependencies and run scripts. Please install it using one of the methods below.
powershell -c "irm https://astral.sh/uv/install.ps1 | iex"
Linux, macOS, and other shells:
curl -LsSf https://astral.sh/uv/install.sh | sh
🔧 Available Tools
Core Tools
list_database_connections(): Lists all configured database connections.
Unified Status & Auditing
status_tde_ekm(): Provides a unified interface to monitor the health, configuration, and compliance of TDE across both SQL Server and Oracle.
SQL Server Tools
manage_sql_ekm_objects(): Manages EKM providers, credentials, and their associated server logins.
manage_sql_keys(): Manages the lifecycle of cryptographic keys (Asymmetric Master Keys and DEKs), including creation, listing, dropping, and rotation.
manage_sql_encryption(): Encrypts or decrypts one or more SQL Server databases.
Oracle Tools
manage_oracle_tde_deployment(): Handles high-level TDE deployment workflows like initial setup or migration to/from an HSM.
manage_oracle_configuration(): Manages TDE-related database parameters.
manage_oracle_wallet(): Performs all wallet-specific actions (open, close, backup, manage auto-login).
manage_oracle_keys(): Manages the lifecycle of Master Encryption Keys (MEKs), including rotation and listing.
manage_oracle_tablespace_encryption(): Manages the encryption and decryption of specific tablespaces.
🤖 AI Assistant Integration Add to your AI assistant configuration:
Claude Desktop {
"mcpServers": {
"database-tde": {
"command": "uv",
"args": ["run", "python", "-m", "database_tde_server"],
"cwd": "/path/to/cakm-mcp-server-sql-oracle",
"env": {
"DB_TDE_SERVER_NAME": "database-tde-mcp",
"DB_TDE_LOG_LEVEL": "INFO",
"DB_TDE_DATABASE_CONNECTIONS": "[{\"name\":\"prod_sql\",\"db_type\":\"sqlserver\",\"host\":\"sql-prod.company.com\",\"port\":1433,\"username\":\"tde_admin\",\"password\":\"secure_password\"},{\"name\":\"oracle_cdb1\",\"db_type\":\"oracle\",\"host\":\"oracle-prod.company.com\",\"port\":1521,\"username\":\"sys\",\"password\":\"oracle_password\",\"oracle_config\":{\"oracle_home\":\"/u01/app/oracle/product/21.0.0/dbhome_1\",\"oracle_sid\":\"cdb1\",\"service_name\":\"orcl\",\"mode\":\"SYSDBA\",\"wallet_root\":\"/opt/oracle/wallet\"},\"ssh_config\":{\"host\":\"oracle-prod.company.com\",\"username\":\"oracle\",\"private_key_path\":\"/path/to/private-key.pem\",\"port\":22,\"timeout\":30}}]"
}
}
}
}
Cursor AI (mcp.json) {
"mcpServers": {
"database-tde": {
"command": "uv",
"args": ["run", "python", "-m", "database_tde_server"],
"cwd": "/path/to/cakm-mcp-server-sql-oracle",
"env": {
"DB_TDE_SERVER_NAME": "database-tde-mcp",
"DB_TDE_LOG_LEVEL": "INFO",
"DB_TDE_DATABASE_CONNECTIONS": "[{\"name\":\"prod_sql\",\"db_type\":\"sqlserver\",\"host\":\"sql-prod.company.com\",\"port\":1433,\"username\":\"tde_admin\",\"password\":\"secure_password\"},{\"name\":\"oracle_cdb1\",\"db_type\":\"oracle\",\"host\":\"oracle-prod.company.com\",\"port\":1521,\"username\":\"sys\",\"password\":\"oracle_password\",\"oracle_config\":{\"oracle_home\":\"/u01/app/oracle/product/21.0.0/dbhome_1\",\"oracle_sid\":\"cdb1\",\"service_name\":\"orcl\",\"mode\":\"SYSDBA\",\"wallet_root\":\"/opt/oracle/wallet\"},\"ssh_config\":{\"host\":\"oracle-prod.company.com\",\"username\":\"oracle\",\"private_key_path\":\"/path/to/private-key.pem\",\"port\":22,\"timeout\":30}}]"
}
}
}
}
Gemini CLI (settings.json) {
"mcpServers": {
"database-tde": {
"command": "uv",
"args": ["run", "python", "-m", "database_tde_server"],
"cwd": "/path/to/cakm-mcp-server-sql-oracle",
"env": {
"DB_TDE_SERVER_NAME": "database-tde-mcp",
"DB_TDE_LOG_LEVEL": "INFO",
"DB_TDE_DATABASE_CONNECTIONS": "[{\"name\":\"prod_sql\",\"db_type\":\"sqlserver\",\"host\":\"sql-prod.company.com\",\"port\":1433,\"username\":\"tde_admin\",\"password\":\"secure_password\"},{\"name\":\"oracle_cdb1\",\"db_type\":\"oracle\",\"host\":\"oracle-prod.company.com\",\"port\":1521,\"username\":\"sys\",\"password\":\"oracle_password\",\"oracle_config\":{\"oracle_home\":\"/u01/app/oracle/product/21.0.0/dbhome_1\",\"oracle_sid\":\"cdb1\",\"service_name\":\"orcl\",\"mode\":\"SYSDBA\",\"wallet_root\":\"/opt/oracle/wallet\"},\"ssh_config\":{\"host\":\"oracle-prod.company.com\",\"username\":\"oracle\",\"private_key_path\":\"/path/to/private-key.pem\",\"port\":22,\"timeout\":30}}]"
}
}
}
}
Architecture Overview MCP Server ↔ Database Server ↔ CAKM Provider/Library ↔ CipherTrust Manager
Note : This MCP server communicates only with database servers. The CAKM providers installed on database servers handle all communication with CipherTrust Manager.
Oracle TDE Enablement Logic The server uses Oracle-documented logic to determine TDE status based on wallet configurations and TDE parameters:
Any wallet shows OPEN status AND Master Encryption Keys (MEKs) exist
📊 Wallet Order Types (from Oracle V$ENCRYPTION_WALLET):
SINGLE : Only one wallet type configured
PRIMARY : Primary wallet in a dual-wallet configuration
SECONDARY : Secondary wallet in a dual-wallet configuration
🔧 TDE Configuration Parameter Values:
FILE : TDE configured to use FILE wallets only
HSM : TDE configured to use HSM wallets only
HSM|FILE : TDE configured with HSM as primary, FILE as secondary
FILE|HSM : TDE configured with FILE as primary, HSM as secondary
📊 Supported TDE Scenarios:
HSM-only TDE : HSM wallet OPEN (SINGLE), TDE_CONFIGURATION=HSM
HSM with Auto-login (Migrated) : HSM wallet OPEN (PRIMARY), auto-login wallet OPEN (SECONDARY), TDE_CONFIGURATION=HSM|FILE
HSM with Auto-login (Not Migrated) : HSM wallet OPEN (PRIMARY), auto-login wallet OPEN_NO_MASTER_KEY (SECONDARY), TDE_CONFIGURATION=HSM|FILE
FILE wallet TDE : PASSWORD wallet OPEN (SINGLE), TDE_CONFIGURATION=FILE
FILE with Auto-login (Reverse Migrated) : PASSWORD wallet OPEN (PRIMARY), auto-login wallet OPEN (SECONDARY), TDE_CONFIGURATION=FILE|HSM
FILE with Auto-login : PASSWORD wallet OPEN (PRIMARY), auto-login wallet OPEN (SECONDARY), TDE_CONFIGURATION=FILE
🔍 Migration Detection Logic:
Forward Migration : HSM becomes PRIMARY (HSM|FILE configuration) → Database migrated from FILE to HSM
Reverse Migration : FILE becomes PRIMARY (FILE|HSM configuration) → Database migrated from HSM back to FILE
WALLET_ORDER and TDE_CONFIGURATION are correlated to determine the migration state
TDE configuration parameters validate the expected wallet hierarchy
Wallet order and TDE_CONFIGURATION together determine the deployment scenario
🔧 Oracle TDE Operations Guide The oracle_tde_deployment tool provides different operations for various TDE setup scenarios:
Operation Types & Use Cases 1. HSM-Only TDE Setup (No Auto-login)
{
"oracle_connection": "oracle_cdb2",
"operation": "setup_hsm_only",
"ciphertrust_username": "tdeuser",
"ciphertrust_password": "Thales123!",
"ciphertrust_domain": "TDE",
"auto_restart": true
}
Use when : "Skip auto-login wallet creation" or "HSM only"
Creates : HSM keystore only
Result : Manual wallet opening required after restarts
No software_wallet_password needed
2. Complete TDE Setup (HSM + Auto-login)
{
"oracle_connection": "oracle_cdb2",
"operation": "setup_hsm_with_autologin",
"ciphertrust_username": "tdeuser",
"ciphertrust_password": "Thales123!",
"ciphertrust_domain": "TDE",
"software_wallet_password": "Thales123!",
"auto_restart": true
}
Use when : "Set up complete TDE with auto-login"
Creates : HSM + software wallet + auto-login keystore
Result : Database starts automatically without manual intervention
Requires software_wallet_password
3. Add Auto-login to Existing TDE
{
"oracle_connection": "oracle_cdb2",
"operation": "add_autologin",
"ciphertrust_username": "tdeuser",
"ciphertrust_password": "Thales123!",
"ciphertrust_domain": "TDE",
"software_wallet_password": "Thales123!",
"auto_restart": true
}
Use when : Database has HSM TDE, want to add auto-login
Creates : Software wallet + auto-login for existing HSM setup
Requires software_wallet_password
{
"oracle_connection": "oracle_cdb2",
"operation": "get_tde_status"
}
Use when : Want to see current TDE configuration
Returns : Comprehensive wallet and TDE status
No credentials needed
Quick Reference
"Skip auto-login" → Use setup_hsm_only
"Complete TDE setup" → Use setup_hsm_with_autologin
"Add auto-login to existing" → Use add_autologin
"Check what I have" → Use get_tde_status
Example Prompts "Show me the TDE status of all my databases"
"For my 'prod_sql' connection, list all the asymmetric keys using the 'manage_sql_keys' tool"
"Rotate the master key on the 'Db05' database using the 'prod_sql' connection"
"Encrypt the 'SalesDB' database on my 'prod_sql' server"
"What is the wallet status for my 'oracle_cdb2' connection?"
Important Notes
Automatic Database Restarts : When specified in prompts, MCP tools can automatically restart Oracle databases as part of TDE operations
SSH Authentication : Oracle connections support both private key and password authentication
Private key: Use "private_key_path": "/path/to/key.pem" in ssh_config
Password: Use "password": "your_ssh_password" in ssh_config (instead of private_key_path)
Supported Databases : Microsoft SQL Server and Oracle Database are supported
📚 Documentation
🤝 Contributing
Fork the repository
Create a feature branch
Make your changes
Add tests for new functionality
Ensure all tests pass
Submit a pull request
📄 License This project is licensed under the MIT License - see the LICENSE file for details.
Graphify Turn any codebase, with its docs, SQL schemas, configs, and PDFs, into a queryable knowledge graph. A /graphify skill for Claude Code, Cursor, Codex, and Gemini CLI: local deterministic AST parsing, e Private Gpt Complete API layer for private AI applications on local models: RAG, skills, tools, MCP, text-to-sql, and more. Works with any OpenAI-compatible inference server. Scientific Agent Skills Turn any AI agent into an AI Scientist. The #1 Agent Skills library for science, used by 250,000+ scientists worldwide. 177 ready-to-use validated skills plus 100+ scientific databases covering biolog Open Code Review Secure, fast, efficient, battle-tested at Alibaba's scale. Hybrid architecture code review tool: deterministic pipelines + LLM Agent, precise line-level comments, built-in multi-language ruleset (NPE, Codebase Memory Local code intelligence for developers and AI agents. Connect code, docs and infrastructure in a persistent graph, with CBM Lens, MCP tools, agent integrations and change-aware test selection. Orm The Prisma ORM: write your application in TypeScript with human-readable queries instead of SQL. Host your database on Prisma Postgres and your app on Prisma Compute. OpenViking Self-evolving Context Database for AI Agents. Unify Agent Memory, Knowledge RAG and Skills. Context Mode Free, local plugin that keeps tool output out of your coding agent's context window. Sandbox and SQLite FTS5 search, 99% fewer bytes in context. Works with Claude Code, Codex, Pi, OMP, OpenCode, Gemin Dbx 25 MB lightweight cross-platform database client for 100+ databases, including MySQL, PostgreSQL, SQLite, Redis, MongoDB, DuckDB, SQL Server, and Dameng. Built-in AI, MCP Server, CLI, desktop and Dock Xerj AI search engine and MCP server for bots and agents. One Rust binary indexes code, docs, logs, JSONL/CSV and PDFs for BM25 full-text, vector and hybrid search, code search without grep, agent memory a Wasp The batteries-included full-stack framework for the AI era. Develop JS/TS web apps (React, Node.js, and Prisma) using declarative code that abstracts away complex full-stack features like auth, backgr WrenAI GenBI (Generative BI) for AI agents, an open-source, governed text-to-SQL through an open context layer that turns natural-language questions into trusted dashboards, charts, and SQL across 20+ data s Databases MCP 伺服器 最佳 Databases MCP 伺服器
尚無工具清單。遠端伺服器會在首次健康檢查後取得工具清單。
如何安裝 Thales Cdsp Cakm? 在本頁複製適用於 Cursor、Claude Desktop、Claude Code 或 VS Code 的 stdio 設定。它使用發布者的安裝方式,而不是 PlugMCP 代理伺服器。
Thales Cdsp Cakm 需要 API 金鑰嗎? 這筆記錄未列出必要的環境變數。
Thales Cdsp Cakm 使用哪種傳輸方式? Thales Cdsp Cakm 透過 stdio 在本機執行。
Thales Cdsp Cakm 上次檢查是什麼時候? 上次檢查時間:2026-10-28。 MCP Server to manage encryption for Ms SQL and Oracle databases using Thales CAKM connector
工具
0 / 10