Provides tools to transpile SQL queries between MySQL and other supported dialects, ensuring query compatibility across different database environments.
Provides tools to transpile SQL queries between PostgreSQL and other supported dialects, ensuring query compatibility across different database environments.
Click on "Install Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@SQL-Transpiler MCP ToolConvert this MySQL query to PostgreSQL: SELECT * FROM users LIMIT 10"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
🚀 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
⚙️ Prerequisites
Python 3.13+ (if running locally)
UV package manager (for dependency management)
Docker (if running via container)
🚀 Installation
Option 1: Using UV (Locally)
Clone the repository
git clone https://github.com/Baronco/SQL-Transpiler-MCP-Tool.git cd sql-transpilerInstall UV
pip install uvSync dependencies (using
uv sync --frozenRun the server
uv run server.py
Option 2: Using Docker
Clone the repository
git clone https://github.com/your-username/sql-transpiler.git cd sql-transpilerBuild the Docker image
docker build -t sql-transpiler .
📄 Usage
Use the
Dialectstool to list all supported SQL dialects.Use the
Transpilertool to convert SQL queries from one dialect to another.
For more details, see the instructions in
🖥️ 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:
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):
📝 License
MIT License