🚀 SQL-Transpiler MCP Tool

SQL-Transpiler is a MCP tool designed to transpile SQL queries between different dialects using the sqlglot library. This tool helps you convert SQL code from one dialect (e.g., MySQL) to another (e.g., PostgreSQL) with ease, ensuring compatibility across various database systems.

🛠️ Features

• Dialect Support: Lists all SQL dialects supported by sqlglot.
• SQL Transpilation: Converts SQL queries from one dialect to another.
• Error Handling: Informs you if a dialect is unsupported or if there are syntax errors.

📦 Library Used

• sqlglot
  Version: Check your pyproject.toml or uv.lock for the exact version used in this project.

📝 License

MIT License

⚙️ Prerequisites

• Python 3.13+ (if running locally)
• UV package manager (for dependency management)
• Docker (if running via container)

🚀 Installation

Option 1: Using UV (Locally)

1. Clone the repository

   Copy

   git clone https://github.com/Baronco/SQL-Transpiler-MCP-Tool.git
   cd sql-transpiler

2. Install UV

   Copy

   pip install uv
   

3. Sync dependencies (using uv.lock)

   Copy

   uv sync --frozen
   

4. Run the server

   Copy

   uv run server.py

Option 2: Using Docker

1. Clone the repository

   Copy

   git clone https://github.com/your-username/sql-transpiler.git
   cd sql-transpiler

2. Build the Docker image

   Copy

   docker build -t sql-transpiler .

📄 Usage

• Use the Dialects tool to list all supported SQL dialects.
• Use the Transpiler tool to convert SQL queries from one dialect to another.

For more details, see the instructions in src/instructions.md.

🖥️ Integration with Claude Desktop

To add the SQL-Transpiler MCP tool to your Claude Desktop configuration using the Docker image, update your claude_desktop_config.json as follows:

{
  "mcpServers": {
    "sql-transpiler": 
    {
      "command": "docker",
      "args": ["run", "-i", "--rm", "--init", "-e", "DOCKER_CONTAINER=true", "sql-transpiler"]
    }
  }
}

If you want to use your local environment with UV instead of Docker, configure your claude_desktop_config.json like this (adjust the path as needed):

{
  "mcpServers": {
    "sql-transpiler": 
    {
      "command": "uv",
      "args": [
        "--directory",
        "path/to/sql-transpiler",
        "run",
        "server.py"
      ]
    }
  }
}