local_pgsql

Created By

WaterMelon9 months 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.

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

TimeA Model Context Protocol server that provides time and timezone conversion capabilities. This server enables LLMs to get current time information and perform timezone conversions using IANA timezone names, with automatic system timezone detection.

MCP AdvisorMCP Advisor & Installation - Use the right MCP server for your needs

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

ChatWiseThe second fastest AI chatbot™

DeepChatYour AI Partner on Desktop

CursorThe AI Code Editor

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.

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