Postgres Mcp

Created By

freakynita month ago

A lightweight MCP (Model Context Protocol) server built to query Postgres database. It provides comprehensive tools for database operations, table introspection, and query execution with smart permission handling.

# postgres

# postgre

Overview Content Tools Comments

Overview

What is Postgres MCP?

Postgres MCP is a lightweight Model Context Protocol server designed to query Postgres databases using SQL or plain English commands. It offers comprehensive tools for database operations, table introspection, and query execution with smart permission handling.

How to use Postgres MCP?

To use Postgres MCP, configure the necessary environment variables for your Postgres database and run the server using the provided command. You can execute queries, list tables, and switch databases through the available tools.

Key features of Postgres MCP?

Smart query permission handling for different types of queries.
Comprehensive table introspection including column definitions and relationships.
Multiple database switching capability and robust error handling.

Use cases of Postgres MCP?

Executing SQL queries with permission validation.
Listing and describing database tables for better understanding.
Switching between multiple databases seamlessly.

FAQ from Postgres MCP?

What types of queries does Postgres MCP support?

Postgres MCP supports read-only, read-write, and admin queries with appropriate permission handling.

Is there a dry-run mode available?

Yes, you can validate queries without executing them using the dry-run mode.

How do I configure Postgres MCP?

You need to set environment variables for your Postgres connection and use the provided configuration format.

Server Config

{
  "mcpServers": {
    "postgres-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "@freakynit/postgres-mcp@latest"
      ],
      "env": {
        "POSTGRES_HOST": "<POSTGRES HOST>",
        "POSTGRES_USER": "<POSTGRES USER>",
        "POSTGRES_PASSWORD": "<POSTGRES PASSWORD>",
        "POSTGRES_DATABASE": "<POSTGRES DATABASE>"
      }
    }
  }
}

Recommend Servers

TraeBuild with Free GPT-4.1 & Claude 3.7. Fully MCP-Ready.

MiniMax MCPOfficial MiniMax Model Context Protocol (MCP) server that enables interaction with powerful Text to Speech, image generation and video generation APIs.

Visual Studio Code - Open Source ("Code - OSS")Visual Studio Code

BlenderBlenderMCP connects Blender to Claude AI through the Model Context Protocol (MCP), allowing Claude to directly interact with and control Blender. This integration enables prompt assisted 3D modeling, scene creation, and manipulation.

Baidu Map百度地图核心API现已全面兼容MCP协议，是国内首家兼容MCP协议的地图服务商。

ChatWiseThe second fastest AI chatbot™

AiimagemultistyleA Model Context Protocol (MCP) server for image generation and manipulation using fal.ai's Stable Diffusion model.

Tavily Mcp

DeepChatYour AI Partner on Desktop

EdgeOne Pages MCPAn MCP service designed for deploying HTML content to EdgeOne Pages and obtaining an accessible public URL.

Playwright McpPlaywright MCP server