Which integrations are available for this server?

Provides tools for interacting with PostgreSQL databases, enabling querying, schema inspection, and database administration.

How do I use agr_postgres_mcp?

1. Click on "Install Server". 2. Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state. 3. In the chat, type @ followed by the MCP server name and your instructions, e.g., "@agr_postgres_mcp Describe the users table" That's it! The server will respond to your query, and you can continue using it as needed. Here is a step-by-step guide with screenshots.

agr_postgres_mcp

Official

by alliance-genome

Overview Schema Related Servers Score Discussions

TypeScript

Local

agr_postgres_mcp

MCP server for interacting with PostgreSQL databases via psql. Designed for use with Claude Code as a Model Context Protocol (MCP) server.

Configuration

The server is configured entirely through environment variables:

Variable	Required	Default	Description
`PG_HOST`	Yes	—	PostgreSQL hostname
`PG_USER`	No	`postgres`	Database username
`PG_PASSWORD`	Yes	—	Database password
`PG_DATABASE`	Yes	—	Database name
`PG_PORT`	No	`5432`	Database port
`PG_SERVER_NAME`	No	`postgres`	MCP server name (used in logs and tool prefixes)
`PSQL_PATH`	No	auto-detect	Full path to the `psql` binary

If PSQL_PATH is not set, the server searches common locations:

/opt/homebrew/opt/postgresql@15/bin/psql
/opt/homebrew/opt/postgresql@13/bin/psql
/Applications/Postgres.app/Contents/Versions/15/bin/psql
/Applications/Postgres.app/Contents/Versions/14/bin/psql
/usr/local/bin/psql
/usr/bin/psql

Related MCP server: PostgreSQL MCP Server

Tools

Tool	Description
`query`	Execute arbitrary SQL with configurable output format (table/csv/expanded) and timeout
`list_tables`	List all tables in a schema
`describe_table`	Describe a table's columns, types, constraints, and indexes (`\d+` equivalent)
`list_indexes`	List indexes, optionally filtered by table
`table_sizes`	Show table sizes (data, index, total) sorted by size
`table_stats`	Show live/dead tuples, last vacuum/analyze times
`active_connections`	Show active database connections from `pg_stat_activity`
`locks`	Show current locks with blocking information
`explain`	Show query execution plan (`EXPLAIN` / `EXPLAIN ANALYZE`)
`database_size`	Show total database size and object counts
`row_counts`	Estimated row counts for all tables
`foreign_keys`	List foreign key constraints, optionally filtered by table
`index_usage`	Index scan statistics for identifying unused indexes
`schema_search`	Search for tables or columns by LIKE pattern

Setup

npm install
npm run build

MCP Configuration

Add an entry to .mcp.json for each database instance:

{
  "mcpServers": {
    "pg-alpha": {
      "type": "stdio",
      "command": "node",
      "args": ["/path/to/agr_postgres_mcp/dist/index.js"],
      "env": {
        "PG_SERVER_NAME": "alpha",
        "PG_HOST": "your-db-host.example.com",
        "PG_USER": "postgres",
        "PG_PASSWORD": "your-password",
        "PG_DATABASE": "your-database",
        "PSQL_PATH": "/path/to/psql"
      }
    }
  }
}

Multiple instances can be configured by adding additional entries with different PG_SERVER_NAME and PG_HOST values.

This server cannot be installed

license - not found

quality - not tested

maintenance

How are these scores calculated?

Maintenance

–Maintainers

–Response time

–Release cycle

–Releases (12mo)

Commit activity

Resources

GitHub Repository

Need Help?

Related Servers

Unclaimed servers have limited discoverability.

Looking for Admin?

If you are the server author, to access and configure the admin panel.

Related MCP Servers

PostgreSQL MCP Server
Databases Search
aadarshjain
A
license
-
quality
D
maintenance
Enables exploration and querying of PostgreSQL databases through natural language. Supports listing tables, viewing schemas, executing SELECT queries, filtering records, and retrieving database statistics.
Last updated 2025-06-30
2
MIT
PostgreSQL MCP Server
Databases Developer Tools
CyprianFusi
F
license
-
quality
D
maintenance
Enables interaction with PostgreSQL databases through resources, tools, and prompts for data analysis, including listing tables, executing read-only queries, and generating analysis workflows.
Last updated 2025-12-09
PostgreSQL MCP Server
Databases Developer Tools Data Platforms
az-coder-123
A
license
-
quality
D
maintenance
Enables LLMs to interact deeply with PostgreSQL databases—query data, manage schema, analyze performance, and administer the database.
Last updated 2026-03-23
180
4
MIT
PostgreSQL MCP Server
Databases Developer Tools
JimmyFu-Coder
F
license
-
quality
D
maintenance
Enables AI models to execute SQL queries, list tables, and describe table structures on a local PostgreSQL database.
Last updated 2025-10-24
8

View all related MCP servers

Related MCP Connectors

PlainQuery | MCP DB Agent
Query PostgreSQL databases in plain English — LLM-generated, safety-validated SQL.
pg-aiguide
Comprehensive PostgreSQL documentation and best practices, including ecosystem tools
PlanetScale
Connect to PlanetScale databases, branches, schema, query insights, and execute SQL

View all MCP Connectors

Latest Blog Posts

Who's Calling? MCP Hosts Are an Identity Blind Spot (And the Spec Knows It)
By Om-Shree-0709 on July 25, 2026.
mcp
Agent Identity
OAuth 2.1
Your AI Chatbot Just Exposed Your CEO's Salary to an Intern
By Om-Shree-0709 on July 2, 2026.
Agent Identity
MCP Security
OAuth Delegation
Why MCP Servers Need Execution Sandboxing (And Why Your Current Stack Isn't Enough)
By Om-Shree-0709 on June 30, 2026.
Agentic Ai
Prompt Injection
WebAssembly

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/alliance-genome/agr_postgres_mcp'

If you have feedback or need assistance with the MCP directory API, please join our Discord server