広告掲載
MCP.so
ログイン
L

Local Pgsql MCP Server

@z-waterking

リポジトリ

基本情報

カテゴリ

その他

トランスポート

stdio

作者

z-waterking

投稿者

px zater

Local Pgsql MCP Server について

一个本地访问PGSQL的MCP Server

#database#analysis#pgsql

Local Pgsql MCP Server の設定

以下の設定を使って、このサーバーを MCP 対応クライアントに追加してください。

{
  "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": "YOUR_GITHUB_TOKEN",
        "DB_HOST": "postgres",
        "DB_PORT": "5432",
        "DB_NAME": "postgres",
        "DB_USER": "postgres",
        "DB_PASSWORD": "postgres"
      }
    }
  }
}

Local Pgsql MCP Server のツール

ツール一覧はまだありません

この掲載には表示できるツール一覧がまだありません。サーバーにツールがないという意味ではありません。対応機能はプロジェクトのドキュメントをご確認ください。

ツールは README から自動的に抽出されます。メンテナーは ## Tools という見出しの下に記載することで、このタブに反映できます。

概要

What is local_pgsql?

local_pgsql is a database analytics and query automation toolkit that provides structured data access for analysis, reporting, and AI-augmented workflows. It is designed for developers and data analysts who need to explore PostgreSQL databases, run parameterized SQL queries, and perform statistical analysis through a modular tool interface.

How to use local_pgsql?

Initialize the MCP with a database connection string, register tools and prompts using the provided API, then call any of the built-in tools or prompts by name. For example, register a DatabaseManager for a PostgreSQL URI and enable tools such as list_tables, run_query, or get_summary_statistics.

Key features of local_pgsql

  • List all tables and get their schemas
  • Preview table contents with data sampling
  • Execute parameterized SQL queries
  • Compute numerical summaries and correlation matrices
  • Perform group-by aggregations with multiple functions
  • Run temporal aggregation and anomaly detection

Use cases of local_pgsql

  • Data exploration to rapidly understand dataset structure and content
  • Automated reporting with scheduled statistical summaries
  • Anomaly monitoring for real-time data quality checks
  • AI-augmented analysis via structured data access for LLMs

よくある質問

1

What database systems does local_pgsql support?

The toolkit includes a `DatabaseManager` interface for backend-agnostic operations, and the integration example shows a PostgreSQL connection string.

2

What tools are available for statistical analysis?

Tools include `get_summary_statistics` (mean, standard deviation), `analyze_correlations` (correlation matrices), and `group_by_analysis` (multi-function aggregations).

3

Does local_pgsql include built-in prompts?

Yes, it provides a basic SQL guide (`basic_sql_guide`) and analysis task templates (`data_analysis_tasks`).

4

How are tools registered and invoked?

Tools are dynamically registered via the `@mcp.tool` decorator and called using `mcp.call_tool` with the tool name and parameters.

5

What type of anomaly detection is supported?

It offers Z-score and IQR based anomaly detection through the `detect_anomalies` tool.

コメント

「その他」の他のコンテンツ

Klarix Intelligence Engine

Klarix

B2B competitive intelligence, live sales battlecards, 5-axis ICP prospect fit scoring, and tech stack teardowns over MCP and REST with cited public-web evidence.

EverArt

modelcontextprotocol

Model Context Protocol Servers

88.1K

Hindsight

vectorize-io

Hindsight: Agent Memory That Learns

50.4K

ICSS

chokcoco

不止于 CSS

20.7K

Health by Dr Brad

Dr Brad Stanfield

Health by Dr Brad works out a health plan from your own results: which screening is due at your age, and evidence-based suggestions, each with the reason and the published guideline or study behind it. Your record is one

広告掲載