ORMCP Server MCP Server

[giscus[bot]]

ORMCP Server MCP Server

Database-agnostic MCP server that exposes relational databases as governed business objects (Customers, Orders, Products) for AI agents via ORM abstraction — instead of raw SQL or schema access. Works with any JDBC-compliant database (PostgreSQL, MySQL, Oracle, SQL Server, SQLite, and more). Reduces LLM token consumption by 60-70% through semantic data abstraction.

https://mcp.so/server/ormcp-server/SoftwareTree?tab=comments

[DamodarPeriwal]

ORMCP Server MCP Tools

ORMCP Server exposes the following MCP tools:

1. getObjectModelSummary — Get schema information about the object model including classes, attributes, primary keys, and relationships.
2. query — Query business objects of a specific type with optional filtering, sorting, and relationship traversal.
3. getObjectById — Retrieve a specific business object by its primary key with optional deep retrieval of referenced objects.
4. getAggregate — Calculate aggregate values (COUNT, SUM, AVG, MIN, MAX) across business objects with optional filtering.
5. access — Retrieve objects referenced by a specific attribute of a referencing business object.
6. insert — Save one or more business objects (JSON format) to the database.
7. update — Update one or more existing business objects with new values.
8. update2 — Bulk update business objects matching a filter condition.
9. delete — Delete specific business objects from the database.
10. delete2 — Bulk delete business objects matching a filter condition.

For full API reference see: https://github.com/softwaretree/ormcp-docs/blob/main/reference/ormcp_tools_reference.md