Development
Translate SQL between MySQL, PostgreSQL, SQLite, BigQuery, Snowflake, and Redshift — DDL, DML, functions and types, with UNSUPPORTED warnings
Call this tool from your code in three languages.
curl -X POST 'https://api.elysiatools.com/en/api/tools/sql-dialect-bridge' \
-H 'Content-Type: application/json' \
-d '{"sql":"CREATE TABLE t (id INT AUTO_INCREMENT, name TEXT);\nSELECT GROUP_CONCAT(name SEPARATOR '\'', '\'') FROM t LIMIT 10;","sourceDialect":"mysql","targetDialect":"postgresql","preserveFormatting":true}'Send a POST request with your inputs as JSON. File parameters require a separate upload first.
POST https://api.elysiatools.com/en/api/tools/sql-dialect-bridge| Name | Type | Required | Description |
|---|---|---|---|
| sql | textarea | Yes | — |
| sourceDialect | select | No | — |
| targetDialect | select | No | — |
| preserveFormatting | checkbox | No | — |
HTML result
{
"result": "<div>Processed HTML content</div>",
"error": "Error message (optional)",
"message": "Notification message (optional)",
"metadata": {
"key": "value"
}
}Add this tool to your Model Context Protocol server so AI agents can list and call it.
Add this block to your MCP client configuration:
{
"mcpServers": {
"elysiatools-sql-dialect-bridge": {
"name": "sql-dialect-bridge",
"description": "Translate SQL between MySQL, PostgreSQL, SQLite, BigQuery, Snowflake, and Redshift — DDL, DML, functions and types, with UNSUPPORTED warnings",
"baseUrl": "https://api.elysiatools.com/mcp/sse?toolId=sql-dialect-bridge",
"command": "",
"args": [],
"env": {},
"isActive": true,
"type": "sse"
}
}
}After connecting to the SSE endpoint, list the exposed tools:
{
"jsonrpc": "2.0",
"id": 1,
"method": "tools/list"
}Invoke the tool by its id, passing arguments built from its parameters:
{
"jsonrpc": "2.0",
"id": 2,
"method": "tools/call",
"params": {
"name": "sql-dialect-bridge",
"arguments": {
"sql": "CREATE TABLE t (id INT AUTO_INCREMENT, name TEXT);\nSELECT GROUP_CONCAT(name SEPARATOR ', ') FROM t LIMIT 10;",
"sourceDialect": "mysql",
"targetDialect": "postgresql",
"preserveFormatting": true
}
}
}Questions or issues? Contact [email protected]