AGE-MCP-Server

Obsoleted

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 with Claude
• Usage with Visual Studio Code Insiders
• Write Operations
• 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

• Visual Studio Code Insiders Download from Visual Studio Code or,

brew intall visual-studio-code

Install

• with brew

brew intall rioriost/tap/age_mcp_server

- with uv

```bash
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 with Claude

• 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",
      ]
    }
  }
}

If you need to hide the password or to use Entra ID, you can set --pg-con-str as follows.

{
  "mcpServers": {
    "age_manager": {
        ...
        "--pg-con-str",
        "host=your_server.postgres.database.azure.com port=5432 dbname=pos

... [View full README on GitHub](https://github.com/rioriost/age_mcp_server#readme)