Navigation
AGE-MCP-Server: Seamless Scaling & Real-Time Insights - MCP Implementation

AGE-MCP-Server: Seamless Scaling & Real-Time Insights

Power your graph DBs with Apache AGE MCP Server—effortless scaling, real-time insights, and enterprise-grade automation that just works. No drama, all results." )

Research And Data
4.2(27 reviews)
40 saves
18 comments

Users create an average of 24 projects per month with this tool

About AGE-MCP-Server

What is AGE-MCP-Server: Seamless Scaling & Real-Time Insights?

AGE-MCP-Server is a middleware tool built on Apache AGE, designed to enable scalable graph database operations and real-time analytics. It provides a secure interface for querying and managing graph data, integrating seamlessly with tools like Claude for natural language interactions. Key capabilities include support for multi-graph environments, transactional safety, and compatibility with PostgreSQL-based graph systems.

How to Use AGE-MCP-Server: Seamless Scaling & Real-Time Insights?

Installation can be done via Homebrew or manual setup. Configure connection parameters using the --pg-con-str flag to link to your PostgreSQL instance. For advanced users, enable write operations with --allow-write to create, modify, or delete graph structures. Integrate with Claude by specifying the server as a data source and execute Cypher queries through natural language prompts.

AGE-MCP-Server Features

Key Features of AGE-MCP-Server: Seamless Scaling & Real-Time Insights?

  • Seamless Scaling: Supports distributed graph processing across multi-node PostgreSQL clusters.
  • Real-Time Analytics: Execute complex graph traversals and aggregations instantly through optimized Cypher execution.
  • Security Controls: Default write operation restrictions ensure data integrity unless explicitly enabled.
  • Multi-Graph Management: Maintain isolated graph instances for different use cases within a single PostgreSQL deployment.
  • Claude Integration: Translate natural language queries into precise Cypher operations for non-technical users.

Use Cases of AGE-MCP-Server: Seamless Scaling & Real-Time Insights?

Common applications include:

  • Customer relationship analysis via dynamic network exploration.
  • Supply chain optimization through real-time dependency mapping.
  • Social network analysis for influencer detection and trend forecasting.
  • Financial fraud detection using pattern matching on transaction graphs.

AGE-MCP-Server FAQ

FAQ: AGE-MCP-Server

1. How do I install AGE-MCP-Server?

Use Homebrew with brew install age-mcp or download binaries from the official release page.

2. Can I run write operations safely?

Write operations are disabled by default. Use --allow-write to enable them, ensuring proper access controls are in place.

3. Does it support multiple graphs?

Yes, each PostgreSQL schema represents a separate graph, allowing isolated environments for different projects.

4. What's the version compatibility?

Check the release notes for PostgreSQL and Apache AGE version mappings.

5. Which operating systems are supported?

Officially tested on macOS (via Homebrew) and Linux. Community support exists for Windows via WSL.

Content

AGE-MCP-Server

License Python

Apache AGE MCP Server

Apache AGE™ is a PostgreSQL Graph database compatible with PostgreSQL's distributed assets and leverages graph data structures to analyze and use relationships and patterns in data.

Azure Database for PostgreSQL is a managed database service that is based on the open-source Postgres database engine.

Introducing support for Graph data in Azure Database for PostgreSQL (Preview).

Table of Contents

  • Prerequisites
  • Install
  • Usage
  • Write Operations
  • Release Notes
  • For More Information
  • License

Prerequisites

  • Python 3.13 and above

  • This module runs on psycopg

  • Enable the Apache AGE extension in your Azure Database for PostgreSQL instance. Login Azure Portal, go to 'server parameters' blade, and check 'AGE" on within 'azure.extensions' and 'shared_preload_libraries' parameters. See, above blog post for more information.

  • Load the AGE extension in your PostgreSQL database.

    CREATE EXTENSION IF NOT EXISTS age CASCADE;

  • Claude Download from Claude Desktop Client or,

    brew install claude

For configuration, see Add the Filesystem MCP Server.

Install

  • with brew

    brew tap rioriost/age-mcp-server
    brew install age-mcp-server

  • with uv

    uv init your_project
    cd your_project
    uv venv
    source .venv/bin/activate
    uv add age-mcp-server

  • with python venv on macOS / Linux

    mkdir your_project
    cd your_project
    python3 -m venv .venv
    source .venv/bin/activate
    python3 -m pip install age-mcp-server

  • with python venv on Windows

    mkdir your_project
    cd your_project
    python -m venv venv
    .\venv\Scripts\activate
    python -m pip install age-mcp-server

Usage

  • on macOS claude_desktop_config.json is located in ~/Library/Application Support/Claude/.

  • on Windows You need to create a new claude_desktop_config.json under %APPDATA%\Claude.

  • Homebrew on macOS

Homebrew installs age-mcp-server into $PATH.

{
  "mcpServers": {
    "age-manager": {
      "command": "age-mcp-server",
      "args": [
        "--pg-con-str",
        "host=your_server.postgres.database.azure.com port=5432 dbname=postgres user=your_username password=your_password",
      ]
    }
  }
}
  • uv / Pyhon venv

On macOS:

{
  "mcpServers": {
    "age-manager": {
      "command": "/Users/your_username/.local/bin/uv",
      "args": [
        "--directory",
        "/path/to/your_project",
        "run",
        "age-mcp-server",
        "--pg-con-str",
        "host=your_server.postgres.database.azure.com port=5432 dbname=postgres user=your_username password=your_password",
      ]
    }
  }
}

On Windows:

{
  "mcpServers": {
    "age-manager": {
      "command": "C:\\Users\\USER\\.local\\bin\\uv.exe",
      "args": [
        "--directory",
        "C:\\path\\to\\your_project",
        "run",
        "age-mcp-server",
        "--pg-con-str",
        "host=your_server.postgres.database.azure.com port=5432 dbname=postgres user=your_username password=your_password",
      ]
    }
  }
}

After saving claude_desktop_config.json, start Claude Desktop Client.

Show me graphs on the server Show me a graph schema of FROM_AGEFREIGHTER Pick up a customer and calculate the amount of its purchase. Find another customer buying more than Lisa OK. Please make a new graph named MCP_Test Make a node labeled 'Person' with properties, name=Rio, age=52 Please make an another node labeled 'Company' with properties, name=Microsoft Can you put a relation, Delete the graph, MCP_Test

Claude on Windows

Write Operations

AGE-MCP-Server prohibits write operations by default for safety. If you want to enable write operations, you can use the --allow-write flag.

{
  "mcpServers": {
    "age-manager": {
      "command": "age-mcp-server",
      "args": [
        "--pg-con-str",
        "host=your_server.postgres.database.azure.com port=5432 dbname=postgres user=your_username password=your_password",
        "--allow-write"
      ]
    }
  }
}

Release Notes

0.2.3 Release

  • Dependency Update

0.2.2 Release

  • Drop a conditional test of CREATE operation by adding RETURN to the description for write-age-cypher tool.

0.2.1 Release

  • Fix a bug in node/edge creation

0.2.0 Release

  • Add multiple graph support
  • Add graph creation and deletion support
  • Obsolete --graph-name argument

0.1.8 Release

  • Add --allow-write flag

0.1.7 Release

  • Add Windows support

0.1.6 Release

  • Fix parser for RETURN values

0.1.5 Release

  • Draft release

0.1.4 Release

  • Draft release

0.1.3 Release

  • Draft release

0.1.2 Release

  • Draft release

0.1.1 Release

  • Draft release

0.1.0a1 Release

  • Draft release

For More Information

License

MIT License

Related MCP Servers & Clients