What is Revisium

Revisium is an unopinionated microservice for structured JSON data with relational integrity, schema enforcement, auto-generated APIs, Git-like versioning, and a built-in Admin UI — from schema design to change review. The platform does not impose a fixed data model — schema is designed to fit the project's needs, from flat key-value to deeply nested hierarchies.

Managed through Admin UI, GraphQL API, REST API, MCP Protocol, or any combination.

Key Features

Quick Start

Cloud

Try without installing — cloud.revisium.io

Standalone (no dependencies)

npx @revisium/standalone@latest

Open http://localhost:9222 — no auth by default, --auth to enable (login: admin / admin).

Embedded PostgreSQL, zero configuration. Perfect for local development and AI agent integrations.

See @revisium/standalone README for all CLI options, MCP setup, and authentication details.

For production deployment (Docker Compose, Kubernetes), see Deployment Options.

Use Cases

Headless CMS

Content managed in Revisium (Admin UI or API), consumed by frontends via auto-generated REST/GraphQL. Branches for staging/production, drafts for editorial workflow.

Dictionary / Master Data

Single source of truth for reference data (currencies, categories, product specs) shared across microservices. Foreign keys guarantee consistency.

Configuration Store

Application settings, feature flags, pricing rules as versioned JSON. Draft → review → commit workflow. Branches for dev/staging/prod environments.

AI Agent Memory

Structured memory for AI agents (Claude Code, Cursor, custom). Typed schemas, version control, rollback on corruption. Human review of agent-written data via Admin UI. MCP Protocol support built-in.

Game Data & Complex Domains

Items, characters, quests with rich relationships. Schema validation, computed fields (40+ formula functions), file attachments via S3.

Data Model

Organization
  └── Project
        └── Branch (master, staging, dev)
              └── Revision (immutable snapshot) / Draft (WIP)
                    └── Table (JSON Schema)
                          └── Row (id + data)

Example: e-commerce with foreign keys and computed fields

Table categories — row id: "electronics"

{
  "name": "Electronics",
  "description": "Smartphones, laptops, accessories"
}

Table products — row id: "iphone-16"

{
  "title": "iPhone 16 Pro",
  "category": "electronics",         // ← FK → categories
  "price": 999,
  "quantity": 50,
  "total": 49950,                    // ← computed: price * quantity
  "inStock": true,                   // ← computed: quantity > 0
  "specs": {
    "weight": 199,
    "tags": ["5G", "USB-C"]
  },
  "relatedProducts": ["macbook-m4"]  // ← array of FK → products
}

Example: GraphQL query on auto-generated API

query {
  products(
    where: { category: { eq: "electronics" } }
    orderBy: { price: DESC }
    first: 10
  ) {
    edges {
      node {
        id
        title
        price
        category {
          name  # Auto-resolved via foreignKey
        }
      }
    }
  }
}

Architecture

┌─────────────────────────────────────────────────────────┐
│                   revisium (this repo)                  │
│              All-in-one self-hosted package             │
├─────────────────┬─────────────────┬─────────────────────┤
│  @revisium/core │ @revisium/admin │ @revisium/endpoint  │
│  Backend API    │  Web UI         │  API generator      │
├─────────────────┴─────────────────┴─────────────────────┤
│                     API Layer                           │
├───────────┬───────────┬───────────┬─────────────────────┤
│  GraphQL  │  REST API │    MCP    │   Generated APIs    │
│           │           │           │  (GraphQL + REST)   │
├───────────┴───────────┴───────────┴─────────────────────┤
│                  Infrastructure                         │
├───────────┬───────────┬───────────┬─────────────────────┤
│ PostgreSQL│   Redis   │    S3     │       SMTP          │
│ (required)│ (optional)│ (optional)│     (optional)      │
└───────────┴───────────┴───────────┴─────────────────────┘

Ecosystem

Platform

Package	Description	Quality
revisium	All-in-one self-hosted deployment
@revisium/core	Backend API — GraphQL, REST, MCP
@revisium/admin	Web UI — schema editor, data management, diff viewer
@revisium/endpoint	Auto-generated GraphQL + REST APIs

Libraries

Package	Description	Quality
@revisium/schema-toolkit	JSON Schema engine — validation, diff, patch, migrations
@revisium/schema-toolkit-ui	Schema / Row / Table editors for React
@revisium/formula	Formula expression engine — 40+ built-in functions
@revisium/prisma-pg-json	PostgreSQL JSON query builder for Prisma
@revisium/client	TypeScript API client

Tools & Integrations

Package	Description	Quality
@revisium/mcp-memory	MCP server for AI agent memory
revisium-cli	Schema migration CLI — save & apply across environments

Dependency Graph

revisium (self-hosted)
├── @revisium/core
│   ├── @revisium/schema-toolkit
│   │   └── @revisium/formula
│   └── @revisium/prisma-pg-json
├── @revisium/admin
│   ├── @revisium/schema-toolkit-ui
│   │   ├── @revisium/schema-toolkit
│   │   └── @revisium/formula
│   └── @revisium/formula
└── @revisium/endpoint
    └── @revisium/schema-toolkit

@revisium/mcp-memory ──► @revisium/client
revisium-cli ──► @revisium/client + @revisium/schema-toolkit

Configuration

See ENV.md for all environment variables.

Deployment Options

Requirements

• PostgreSQL 14+
• Node.js 20+ (for standalone and CLI only)
• S3-compatible storage (optional, for file uploads)
• Redis (optional, for caching and multi-pod sync)

License

Apache 2.0 — see LICENSE. Some packages (e.g. @revisium/core) include enterprise features under the Revisium Enterprise License in their ee/ directories.