What can you do with this server?

A production-oriented MCP server that enables interaction with PostgreSQL databases, providing tools for query execution and schema introspection: * execute_query: Run any SQL statement (SELECT, INSERT, UPDATE, DELETE) and receive result rows or the affected row count. * list_tables: Discover all tables in the current database, with an optional filter by schema name. * describe_table: Inspect a table's full structure — column names, data types, nullability, default values, and primary key markers. * list_databases: Retrieve all PostgreSQL databases available on the connected server. * get_table_indexes: View all indexes on a specific table, including their definitions and uniqueness/primary key flags. * get_foreign_keys: Discover all foreign key constraints on a table, including referenced target tables and columns.

Which integrations are available for this server?

Provides tools to execute SQL queries, list tables, describe table schemas, list databases, get table indexes, and foreign keys for a PostgreSQL database.

How do I use mcp-postgresql?

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., "@mcp-postgresql list all tables in the public schema" 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.

de en es ja ko ru zh

mcp-postgresql

by ferronicardoso

Overview Schema Related Servers Score Discussions

JavaScript

Remote

MCP Server for PostgreSQL

Docker Publish GHCR Node.js

Production-oriented MCP server for PostgreSQL, exposing database operations to MCP clients (Claude Desktop, VS Code Copilot, Cursor, and compatible hosts).

Features

Query execution (SELECT, INSERT, UPDATE, DELETE)
Database discovery and schema introspection
Table metadata inspection (columns, types, nullability, defaults, PK)
Index and foreign key discovery
Environment-driven configuration for secure deployment

Related MCP server: Azure Database for PostgreSQL MCP Server

Available Tools

Tool	Description
`execute_query`	Executes a SQL statement and returns rows or affected row count
`list_tables`	Lists tables from `INFORMATION_SCHEMA.TABLES` (optional schema filter)
`describe_table`	Returns table column metadata and primary key markers
`list_databases`	Lists all PostgreSQL databases
`get_table_indexes`	Lists table indexes with definitions and PK/unique flags
`get_foreign_keys`	Lists table foreign keys and referenced targets

Requirements

Node.js 18+
Access to a PostgreSQL instance
Network connectivity from MCP host to PostgreSQL (host:port)

Configuration

Set connection settings using environment variables:

Variable	Required	Default	Description
`PGHOST` (or `POSTGRES_HOST`)	No	`localhost`	PostgreSQL host or IP
`PGPORT` (or `POSTGRES_PORT`)	No	`5432`	PostgreSQL TCP port
`PGDATABASE` (or `POSTGRES_DB`)	No	`postgres`	Default database
`PGUSER` (or `POSTGRES_USER`)	Yes	—	Database user
`PGPASSWORD` (or `POSTGRES_PASSWORD`)	Yes	—	Database password
`PGSSL` (or `POSTGRES_SSL`)	No	`false`	Enables SSL/TLS
`PGPOOL_MAX`	No	`10`	Max pool connections
`PGPOOL_IDLE_TIMEOUT_MS`	No	`30000`	Pool idle timeout (ms)
`MCP_TRANSPORT`	No	`stdio`	Transport mode: `stdio` (default, for `npx`/Claude Desktop/VS Code) or `http` (Streamable HTTP, for Docker/remote clients such as n8n)
`MCP_HTTP_PORT`	No	`3002`	Port for the HTTP server (only used when `MCP_TRANSPORT=http`)
`MCP_HTTP_HOST`	No	`0.0.0.0`	Bind address for the HTTP server (only used when `MCP_TRANSPORT=http`)

Usage

Run directly from GitHub

npx github:ferronicardoso/mcp-postgresql

Claude Code (CLI)

claude mcp add postgresql --scope user -- npx -y github:ferronicardoso/mcp-postgresql

--scope controls where the server registration is stored:

Scope	Stored in	Visible to
`local` (default)	project-local, untracked	only you, only in this project
`project`	`.mcp.json` at the project root	anyone who clones the repo (commit it to share)
`user`	your global Claude Code config	you, across every project

Environment variables can be passed with repeated --env KEY=VALUE flags before the --, e.g.:

Bash (Linux/macOS/WSL):

claude mcp add postgresql --scope user \
  --env PGHOST=localhost \
  --env PGPORT=5432 \
  --env PGDATABASE=postgres \
  --env PGUSER=postgres \
  --env PGPASSWORD=your-password \
  -- npx -y github:ferronicardoso/mcp-postgresql

PowerShell:

claude mcp add postgresql --scope user `
  --env PGHOST=localhost `
  --env PGPORT=5432 `
  --env PGDATABASE=postgres `
  --env PGUSER=postgres `
  --env PGPASSWORD=your-password `
  -- npx -y github:ferronicardoso/mcp-postgresql

Codex CLI

Bash (Linux/macOS/WSL):

codex mcp add postgresql \
  --env PGHOST=localhost \
  --env PGPORT=5432 \
  --env PGDATABASE=postgres \
  --env PGUSER=postgres \
  --env PGPASSWORD=your-password \
  npx -- -y github:ferronicardoso/mcp-postgresql

PowerShell:

codex mcp add postgresql `
  --env PGHOST=localhost `
  --env PGPORT=5432 `
  --env PGDATABASE=postgres `
  --env PGUSER=postgres `
  --env PGPASSWORD=your-password `
  npx -- -y github:ferronicardoso/mcp-postgresql

This registers the server in ~/.codex/config.toml. To remove it, run codex mcp remove postgresql.

Claude Desktop configuration

%APPDATA%\\Claude\\claude_desktop_config.json:

{
  "mcpServers": {
    "postgresql": {
      "command": "npx",
      "args": ["github:ferronicardoso/mcp-postgresql"],
      "env": {
        "PGHOST": "localhost",
        "PGPORT": "5432",
        "PGDATABASE": "postgres",
        "PGUSER": "postgres",
        "PGPASSWORD": "your-password"
      }
    }
  }
}

VS Code MCP configuration

.vscode/mcp.json:

{
  "servers": {
    "postgresql": {
      "command": "npx",
      "args": ["github:ferronicardoso/mcp-postgresql"],
      "env": {
        "PGHOST": "localhost",
        "PGPORT": "5432",
        "PGDATABASE": "postgres",
        "PGUSER": "postgres",
        "PGPASSWORD": "your-password"
      }
    }
  }
}

Run with Docker (HTTP transport)

The published image runs in Streamable HTTP mode by default, for use as a remote MCP endpoint (e.g. from n8n's MCP Client Tool node or any Streamable HTTP-compatible client):

Bash (Linux/macOS/WSL):

docker run -d --name mcp-postgresql \
  -p 3002:3002 \
  -e PGHOST=host.docker.internal \
  -e PGPORT=5432 \
  -e PGDATABASE=postgres \
  -e PGUSER=postgres \
  -e PGPASSWORD=your-password \
  ghcr.io/ferronicardoso/mcp-postgresql:latest

PowerShell:

docker run -d --name mcp-postgresql `
  -p 3002:3002 `
  -e PGHOST=host.docker.internal `
  -e PGPORT=5432 `
  -e PGDATABASE=postgres `
  -e PGUSER=postgres `
  -e PGPASSWORD=your-password `
  ghcr.io/ferronicardoso/mcp-postgresql:latest

The MCP endpoint is then available at http://localhost:3002/mcp.

Local Development

git clone https://github.com/ferronicardoso/mcp-postgresql
cd mcp-postgresql
npm install
npm run build

Start the compiled server:

npm start

Build and Commit Workflow

This repository intentionally tracks dist/ to support npx github:user/repo usage.

The project uses a Husky pre-commit hook to:

build TypeScript (npm run build)
stage generated artifacts (git add dist)

Manual fallback:

npm run build
git add dist

Security Notes

Never commit real credentials or .env files.
Prefer least-privilege database users for production use.
For public or untrusted networks, enable encryption (PGSSL=true) and configure certificates appropriately.

License

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

Related MCP Servers

Database MCP Server
Databases Developer Tools Code Execution
roilanrodriguez55
A
license
Not graded
quality
C
maintenance
An extensible MCP server for database operations that supports PostgreSQL for managing schemas, tables, data, and user permissions. It features automatic migration recording for DDL changes and integrates with various AI-powered editors like Cursor, Zed, and Claude Code.
Updated 10 days ago (2026-08-17 06:08 UTC)
22
2
MIT
Azure Database for PostgreSQL
Databases Cloud Platforms
kk-src
A
license
Not graded
quality
D
maintenance
A Model Context Protocol (MCP) Server that allows AI models to securely interact with data hosted in Azure Database for PostgreSQL. It enables natural language querying, schema exploration, and data management through MCP clients like Claude Desktop and Visual Studio Code.
Updated a year ago (2025-05-18 11:11 UTC)
MIT
postgres-mcp
Databases Developer Tools
rajivonai
A
license
Not graded
quality
C
maintenance
A production-ready MCP server for PostgreSQL — built for Claude Desktop, Claude Code, and any MCP-compatible AI agent.
Updated 2 months ago (2026-06-14 19:43 UTC)
Apache 2.0
Postgres MCP Server
Databases Developer Tools
abiswas97
A
license
Not graded
quality
C
maintenance
A Model Context Protocol (MCP) server that provides secure database access to PostgreSQL through Kysely ORM, enabling Claude Desktop to interact with PostgreSQL databases using natural language.
Updated 6 months ago (2026-03-08 22:53 UTC)
22
1
ISC

View all related MCP servers

Related MCP Connectors

mcp
MCP server for managing Prisma Postgres.
Supabase
MCP server for interacting with the Supabase platform
nlqdb — analytical memory for AI agents
Analytical memory for AI agents: a real Postgres queried in plain English over MCP. One command.

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/ferronicardoso/mcp-postgresql'

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

MCP Server for PostgreSQL

Features

Available Tools

Requirements

Configuration

Usage

Run directly from GitHub

Claude Code (CLI)

Codex CLI

Claude Desktop configuration

VS Code MCP configuration

Run with Docker (HTTP transport)

Local Development

Build and Commit Workflow

Security Notes

License

Maintenance

Resources

Looking for Admin?

Tools

Related MCP Servers

Database MCP Server

Azure Database for PostgreSQL

postgres-mcp

Postgres MCP Server

Related MCP Connectors

Latest Blog Posts

MCP directory API