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.
An Investigation Across Two MCP Servers, Two Frontier Models, and 20 Controlled Benchmark Runs
A RESTful Gilhari microservice demonstrating ORM for JSON objects with database-generated primary keys (autoincrement IDs)
A RESTful Gilhari microservice demonstrating ORM for JSON objects with INLINE mapping for storing child object attributes in parent's table row
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 one-to-many relationships
A RESTful Gilhari microservice demonstrating ORM for JSON objects with many-to-many relationships
To associate your repository with the jdx topic, visit your repo's landing page and select "manage topics."