AGE-MCP-Server

by rioriost

4 stars
229 downloads
Not rated
GitHub

About

A server for Apache AGE, a graph database extension for PostgreSQL.

Details

Author
rioriost
GitHub stars
4
Downloads
229
Categories
Database, Other

- Connects Claude / VS Code to Apache AGE on Azure PostgreSQL
- Supports read-only graph queries by default
- Optional --allow-write flag for graph mutations
- Compatible with Entra ID / Azure CLI authentication
- Uses psycopg as the database driver

Setting up with Highlight

This MCP is not yet compatible with Highlight’s one-click setup. However, you can still use it with Highlight by following these steps:

  1. Download and install Highlight from highlightai.com/download
  2. Navigate to the plugins tab and select "Add Custom Plugin"
  3. Configure the plugin with the settings below
    Plugin Name AGE-MCP-Server
    Command (node, npx, python, etc.)

    Please refer to the README for specific instructions on how to obtain API keys or other required environment variables.

  4. Enable "Start Automatically" if you want the plugin to start when Highlight launches

From the repository

Install via brew, uv, or pip (Python 3.13+ required). Configure your Claude Desktop or VS Code Insiders settings JSON with the command age_mcp_server and a --pg-con-str argument pointing to your Azure PostgreSQL database. Start the client; write operations are disabled by default—add --allow-write to enable them.

Claude Desktop / Cursor

Paste into your MCP client config file to install this server.

{
    "mcpServers": {
        "age-mcp-server": {
            "homebrew-age-mcp-server": {
                "command": "python3",
                "args": [
                    "-m",
                    "venv",
                    ".venv"
                ]
            }
        }
    }
}

McpServers

{
    "homebrew-age-mcp-server": {
        "command": "python3",
        "args": [
            "-m",
            "venv",
            ".venv"
        ]
    }
}

AGE-MCP-Server

Obsoleted

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

bash
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

bash
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.

json
{
"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:

json
{
"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:

json
{
"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=postgres user=your_username",
...
]
}
}
}

And, you need to set PGPASSWORD env variable, or to install Azure CLI and sign into Azure with your Azure account.

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, "Rio WORK at Microsoft"?
Delete the graph, MCP_Test

Claude on Windows

Usage with Visual Studio Code

After installing, [Preferences]->[Settings] and input mcp to [Search settings].

MCP Settings in Preferences

Edit the settings.json as followings:

json
{
"mcp": {
"inputs": [],
"servers": {
"age_manager": {
"command": "/Users/your_user_name/.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",
"--debug"
]
}
}
}
}

And then, you'll see start to start the AGE MCP Server.

Switch the Chat window to agent mode.

VSCode Agent

Now, you can play with your graph data via Visual Studio Code!

VSCode Agent

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.

json
{
"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"
]
}
}
}
```

For More Information

- Apache AGE : https://age.apache.org/
- GitHub : https://github.com/apache/age
- Document : https://age.apache.org/age-manual/master/index.html

License

MIT License

No reviews yet — be the first

Sign in to leave a review

Use Google, GitHub, or an email account so ratings stay tied to real people.

Email sign in

No reviews posted yet.