Translation MCP Server

Translation MCP Server v1.0.0

MCP server for managing translation insertions into the clubee database with automatic cache revalidation and insertion reporting.

Features

• Translation Insertion: Insert new translation keys into the database
• Duplicate Prevention: Automatically checks for existing keys
• Cache Revalidation: Automatically purges cache after successful insertions
• Insertion Tracking: Tracks all insertions during the session
• Detailed Reporting: Shows insertion reports with timestamps

Setup

1. Install dependencies:
   npm install
2. Build the project:
   npm run build
3. Run the server:
   npm start

Usage

The server provides one tool:

insert_translation_key

Inserts a new translation key into the database and automatically revalidates the cache.

Parameters:

• key: The translation key/placeholder to insert
• page_prefix: The page prefix (e.g., v3_licenses, shop, faddish)
• english_translation: The default English translation

Example:

Response includes:

• Success confirmation for the insertion
• Cache revalidation status
• Complete insertion report showing all translations added during the session

Database Record Created:

• page: "v3_licenses"
• placeholder: "license.specific_tags"
• en: "Specific Tags"
• Other language fields (de, fr, lu, nl, fi, es): "***"

Automatic Cache Revalidation

After each successful translation insertion, the server automatically calls:

This ensures that the new translations are immediately available in the application cache.

Database Connection

Connects to:

• Host: databaserouter.test.clubee-aws.xyz
• Port: 3306
• Database: clubee
• User: root

Version History

v1.0.0

• Initial release with translation insertion
• Automatic cache revalidation after insertions
• Session-based insertion tracking and reporting
• Duplicate key prevention