# Ross ERP Data Dictionary (remote · mcp.rossdata.dev)

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

- Trust score: 67/100 (medium)
- Registry status: active
- Liveness: live
- Owner verified: no
- Last scored: 2026-08-06

## Components

- remote · `mcp.rossdata.dev`: 67/100 (this document), [markdown](https://verifymcp.io/servers/dev-rossdata-data-dictionary/mcp.md), [page](https://verifymcp.io/servers/dev-rossdata-data-dictionary/mcp)

## Channel facts

- Endpoint: `https://mcp.rossdata.dev/mcp`
- Transports: `streamable-http`
- Auth: `none`
- Version: `1.0.0`

## Trust breakdown

How this component scores in each security and reliability category. Every signal is checked automatically against the live server, and we only credit what we can confirm. Scores are 0–100 per category. Scoring method: https://verifymcp.io/docs/scoring (what has changed: https://verifymcp.io/docs/scoring/changelog)

Scored 2026-08-06.

- **Endpoint Security**: 63/100
  - The endpoint's TLS certificate is valid, in date, and uses a strong key.
  - Authorisation not fully verified: no authorisation is required to call this server, and 21 tool(s) never declared a destructiveHint. The MCP spec treats an absent hint as destructive by default, so we cannot call this surface safe.
  - HTTPS is enforced; there's no plaintext access path.
  - The HSTS (Strict-Transport-Security) header is present.
  - DNSSEC check failed: this domain isn't protected by DNSSEC.
- **Transport & Reachability**: 100/100
  - Verified streamable-http transport via a live MCP handshake.
- **Schema Quality & AI Usability**: 77/100
  - AI-judged instruction clarity (excellent).
  - Context-footprint check failed: tool/resource definitions use about 2594 tokens (~123/item across 21 items; 21 tools + 0 resources), over budget; trim descriptions and params.
  - Usage-examples check failed: none of the tools include examples.
- **Stability & Change Management**: 7/100
  - Stability observed for 2 of 30 days with no destabilising changes; credit accrues until the full window elapses.
- **Tool Coverage**: 100/100
  - 100% of tools have a non-trivial description (not blank, and not just the tool's name).
  - 100% of tool parameters carry a description.
- **Capabilities**: 100/100
  - Implements a supported MCP spec version (2025-11-25); the latest is 2026-07-28.

## Install

### Claude

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

### Codex

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

### opencode

```json
{
  "$schema": "https://opencode.ai/config.json",
  "mcp": {
    "dev-rossdata-data-dictionary": {
      "type": "remote",
      "url": "https://mcp.rossdata.dev/mcp",
      "enabled": true
    }
  }
}
```

### OpenClaw

```bash
openclaw mcp add dev-rossdata-data-dictionary --url https://mcp.rossdata.dev/mcp --transport streamable-http
```

### Hermes

```yaml
mcp_servers:
  dev-rossdata-data-dictionary:
    url: "https://mcp.rossdata.dev/mcp"
```

### Other

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

The mcpServers block is a cross-client convention. Remote transports vary, so check your client's docs.

## Changelog

Every change recorded for this component, newest first. Days that predate change tracking, or that we cannot explain, say so: "we were watching and nothing happened" and "we were not watching" are different claims.

### 2026-08-06 (score 67, +1)

No change was recorded against any check on this day. Stability & Change Management went from 3 to 7. That category is still filling its 30-day observation window: 1 days of observed history at the previous scan, 2 at this one. The score rises as the window fills, whether or not the server changes.

### 2026-08-05 (score 66, 0)

- [functional improvement] Stability: unverified → 0.03

### 2026-08-04 (score 66)

First indexed and scored.

## MCP tools (21)

### `schema_stats` (~57 tokens)

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.

### `list_objects` (~148 tokens)

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.

Input parameters:

- `db` (string): Database filter, e.g. FIN or MAN
- `limit` (integer): Max objects (default 100)
- `module` (string): Module filter, e.g. GL or PO
- `offset` (integer): Pagination offset (default 0)
- `q` (string): Name substring filter, e.g. GL_
- `type` (string): Object type filter: table | view | procedure | function

### `find_column` (~68 tokens)

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.

Input parameters:

- `name` (string, required): Column name, e.g. POSTING_DATE or GL_ACCOUNT

### `lookup_table` (~74 tokens)

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.

Input parameters:

- `name` (string, required): Object name, e.g. GL_ACCOUNTS or ACCOUNT_TYPES

### `search_columns` (~65 tokens)

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

Input parameters:

- `limit` (integer): Max results per group (default 25)
- `query` (string, required): Search text, e.g. posting_date or GL_ACCOUNTS

### `search_all` (~142 tokens)

Cross-domain search in one call — spans schema objects, columns, UI facilities and vanilla 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.

Input parameters:

- `limit` (integer): Max results per domain (default 25)
- `query` (string, required): Search text, e.g. check register or posting_date
- `type` (string): Restrict to one domain (default all). 'table' is accepted as an alias for object.

### `get_ddl` (~56 tokens)

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

Input parameters:

- `name` (string, required): Table name, e.g. GL_ACCOUNTS

### `graph_neighbors` (~67 tokens)

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

Input parameters:

- `limit` (integer): Max neighbours (default 100)
- `name` (string, required): Object name, e.g. GL_ACCOUNTS

### `path_between` (~57 tokens)

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

Input parameters:

- `from` (string, required): Start object name
- `to` (string, required): Destination object name

### `facility_stats` (~86 tokens)

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.

### `list_facilities` (~195 tokens)

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.

Input parameters:

- `class` (string): Class filter: REPORT | MAINTENANCE | INQUIRY | UPDATE | TRANSACTION | ARCHIVE | CODES
- `database` (string): Database filter: FIN or MAN
- `limit` (integer): Max facilities (default 100)
- `offset` (integer): Pagination offset (default 0)
- `q` (string): Name or code substring, e.g. CHECK or AP_
- `system` (string): System filter, e.g. ACCOUNTS_PAYABLE or GENERAL_LEDGER
- `withTables` (boolean): Only facilities with a known table cluster (default false)

### `search_facilities` (~85 tokens)

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

Input parameters:

- `limit` (integer): Max results (default 25)
- `query` (string, required): Search text, e.g. check register or AP_A

### `lookup_facility` (~116 tokens)

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.

Input parameters:

- `code` (string, required): Facility code, e.g. AP_A_002

### `table_facilities` (~98 tokens)

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

Input parameters:

- `table` (string, required): Table name, e.g. GL_ACCOUNTS

### `facility_programs` (~102 tokens)

Cross-link a UI facility to the vanilla 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.

Input parameters:

- `code` (string, required): Facility code, e.g. AP_A_002

### `program_stats` (~122 tokens)

Overview of the Ross ERP 8.0 program catalog — every vanilla 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.

### `list_programs` (~240 tokens)

Browse and filter Ross ERP 8.0 vanilla 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.

Input parameters:

- `layer` (string): Source layer: base | vendor-core
- `limit` (integer): Max programs (default 100)
- `module` (string): Module filter, e.g. ap, gl, ic, sop
- `offset` (integer): Pagination offset (default 0)
- `q` (string): Substring of basename or title, e.g. check_register
- `titled` (boolean): Only programs that declare a TITLE program-id (default false)
- `type` (string): Program-type letter, e.g. r (report), m (maintenance), i (inquiry), s (server)

### `search_programs` (~86 tokens)

Search Ross ERP 8.0 vanilla 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'.

Input parameters:

- `limit` (integer): Max results (default 25)
- `query` (string, required): Search text, e.g. check register or AP_A_002

### `lookup_program` (~187 tokens)

Full detail for one Ross ERP 8.0 vanilla 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.

Input parameters:

- `id` (string, required): Program id or basename, e.g. AP_A_002 or ap_a_check_register

### `table_programs` (~79 tokens)

Reverse lookup: which vanilla 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.

Input parameters:

- `table` (string, required): Table name, e.g. GL_ACCOUNTS

### `program_facilities` (~107 tokens)

Reverse of facility_programs: which UI facilities (menu screens / reports / inquiries) a vanilla 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.

Input parameters:

- `id` (string, required): Program id or basename, e.g. AP_I_001 or ap_i_vendors

## Diagnostics

Captured diagnostic sections: TLS, DNSSEC, Authorisation, Transports. The full working is on the page: https://verifymcp.io/servers/dev-rossdata-data-dictionary/mcp#diagnostics

## Score history

- 2026-08-06: 67
- 2026-08-05: 66
- 2026-08-04: 66

## Links

- Remote endpoint: https://mcp.rossdata.dev/mcp
- Website: https://rossdata.dev/
- Changelog RSS feed: https://verifymcp.io/servers/dev-rossdata-data-dictionary/mcp.xml
- Changelog JSON feed: https://verifymcp.io/servers/dev-rossdata-data-dictionary/mcp.json
- HTML version of this page: https://verifymcp.io/servers/dev-rossdata-data-dictionary/mcp