Skip to main content

Apache AGE MCP Server

Project description

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

  • 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;
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",
        "--graph-name",
        "FROM_AGEFREIGHTER",
      ]
    }
  }
}
  • 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",
        "--graph-name",
        "FROM_AGEFREIGHTER",
      ]
    }
  }
}

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",
        "--graph-name",
        "FROM_AGEFREIGHTER",
      ]
    }
  }
}

After saving claude_desktop_config.json, start Claude Desktop Client.

Show me a graph schema Can you pick up a customer and calculate the sum of purchases? Can you find another customer buying more than Lisa? Can you find another product that Lisa didn't buy? Can you add a fact that Lisa bought a product, ID 10?

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",
        "--graph-name",
        "FROM_AGEFREIGHTER",
        "--allow-write"
      ]
    }
  }
}

Release Notes

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

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

age_mcp_server-0.1.8.tar.gz (1.8 MB view details)

Uploaded Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

age_mcp_server-0.1.8-py3-none-any.whl (8.7 kB view details)

Uploaded Python 3

File details

Details for the file age_mcp_server-0.1.8.tar.gz.

File metadata

  • Download URL: age_mcp_server-0.1.8.tar.gz
  • Upload date:
  • Size: 1.8 MB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: uv/0.6.6

File hashes

Hashes for age_mcp_server-0.1.8.tar.gz
Algorithm Hash digest
SHA256 ff48be1e3b9d04b052e6803fe54bcf315df3b8f9d105bd6143cd648610f29f77
MD5 69266984aac78dfb46ba33587b319193
BLAKE2b-256 9eb482c22ed520a94cef07c7d104ae4f519d558389717a41416defd075a71ca5

See more details on using hashes here.

File details

Details for the file age_mcp_server-0.1.8-py3-none-any.whl.

File metadata

File hashes

Hashes for age_mcp_server-0.1.8-py3-none-any.whl
Algorithm Hash digest
SHA256 ae4867ffb6fb23a879df8e100831c96a04b3eb9a58533c5a3dd990e76aa6c954
MD5 0d5395c9f29225eb899e2d4def6cf310
BLAKE2b-256 fb6a5f08667c634304445b4f40f92043cf992dc58396e07e496e655ee31e3aa8

See more details on using hashes here.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Depot Continuous Integration Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page