Documentation for ORMCP - An MCP Server for bridging AI and Database
Example of a RESTful Gilhari microservice providing ORM for JSON objects of User class
Database-to-AI automation: reverse-engineer, package as REST microservice, connect to AI agents via MCP.
A RESTful Gilhari microservice demonstrating ORM for JSON objects with an e-commerce application object model having one-to-one and one-to-many relationships (using PostgreSQL)
A RESTful Gilhari microservice demonstrating ORM for JSON objects with one-to-one and one-to-many BYVALUE (Cascade) relationships and advanced query capabilities
Introduces JDX ORM JSON-based persistence: a JSON_Employee class extends JDX_JSONObject with only two constructors; all attribute storage uses the JSONObject API. The ORM mapping uses VIRTUAL_ATTRIB declarations. Employees can be built from put calls, a JSONObject, or a raw JSON string.
A RESTful Gilhari microservice demonstrating ORM for JSON objects with basic CRUD operations, filtering, and aggregate queries
Like JDX_ReverseEngineeringExample but generates JSON-capable container classes extending JDX_JSONObject instead of POJOs, and produces a JSON-aware .revjdx mapping using VIRTUAL_ATTRIB. Compatible with JDX ORM, Gilhari ORM, and MCP server deployments.
A smart inventory watchdog AI Agent that monitors your e-commerce inventory 24/7. Built Using LangChain/LangGraph, GPT, Gmail, ORMCP, and PostgreSQL. ORMCP is an MCP Server providing object-oriented abstractions over relational data.
Demonstrates JDX ORM object streaming — retrieving large query results in incremental batches using QFLAG_STREAM, queryFetch, and queryClose rather than loading everything into memory at once. Must be run inside a transaction; shows both a full-table stream and a filtered, ordered stream.
Shows how JDX ORM calls stored procedures via storedProc and maps results back to Java objects or scalar values. Five stored procedures are demonstrated: returning object lists, filtered objects, a count, an update count, and a computed scalar — all declared in the .jdx mapping file. This example uses MySQL stored procedures.
Introductory JDX ORM example demonstrating CRUD operations on a basic Java domain class ClassA using SQLite or MySQL. Shows schema auto-creation, queries with filters and ordering, and the JDXHelper convenience API — no manual SQL required.
A RESTful Gilhari microservice demonstrating ORM for JSON objects with database-generated primary keys (autoincrement IDs)
An example to migrate a flight management system's data from Oracle database to PostrgreSQL using an AI agent and ORMCP
A RESTful Gilhari microservice demonstrating ORM for JSON objects with INLINE mapping for storing child object attributes in parent's table row
An Investigation Across Two MCP Servers, Two Frontier Models, and 20 Controlled Benchmark Runs
A RESTful Gilhari microservice demonstrating ORM for JSON objects with many-to-many relationships
A RESTful Gilhari microservice demonstrating ORM for JSON objects with one-to-many relationships
To associate your repository with the jdx topic, visit your repo's landing page and select "manage topics."