Skip to main content

PostgreSQL MCP

Project description

Apache AGE MCP Server

These tools provide an interface for AI Agents to manage multiple graphs in Apache AGE. They expose tools for creating, updating, administering, and visualizing graphs.

Tool Name Purpose/Description Arguments
get_or_create_graph Get or create a graph with the specified name. graph_name: str
list_graphs List all graph names in the database.
upsert_graph Upsert both vertices and edges into the specified graph (deep merge). graph_name: str, vertices: List[Dict[str, Any]], edges: List[Dict[str, Any]]
upsert_edge Insert or update an edge's properties in a graph non-destructively. graph_name: str, label: str, edge_start_ident: str, edge_end_ident: str, properties: Dict[str, Any]
upsert_vertex Insert or update a vertex's properties in a graph non-destructively. graph_name: str, vertex_ident: str, label: str, properties: Dict[str, Any]
drop_graphs Drop one or more graphs by name. graph_names: List[str]
drop_vertex Remove a vertex by ident. graph_name: str, vertex_ident: str
drop_edge Remove an edge by ident. graph_name: str, edge_ident: str
generate_visualization Generate a single-page HTML file visualizing a graph using vis.js and pyvis. graph_name: str

Server Setup

  1. Clone the repository:

    git clone <repository-url> /your/local/path/to/agemcp
    
  2. Navigate to the project directory:

    cd /your/local/path/to/agemcp
    
  3. Install the required dependencies:

    uv sync
    
  4. Run the server:

    uv run agemcp run --port 8000 --transport streamable-http
    

    You should see something like this:

    [07/30/25 14:32:54] INFO     Starting MCP server 'agemcp' with transport 'streamable-http' on http://0.0.0.0:8000/mcp/
    INFO:     Started server process [13951]
    INFO:     Waiting for application startup.
    INFO:     Application startup complete.
    INFO:     Uvicorn running on http://0.0.0.0:8000 (Press CTRL+C to quit)
    

Client Setup

VSCode

  1. Open Command Palette (Cmd+Shift+P or Ctrl+Shift+P).
  2. Select MCP: Add Server...
  3. Choose "HTTP" option.
  4. Enter the server URL (e.g., http://localhost:8000/mcp/).
  5. Enter a "server id" (e.g., agemcp).
  6. Select Global for the scope.
  7. Done. (It should appear in the extensions sidebar.)

Roo / Cline / Claude

{
  "mcpServers": {
    "agemcp": {
      "url": "http://localhost:8000/mcp/",
      "type": "streamable-http",
      "headers": {
        "Content-Type": "application/json"
      }
    }
  }
}

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

agemcp-0.1.0.tar.gz (59.1 kB view details)

Uploaded Source

Built Distribution

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

agemcp-0.1.0-py3-none-any.whl (51.7 kB view details)

Uploaded Python 3

File details

Details for the file agemcp-0.1.0.tar.gz.

File metadata

  • Download URL: agemcp-0.1.0.tar.gz
  • Upload date:
  • Size: 59.1 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/6.1.0 CPython/3.12.9

File hashes

Hashes for agemcp-0.1.0.tar.gz
Algorithm Hash digest
SHA256 bfdb274e497ba1456ed732f1d69fbce3534c174b5faa6c49073fb8d052e93b00
MD5 d4b1261f8862aceb3db5de11f404e81b
BLAKE2b-256 a026ff074f9bcc7967a1834fc4a84306eb866e578bfb2f7b229f63e383285c82

See more details on using hashes here.

File details

Details for the file agemcp-0.1.0-py3-none-any.whl.

File metadata

  • Download URL: agemcp-0.1.0-py3-none-any.whl
  • Upload date:
  • Size: 51.7 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/6.1.0 CPython/3.12.9

File hashes

Hashes for agemcp-0.1.0-py3-none-any.whl
Algorithm Hash digest
SHA256 4d70955c31f8117fd9c5f8de6dd1439adf2bbe7fc37afbb4e7c0f064d4fe308e
MD5 55547faf3b583824414b522a5faf6a48
BLAKE2b-256 266ca68592d991edabc8e58669f935c68b2bba73a71c0ac94f25affe1e1b7efe

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