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_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 - not found

quality

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.

Tools

View all tools

Latest Blog Posts

Lightport: Open-Sourcing Glama's AI Gateway
By punkpeye on April 27, 2026.
open source
OpenAI
Tool Definition Quality Score (TDQS)
By punkpeye on April 3, 2026.
mcp
The Hackers Who Tracked My Sleep Cycle
By punkpeye on March 26, 2026.
security

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