Skip to main content
Glama
Sign In
sql2odata-mcp

sql2odata-mcp

by moonraker46
OverviewSchemaSourceRelated ServersDiscussionsAdmin
JavaScript
Remote

sql2odata-mcp

MCP server that translates SQL statements into OData v4 query syntax.

Use this as a tool in Claude Desktop, Cursor, Windsurf, or any MCP-compatible LLM client.

Install

npm install -g sql2odata-mcp

Related MCP server: sqlserver-mcp-colossal

Configuration

Claude Desktop

Add to ~/Library/Application Support/Claude/claude_desktop_config.json:

{
  "mcpServers": {
    "sql2odata": {
      "command": "npx",
      "args": ["-y", "sql2odata-mcp"]
    }
  }
}

Claude Code

claude mcp add sql2odata -- npx -y sql2odata-mcp

Cursor

Add to Cursor MCP settings:

{
  "mcpServers": {
    "sql2odata": {
      "command": "npx",
      "args": ["-y", "sql2odata-mcp"]
    }
  }
}

Available Tools

translate-sql

Translate a single SQL statement to OData v4.

Parameters:

  • sql (string, required) — SQL statement (SELECT, INSERT, UPDATE, DELETE)

  • encode (boolean, optional) — URL-encode the output

Example:

translate-sql({ sql: "SELECT Name, Age FROM Users WHERE Country = 'Germany' ORDER BY Name LIMIT 10" })

Returns:

GET /Users?$select=Name,Age&$filter=Country eq 'Germany'&$orderby=Name asc&$top=10

Parameters:
  $select = Name,Age
  $filter = Country eq 'Germany'
  $orderby = Name asc
  $top = 10

translate-batch

Translate multiple SQL statements at once.

Parameters:

  • queries (string[], required) — Array of SQL statements

  • encode (boolean, optional) — URL-encode the output

sql-syntax-help

Show all supported SQL syntax and their OData v4 equivalents.

Parameters: none

Available Prompts

sql-to-odata

Pre-built prompt template that translates SQL and explains the result.

Parameters:

  • sql (string) — SQL statement to translate

Supported SQL

SQL

OData v4

SELECT col1, col2

$select=col1,col2

SELECT COUNT(*)

$count=true

FROM Table

/Table

WHERE col = 'val'

$filter=col eq 'val'

WHERE LIKE '%text%'

contains(col,'text')

WHERE IN ('a','b')

(col eq 'a' or col eq 'b')

WHERE BETWEEN 1 AND 10

col ge 1 and col le 10

IS NULL / IS NOT NULL

eq null / ne null

ORDER BY col ASC

$orderby=col asc

LIMIT n / OFFSET n

$top=n / $skip=n

JOIN Table ON ...

$expand=Table

GROUP BY + aggregates

$apply=groupby(...)

INSERT INTO ... VALUES

POST + JSON body

UPDATE ... SET ... WHERE

PATCH + JSON body

DELETE FROM ... WHERE

DELETE

Related

License

MIT

Author

Ulrich Waldmann — moonraker@magenta.de

This server cannot be deployed

Claude Code, inside the Godot 4 editorFlockbay puts an AI agent in the real Godot 4 editor: it writes GDScript, runs your game and fixes what breaks. Free, or bring your own Claude Code or Codex.flockbay.comAd

Maintenance

ActivityInactive
ResponsivenessOutdated data

Resources

Related MCP Connectors

Related MCP Servers

  • Jewei MSSQL MCP Server

    jeweis
    A
    license
    Not graded
    quality
    C
    maintenance
    A FastMCP-based server that enables executing Microsoft SQL Server data queries and table structure queries through a standardized MCP protocol interface.
    7
    MIT

  • sqlserver-mcp-colossal

    JavianDev
    A
    license
    Not graded
    quality
    D
    maintenance
    A comprehensive MCP server for SQL Server database operations, enabling CRUD operations, schema exploration, and stored procedure execution through natural language.
    3 npm
    MIT

  • sap-mcp

    abap-studio
    A
    license
    Not graded
    quality
    B
    maintenance
    MCP server for SAP S/4HANA via the ADT API, enabling querying and reading SAP systems with production write protection.
    8 npm
    MIT

  • odatav4-mcp

    singlebarrel
    A
    license
    Not graded
    quality
    D
    maintenance
    An MCP server for OData v4 endpoints, especially Microsoft Dataverse/Dynamics 365, enabling authentication, schema discovery, querying, CRUD, and more via natural language.
    MIT