Ross ERP Data Dictionary MCP Server

by rossdata Your server? Claim it

not responding

Ross ERP Data Dictionary is listed as active in the registry but did not answer our last check. It exposes 21 tools.

Structure-only reference for the vanilla Ross ERP 8.0 schema, UI menu tree, and program catalog.

Uptime history 91 days of history · worst day 0%

91 days agonow

1.1%

Uptime 24h

1 of 92 checks

Tools

read from the server

428 ms

Response time

average over 24h

open, no key

Access

streamable-http

What changed 8

Every tool that appeared, vanished or quietly changed what it asks for. Recorded since 16 August 2026. No other catalogue keeps this.

16 Aug 8 tool descriptions were rewritten facility_programs, list_programs, lookup_program and 5 more

Ross ERP Data Dictionary does not always answer

Over the last week it answered 16.4% of our checks. We check every 15 minutes, so you hear about the next outage within the hour — not from your users.

Connect this server

Endpoint below is the one we actually reach during checks — not the one copied from a README. Last verified 3 min ago.

Claude Code Claude Desktop Codex Cursor VS Code

run in your terminal

claude mcp add data-dictionary --transport http https://mcp.rossdata.dev/mcp

Settings → Connectors → Add custom connector, then paste this address

https://mcp.rossdata.dev/mcp

~/.codex/config.toml

[mcp_servers.data-dictionary]
url = "https://mcp.rossdata.dev/mcp"

.cursor/mcp.json

{
  "mcpServers": {
    "data-dictionary": {
      "url": "https://mcp.rossdata.dev/mcp"
    }
  }
}

.vscode/mcp.json

{
  "servers": {
    "data-dictionary": {
      "type": "http",
      "url": "https://mcp.rossdata.dev/mcp"
    }
  }
}

Available tools 21

Read directly from the server with tools/list, grouped by what they act on. If a tool disappears, we record the date.

lookup

lookup_facility

Full 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 reference (control/lookup tables) — and its call graph: the facilities this one invokes (calls) and the facilities that invoke it (calledBy), parsed from the program source.

lookup_program

Full 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 Dictionary tables it references — each classified read vs read-write (a write is a FIND IN.../LOCK=WRITE update, an ADD, or a DELETE) with a writeCount — its call graph (the programs it invokes and the programs that invoke it, from PERFORM "GEM<mod>:<prog>"), the menu facilities it backs, and — for programs with no TITLE label — a display name carried from the menu facility's registry description. Metadata only — no source body.

lookup_table

Full 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.

facilities

list_facilities

Browse 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. Returns summaries — use lookup_facility for full detail.

search_facilities

Search 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'.

facility

facility_programs

Cross-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 the facility code). Complements lookup_facility (which gives the facility's tables and call graph). Metadata only — no source body.

facility_stats

Overview 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), database (FIN/MAN) and class (REPORT, MAINTENANCE, INQUIRY, ...). Use this first to orient before browsing facilities.

program

program_facilities

Reverse 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_001) or basename (e.g. ap_i_vendors); each facility carries the same declared / titleId match label.

program_stats

Overview 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→table edges, read/write counts (withWrites programs, writeEdges program→table write edges), base vs vendor-core split, program→program call-graph counts (programs with outbound calls, total call edges) and how many back a menu facility, plus the module and type breakdowns. Use this first to orient before browsing programs.

programs

list_programs

Browse 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 | vendor-core), titled (only programs that declare a TITLE id), or a substring of basename/title; paginate with limit/offset. Returns summaries — use lookup_program for full detail.

search_programs

Search 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'.

table

table_facilities

Reverse 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), each with how many times the program source accesses it. Answers 'what screens read or write this table?'.

table_programs

Reverse 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 touch it?'). Metadata only — no source body.

all

search_all

Cross-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). Scope to one layer with type = object | column | facility | program (default all); limit is per domain.

column

find_column

Look 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.

columns

search_columns

Search the Ross ERP 8.0 schema by name (and column descriptions). Returns matching objects and columns.

ddl

get_ddl

Return the CREATE TABLE (DDL) for a Ross ERP 8.0 table, with column descriptions as comments plus primary-key and foreign-key constraints.

graph

graph_neighbors

List the knowledge-graph neighbours of an object — the programs, tables, views and procedures directly connected to it, with relationship type and direction.

objects

list_objects

Browse 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 detail.

path

path_between

Find the shortest path between two objects in the Ross ERP 8.0 knowledge graph (how A reaches B through calls / references / accesses).

schema

schema_stats

Overview 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.

Endpoints

URL	Transport	State	Latency	Checked
https://mcp.rossdata.dev/mcp	streamable-http	answering	96 ms	3 min ago

Alternatives to Ross ERP Data Dictionary

same job, measured the same way

Nori Reports

by nori

Nori ERP reports: data dictionary, read-only SQL, saved reports and PDF print formats.

answering

RCSB PDB

by rcsb

MCP server to search, inspect, and cross-reference RCSB Protein Data Bank structures

535 installs/wk local only

Archery MCP

by itzhouq

Read-only MCP server for the Archery SQL audit platform: production schema and release SQL checks

183 installs/wk local only

GlanceAI Fashion MCP

by glance

Fashion product discovery and virtual try-on via the Glance catalog

8 tools answering

ClearMarket

by clearmarket

Reference data for prediction markets: graded resolution clarity, cross-venue links, provenance.

6 tools answering

Kelvin — power electronics components

by openconverters

Read-only parts catalogue for power electronics: search, selection, cross-reference.

7 tools answering

Skillcheck

by cloudcorprecords

SKILL.md validator: frontmatter, structure, links, and referenced files checked.

132 installs/wk local only

Dictionary of Applied Machine Learning

by dictionaryofml

Look up, search and cross-reference machine-learning terms from dictionaryofml.org.

6 tools answering

Ross ERP Data Dictionary — questions

Answers built from our own checks of this server.

What can Ross ERP Data Dictionary do?

It exposes 21 tools, read directly from the server on our last check. Among them: facility_programs, facility_stats, find_column, get_ddl, graph_neighbors, list_facilities and 15 more. The full list with descriptions is on this page — we take it from the server itself via tools/list, not from a README. How MCP servers expose tools in the first place →

What is Ross ERP Data Dictionary mostly used for?

Its tools cluster around lookup, facilities and programs. That is what this server is built to work with — the grouping comes from the actual tool names, not from a category we assigned.

Is Ross ERP Data Dictionary working right now?

We send a real MCP handshake every 15 minutes. Over the last 24 hours 1 of 92 checks got a reply (1.1%), average response time 428 ms. The bar chart above shows every period we have measured.

The registry lists Ross ERP Data Dictionary as active — why does it not respond?

The official MCP registry stores what the author submitted; it does not verify that the server still runs. We check the endpoint ourselves, and this one does not answer. Catalogues that copy the registry without checking will show it as working.

How do I connect Ross ERP Data Dictionary?

Copy the ready config from this page. We generate it for Claude Code, Claude Desktop, Codex, Cursor and VS Code, each in the form that client actually reads. It is a remote server, so there is nothing to install — the client connects to the address.

Does Ross ERP Data Dictionary need an API key?

No. Ross ERP Data Dictionary completed a full MCP handshake with us as an anonymous client and listed its tools without asking for anything. All 21 of them are readable on this page. This is what we observed, not what the docs claim.

How fast is Ross ERP Data Dictionary?

It answers our handshake in 428 ms on average, which is faster than 29% of all working MCP servers we measure. The comparison comes from our own checks across the whole registry, every 15 minutes.