translator-mcp
Allows AI to translate database content from English to German directly in a live MySQL database, with read-only permissions, column whitelisting, and audit logging.
This server does not currently have a deployable release on Glama. Follow the repository's setup instructions to install and configure it for your MCP client, including any required credentials and local dependencies.
Translation MCP Server
A secure MCP server that allows AI to translate database content from English to German directly in your live database.
π Full Documentation - Complete guide with architecture, security details, and deployment instructions
Security Features
Read-only by default: Only SELECT and UPDATE permissions on specific columns
No DELETE permissions: Cannot remove any data
Column whitelisting: Only specified German columns can be updated
Audit logging: All translations are logged with timestamps and session IDs
Connection pooling: Limited concurrent connections to prevent overload
Input validation: All inputs are validated with Zod schemas
Transaction support: Bulk updates use transactions for data integrity
Related MCP server: MySQL MCP Server
Setup
1. Database Setup
Run the SQL script to create a restricted user:
mysql -u root -p < database-setup.sql2. Install Dependencies
npm install3. Configure Environment
Copy .env.example to .env and update with your database credentials:
cp .env.example .env4. Build the Server
npm run build5. Configure MCP Client
Add to your MCP client settings (e.g., Claude Desktop: ~/Library/Application Support/Claude/claude_desktop_config.json):
{
"mcpServers": {
"translation-server": {
"command": "node",
"args": ["/absolute/path/to/translatemcp/dist/index.js"],
"env": {
"DB_HOST": "your-server.com",
"DB_USER": "mcp_translator",
"DB_PASSWORD": "secure_password",
"DB_NAME": "your_database",
"ALLOWED_TABLES": "{...your config...}"
}
}
}
}Usage with AI
Once configured, AI can use these tools:
get_translation_items: Fetch items needing translation
update_translation: Update a single item's German translations
bulk_update_translations: Update multiple items in one transaction
get_translation_progress: Check translation statistics
Example AI conversation:
You: "Please translate the first 10 products from English to German"
AI: [Uses get_translation_items to fetch products]
AI: [Translates each item]
AI: [Uses bulk_update_translations to save all translations]Documentation
π Complete Documentation - In-depth technical guide
ποΈ Architecture Overview - System design and components
π Security Model - Security layers and protections
π Deployment Guide - Production setup instructions
π§ Troubleshooting - Common issues and solutions
Monitoring
Check translation audit logs:
SELECT * FROM translation_audit
WHERE translated_at > DATE_SUB(NOW(), INTERVAL 1 DAY)
ORDER BY translated_at DESC;Check translation progress:
SELECT table_name, COUNT(DISTINCT record_id) as records_translated
FROM translation_audit
GROUP BY table_name;Tool Schema Changelog
Recent tool additions, removals, and schema changes observed during successful MCP inspections.
Loading tool schema changelogβ¦
This server cannot be deployed
Maintenance
Related MCP Connectors
Safe, read-only Postgres and MySQL access for AI agents. Audit log + column-level controls.
Work with your database from AI tools: ask, export, approved changes, and scheduled jobs.
Query 40 databases from Claude, ChatGPT, or Cursor β on any device. Read-only, encrypted, audited.
AI agents propose database changes as reviewable requests β no direct write access.
Related MCP Servers
- AlicenseAqualityDmaintenanceEnables AI assistants to interact with PostgreSQL databases using natural language queries, providing secure read-only access to database schemas and SQL translation capabilities.69 npmISC
- AlicenseNot gradedqualityDmaintenanceEnables natural language database operations on MySQL databases with AI integration, supporting CRUD operations, schema inspection, and audit logging with built-in security features including SQL injection protection and permission controls.798 npmMIT
- AlicenseNot gradedqualityDmaintenanceEnables AI assistants to query Microsoft SQL Server safely through natural language, with an iron-clad read-only guarantee enforced at both database and application levels.MIT
- AlicenseAqualityBmaintenanceEnables AI clients to safely query PostgreSQL databases using plain English, with read-only access and built-in SQL safety checks.4MIT