local_pgsql

Created By

WaterMelona year ago

一个本地访问PGSQL的MCP Server

# database

# analysis

Overview Content Tools Comments

Overview

MCP (Modular Control Platform) - Overview

Introduction

The Modular Control Platform (MCP) is an extensible Python framework designed to automate and streamline database analytics workflows. It provides a standardized interface for data exploration, statistical analysis, and custom query execution through a plugin-based architecture.

Core Features

Database Operations

Schema Inspection
- Table listing and metadata retrieval
- Column-level schema analysis
Data Access
- Row sampling with configurable limits
- Parameterized custom query execution

Analytical Capabilities

Descriptive Statistics
- Central tendency measures (mean, median)
- Dispersion metrics (std. deviation, variance)
Relationship Analysis
- Correlation matrix generation
- Cross-column dependency detection
Advanced Analytics
- Time series aggregation (daily/weekly/monthly)
- Anomaly detection (Z-score, IQR methods)

Automation Tools

Predefined Analysis Templates
- Common analytical workflows
- SQL query patterns
Dynamic Tool Registration
- Plugin-style function integration
- Type-annotated interface contracts

Technical Architecture

@mcp.tool("example_tool")
def tool_function(params: Dict) -> List[Dict]:
    """Type-safe tool definition"""
    return processed_data

Server Config

{
  "mcpServers": {
    "github": {
      "command": "docker",
      "args": [
        "build",
        "-t",
        "mcp-pgsql-python-service",
        ".",
        "&&",
        "docker",
        "run",
        "-p",
        "8000:8000",
        "-e",
        "DB_HOST=${DB_HOST}",
        "-e",
        "DB_PORT=${DB_PORT:-5432}",
        "-e",
        "DB_NAME=${DB_NAME}",
        "-e",
        "DB_USER=${DB_USER}",
        "-e",
        "DB_PASSWORD=${DB_PASSWORD}",
        "mcp-pgsql-python-service"
      ],
      "env": {
        "GITHUB_PERSONAL_ACCESS_TOKEN": "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",
        "DB_HOST": "postgres",
        "DB_PORT": "5432",
        "DB_NAME": "postgres",
        "DB_USER": "postgres",
        "DB_PASSWORD": "postgres"
      }
    }
  }
}

Recommend Servers

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

Serper MCP ServerA Serper MCP Server

CursorThe AI Code Editor

Playwright McpPlaywright MCP server

WindsurfThe new purpose-built IDE to harness magic

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

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

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.

Y GuiA web-based graphical interface for AI chat interactions with support for multiple AI models and MCP (Model Context Protocol) servers.

Jina AI MCP ToolsA Model Context Protocol (MCP) server that integrates with Jina AI Search Foundation APIs.

RedisA Model Context Protocol server that provides access to Redis databases. This server enables LLMs to interact with Redis key-value stores through a set of standardized tools.