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

Related MCP server: Code Analysis MCP Server

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:

{
  "key": "license.specific_tags",
  "page_prefix": "v3_licenses",
  "english_translation": "Specific Tags"
}

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:

PURGE https://apiv3.clubee.dev/revalidate

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