Data Dictionary
Every table, column, key and relationship — searchable.
An interactive reference for the whole vanilla Ross ERP 8.0 schema (FIN + MAN). Column descriptions, valid-value lists and foreign keys come from the GEMBASE application dictionary; additional relationships are inferred from shared key columns.
- Every table, view, procedure and function — searchable, filterable by type, class, module, DB
- Per-column: type, nullability, PK / identity / computed badges, description, valid values, FKs
- Foreign keys in and out, plus inferred related tables (shared-key)
- ER "neighborhood" diagram for each table
- One-click exports: CSV and JSON per table; copy SELECT and CREATE TABLE (DDL)
- Insights: module coupling, most-depended-on tables, schema-wide stats
- Keyboard-driven (
/search,?help), deep-linkable —dd.rossdata.dev/#GLLEDGER
Search or filter to an object → open it → read its columns, keys and relationships → export or copy what you need → jump to the same object in the Knowledge Graph.
Open the Data DictionaryKnowledge Graph
See the schema as a living map you can explore.
The same schema rendered as an interactive graph — objects as nodes, relationships and code references as edges — so you can see the structure the dictionary lists in tables.
- Force-directed map of the schema + code layer, grouped into modules and communities
- Path-finding between any two objects — "how does A reach B?"
- Hub / most-connected detection; filter by object type
- Deep-linkable focus on any node; one-click jump to the Data Dictionary entry
Start from a module or search a node → follow edges to see what connects → find the path between two objects → click through to the Dictionary for the detail.
Explore the Knowledge GraphOn the way
Programmatic access to the same dataset.REST API
Coming soonA REST / JSON API for the Data Dictionary — the same structured data the site exports, programmatically. GET a table's full schema as JSON, look up any column, search objects, fetch DDL — the same shape as the per-table JSON export.
MCP server
Coming soonA single MCP server that connects agents and tools directly to this dataset — both the Dictionary (look up tables, columns, DDL) and the Knowledge Graph (traverse relationships, find paths). One connector, both capabilities.
lookup_table
search_columns
get_ddl
graph_neighbors
path_between