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.

Try without installing — cloud.revisium.io

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.

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

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

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

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.

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

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

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
}

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

┌─────────────────────────────────────────────────────────┐
│                   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)      │
└───────────┴───────────┴───────────┴─────────────────────┘

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

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

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

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

See ENV.md for all environment variables.

• 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)

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