Ross ERP Data Dictionary
OnlineStructure-only reference for the vanilla Ross ERP 8.0 schema, UI menu tree, and program catalog.
What it can do: 21 tools
schema_statsOverview of the Ross ERP 8.0 schema in one call: object counts by type, module list, total/distinct columns, audit-twin pairs, and the top tables/columns/modules. Use this first to orient before drilling in.list_objectsBrowse and filter Ross ERP 8.0 objects (tables / views / procedures / functions). Filter by type, database, module, or a name substring; paginate with limit/offset. Returns object summaries — use lookup_table for full defind_columnLook up a single column by exact name across the whole Ross ERP 8.0 schema: its description, valid values, notes, every table that carries it, and any foreign-key roles it plays.lookup_tableFull schema for a Ross ERP 8.0 object (table / view / procedure / function): columns with type, nullability, keys, descriptions and valid values, foreign keys in and out, related tables, and usage.search_columnsSearch the Ross ERP 8.0 schema by name (and column descriptions). Returns matching objects and columns.search_allCross-domain search in one call — spans schema objects, columns, UI facilities and programs at once. Use this when you don't yet know which layer a term lives in (e.g. 'check register' is a screen, a program and a table)get_ddlReturn the CREATE TABLE (DDL) for a Ross ERP 8.0 table, with column descriptions as comments plus primary-key and foreign-key constraints.graph_neighborsList the knowledge-graph neighbours of an object — the programs, tables, views and procedures directly connected to it, with relationship type and direction.path_betweenFind the shortest path between two objects in the Ross ERP 8.0 knowledge graph (how A reaches B through calls / references / accesses).facility_statsOverview of the Ross ERP 8.0 application layer — the client menu tree of UI facilities (screens, reports, inquiries, maintenance functions): total facilities, and their breakdown by system (e.g. ACCOUNTS_PAYABLE), databalist_facilitiesBrowse and filter Ross ERP 8.0 UI facilities (menu screens/functions). Filter by system, database, class, a name/code substring, or withTables (only facilities whose table cluster is known); paginate with limit/offset. Rsearch_facilitiesSearch Ross ERP 8.0 UI facilities by code, name, help text, program or tag. Use this to find the screen/report for a task, e.g. 'check register' or 'purchase order receipts'.lookup_facilityFull detail for one Ross ERP 8.0 UI facility by code: its name, system, database, class, GEMBASE program, help text, menu paths, the physical table cluster it touches — core (the working set the screen is built on) and rtable_facilitiesReverse lookup: which UI facilities (screens/reports/programs) touch a given Ross ERP 8.0 table — split into core (facilities whose working set includes it) and reference (facilities that use it as a control/lookup), eacfacility_programsCross-link a UI facility to the program(s) that implement it — 'what code runs this screen?'. Each program carries a match label: declared (named by the facility's menu entry, authoritative) or titleId (TITLE id equals tprogram_statsOverview of the Ross ERP 8.0 program catalog — every application-source program (metadata only, no source body): total programs, how many declare a TITLE id, how many carry Data Dictionary table links, total program→tabllist_programsBrowse and filter Ross ERP 8.0 programs (application source, metadata only). Filter by module (ap, gl, ic, sop, ...), type (a=archive, i=inquiry, m=maintenance, r=report, s=server, l=load, u=utility, ...), layer (base |search_programsSearch Ross ERP 8.0 programs by basename, TITLE program-id, title, module or type. Use this to find the program behind a task, e.g. 'check register' or 'ap_a'.lookup_programFull detail for one Ross ERP 8.0 program, by TITLE program-id (e.g. AP_A_002) or source basename (e.g. ap_a_check_register): its module, type, layer, declared title, internal PROCEDURE_FORM procedures, the Data Dictionartable_programsReverse lookup: which standard Ross ERP 8.0 programs reference a given table (validated against the Data Dictionary). Answers 'what code touches this table?' — complements table_facilities (which answers 'what screens toprogram_facilitiesReverse of facility_programs: which UI facilities (menu screens / reports / inquiries) a program backs — 'what screens does this program run?'. One program often serves several facilities. Lookup by TITLE id (e.g. AP_I_0
Connect it
claude mcp add --transport http ross-erp-data-dictionary https://mcp.rossdata.dev/mcpSettings → Connectors → Add custom connector
URL: https://mcp.rossdata.dev/mcp{
"mcpServers": {
"ross-erp-data-dictionary": {
"url": "https://mcp.rossdata.dev/mcp"
}
}
}{
"servers": {
"ross-erp-data-dictionary": {
"type": "http",
"url": "https://mcp.rossdata.dev/mcp"
}
}
}Questions
What does Ross ERP Data Dictionary do?
Structure-only reference for the vanilla Ross ERP 8.0 schema, UI menu tree, and program catalog. It exposes 21 tools to AI assistants.
What tools does Ross ERP Data Dictionary provide?
21 tools, including schema_stats, list_objects, find_column, lookup_table, search_columns, search_all, get_ddl, graph_neighbors, path_between, facility_stats, list_facilities, search_facilities….
How do I connect Ross ERP Data Dictionary to Claude, ChatGPT or Cursor?
Add the remote MCP endpoint https://mcp.rossdata.dev/mcp as a custom connector or MCP server. Copy-paste setup is on this page.
Does Ross ERP Data Dictionary require an account or API key?
No sign-in was needed to list its tools. Individual tools may still need an account or API key.
Is Ross ERP Data Dictionary online?
As of 2026-11-19 our probe found it online. It answered 100% of our last 3 checks.
Who publishes Ross ERP Data Dictionary?
rossdata.dev. The official MCP Registry verified that the publisher controls this domain before accepting the listing.
Similar in Web Search & Scraping
-
HugeDomains: premium domain names for saleOnlineOfficialPopularNew
Search and price premium aftermarket domain names for sale on HugeDomains.com.
-
OxylabsOnlineOfficialPopular
Fetch and process content from specified URLs & sources using the Oxylabs Web Scraper API.
-
PadletOnline · sign-in requiredOfficialPopular
Read, search, create and edit Padlet boards: posts, sections, comments, settings and sharing.
-
Atom.com — Premium DomainsOnlineOfficialPopular
Search, appraise, trademark-check, and buy premium brandable domain names from Atom.com.
-
Dm Drogerie MarktOnlineOfficialPopular
Real-time product data, semantic search and more from dm-drogerie markt, Europe's leading drugstore.
-
ZolaOnlineOfficialNew
Find US wedding vendors, registry gifts and invitations, and Zola's wedding planning answers.