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 | Description | Parameters |
|---|---|---|
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 Installation
Install the latest release using pipx (recommended for CLI/server tools):
# Install
pipx install agemcp
# Postgres DSN / MCP Server Defaults
agemcp config
# Start the server
agemcp run
You should see something like this:
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 Installation
VSCode
- Open Command Palette (Cmd+Shift+P or Ctrl+Shift+P).
- Select
MCP: Add Server... - Choose "HTTP" option.
- Enter the server URL (e.g.,
http://localhost:8000/mcp/). - Enter a "server id" (e.g.,
agemcp). - Select
Globalfor the scope. - Done. (It should appear in the
extensionssidebar.)
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.5.3.tar.gz
(61.1 kB
view details)
Built Distribution
Filter files by name, interpreter, ABI, and platform.
If you're not sure about the file name format, learn more about wheel file names.
Copy a direct link to the current filters
agemcp-0.5.3-py3-none-any.whl
(54.3 kB
view details)
File details
Details for the file agemcp-0.5.3.tar.gz.
File metadata
- Download URL: agemcp-0.5.3.tar.gz
- Upload date:
- Size: 61.1 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/6.1.0 CPython/3.12.9
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
95f44bed2fbcabb5449c22f41c31d160696fab464fcaf11060562d54c7e9a974
|
|
| MD5 |
5ad51e2a1f49e01fb5c4cf6a44a9c74f
|
|
| BLAKE2b-256 |
16ac6dda1b8dc2c8318df127aeba478dfed3de59ab31a040a0e3fbb324121159
|
File details
Details for the file agemcp-0.5.3-py3-none-any.whl.
File metadata
- Download URL: agemcp-0.5.3-py3-none-any.whl
- Upload date:
- Size: 54.3 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/6.1.0 CPython/3.12.9
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
69ff7a1f3a78c2166479b00ec2c76a7e6c0502930015262c4f602c4155e46d59
|
|
| MD5 |
8ade4fb8015f74954ce81d83bba6ae05
|
|
| BLAKE2b-256 |
6ca09a2e0d8f73a219b6dd173b94c6d2d0f009f65c3d6598240cf33d5160c50c
|