What can you do with this server?

This server provides high-privilege PostgreSQL administration capabilities focused on database, role, and grant management — without supporting raw SQL execution or schema/table operations. * Database Management: List, create, inspect, and change owners of PostgreSQL databases. Dropping a database requires a short-lived confirmation token. * Role Management: List, create, alter passwords/attributes, and drop PostgreSQL roles. SUPERUSER privileges are explicitly unsupported, and dropping roles requires a confirmation token. * Role Membership: Grant/revoke roles to/from other roles, and view memberships for a specific role. * Privilege Management: Grant/revoke database-level privileges to/from roles, and view grants for a role on a database. * Secure Destructive Actions: pg_drop_database and pg_drop_role are protected by short-lived, single-use confirmation tokens executed via pg_confirm_task. * Safety Guarantees: No raw SQL passthrough, and no management of schemas, tables, views, indexes, triggers, or functions.

Which integrations are available for this server?

Provides tools for managing PostgreSQL databases and roles, including creating, altering, and dropping databases and roles, as well as granting and revoking privileges.

How do I use easy-pg-admin-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., "@easy-pg-admin-mcp create a role named 'analyst' without login" 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.

easy-pg-admin-mcp

by chenkumi

Overview Schema Related Servers Score Discussions

TypeScript

Remote

easy-pg-admin-mcp

High-privilege PostgreSQL admin MCP server for database and role/grant management.

This project is a DBA-style tool. It does not provide raw SQL execution and does not manage tables, schemas, views, indexes, triggers, or functions. Use easy-pg-mcp for data access and schema/table operations.

Features

List, create, inspect, and change owners for databases
List, create, update, and drop PostgreSQL roles
Grant and revoke role memberships
Grant and revoke database-level privileges
Protect destructive actions with short-lived confirmation tokens

Related MCP server: PostgreSQL MCP Server

Available Tools

Tool	Description
`pg_list_databases`	List databases in the current PostgreSQL instance
`pg_create_database`	Create a PostgreSQL database
`pg_describe_database`	Inspect a PostgreSQL database
`pg_alter_database_owner`	Change a database owner
`pg_drop_database`	Request database deletion and return a confirmation token
`pg_list_roles`	List PostgreSQL roles
`pg_create_role`	Create a PostgreSQL role without SUPERUSER support
`pg_alter_role_password`	Change a role password
`pg_alter_role_attributes`	Change supported role attributes
`pg_drop_role`	Request role deletion and return a confirmation token
`pg_grant_role`	Grant a role to another role
`pg_revoke_role`	Revoke a role from another role
`pg_show_role_memberships`	Show memberships for a role
`pg_grant_privileges`	Grant database-level privileges to a role
`pg_revoke_privileges`	Revoke database-level privileges from a role
`pg_show_grants`	Show database-level grants for a role
`pg_confirm_task`	Confirm and execute a destructive action token

Safety

No raw SQL passthrough
No schema, table, view, index, trigger, or function management
SUPERUSER role creation and modification are not supported
pg_drop_database and pg_drop_role require pg_confirm_task
pg_drop_role does not support REASSIGN OWNED or DROP OWNED
Confirmation tokens are random, single-use, and expire quickly

Configuration

Use environment variables, matching the rest of the easy-*-mcp family.

Variable	Required	Default	Description
`PG_CONNECTION_STRING`	Conditional	-	PostgreSQL connection string. Takes precedence when provided
`PG_HOST`	Conditional	-	PostgreSQL host when no connection string is provided
`PG_PORT`	No	`5432`	PostgreSQL port
`PG_USER`	Conditional	-	PostgreSQL admin role name when no connection string is provided
`PG_PASSWORD`	No	-	PostgreSQL password
`PG_DATABASE`	Conditional	-	Default database used for the admin connection
`PG_CONNECTION_LIMIT`	No	`10`	Maximum number of active pool connections
`PG_CONNECTION_TIMEOUT`	No	`10000`	Connection establishment timeout in milliseconds
`PG_IDLE_TIMEOUT`	No	`30000`	Idle connection timeout in milliseconds
`PG_ENABLE_KEEP_ALIVE`	No	`true`	Whether TCP keep-alive is enabled
`PG_KEEP_ALIVE_INITIAL_DELAY`	No	`0`	Initial TCP keep-alive delay in milliseconds
`PG_SSL`	No	`false`	Use `true`, `false`, or `no-verify`
`PG_ADMIN_TOKEN_TTL_SECONDS`	No	`120`	Confirmation token lifetime in seconds

Example

PG_HOST=localhost
PG_PORT=5432
PG_USER=postgres
PG_PASSWORD=your_password
PG_DATABASE=postgres
PG_SSL=false
PG_ADMIN_TOKEN_TTL_SECONDS=120

Claude Desktop Example

{
  "mcpServers": {
    "easy-pg-admin-mcp": {
      "command": "npx",
      "args": ["-y", "easy-pg-admin-mcp"],
      "env": {
        "PG_HOST": "localhost",
        "PG_PORT": "5432",
        "PG_USER": "postgres",
        "PG_PASSWORD": "your_password",
        "PG_DATABASE": "postgres",
        "PG_SSL": "false",
        "PG_ADMIN_TOKEN_TTL_SECONDS": "120"
      }
    }
  }
}

Codex config.toml Example

[mcp_servers.easy-pg-admin-mcp]
args = ["-y", "easy-pg-admin-mcp"]
command = "npx"
enabled = true

[mcp_servers.easy-pg-admin-mcp.env]
PG_HOST = "localhost"
PG_PORT = "5432"
PG_USER = "postgres"
PG_PASSWORD = "your_password"
PG_DATABASE = "postgres"
PG_SSL = "false"
PG_ADMIN_TOKEN_TTL_SECONDS = "120"

OpenCode opencode.jsonc Example

{
  "$schema": "https://opencode.ai/config.json",
  "mcp": {
    "easy-pg-admin-mcp": {
      "type": "local",
      "command": ["npx", "-y", "easy-pg-admin-mcp"],
      "enabled": true,
      "environment": {
        "PG_HOST": "localhost",
        "PG_PORT": "5432",
        "PG_USER": "postgres",
        "PG_PASSWORD": "your_password",
        "PG_DATABASE": "postgres",
        "PG_SSL": "false",
        "PG_ADMIN_TOKEN_TTL_SECONDS": "120",
      },
    },
  },
}

Install Server

license - permissive license

quality

maintenance

How are these scores calculated?

Maintenance

–Maintainers

–Response time

–Release cycle

–Releases (12mo)

Commit activity

Resources

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.

Tools

View all tools

Related MCP Servers

mcp-psycopg2
Databases Developer Tools
daedalus
A
license
-
quality
C
maintenance
MCP server that exposes PostgreSQL database operations via psycopg2, including connection management, query execution, and transaction control.
Updated 4 months ago (2026-04-21 19:27 UTC)
MIT
PostgreSQL MCP Server
Databases Monitoring
foxter-io
A
license
A
quality
C
maintenance
Full-featured MCP server that exposes 36 tools for interacting with PostgreSQL databases, covering schema introspection, query execution, data exploration, performance monitoring, security auditing, and maintenance.
Updated 2 months ago (2026-06-18 20:16 UTC)
36
11
MIT
postgres-mcp-server
Databases Developer Tools
bysonte
A
license
A
quality
C
maintenance
Local MCP server for safe querying and inspecting PostgreSQL databases, with write and maintenance operations disabled by default.
Updated 2 months ago (2026-06-23 00:55 UTC)
8
42
1
ISC
postgres-mcp-readonly
Databases Developer Tools
mahin1995
A
license
A
quality
D
maintenance
A secure, read-only PostgreSQL MCP server that provides safe database introspection and querying capabilities.
Updated 3 months ago (2026-05-04 16:20 UTC)
14
12
MIT

View all related MCP servers

Related MCP Connectors

mcp
MCP server for managing Prisma Postgres.
Supabase
MCP server for interacting with the Supabase platform
mcp
Butterbase MCP server — manage your backend: schemas, auth, functions, storage, RAG, deploys.

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/chenkumi/easy-pg-admin-mcp'

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

easy-pg-admin-mcp

Features

Available Tools

Safety

Configuration

Example

Claude Desktop Example

Codex config.toml Example

OpenCode opencode.jsonc Example

Maintenance

Resources

Looking for Admin?

Tools

Related MCP Servers

mcp-psycopg2

PostgreSQL MCP Server

postgres-mcp-server

postgres-mcp-readonly

Related MCP Connectors

Latest Blog Posts

MCP directory API