postgres-mcp-analyst

PostgreSQL MCPでスキーマ確認とread-only分析を行う。集計・意思決定資料が必要な時に使う。

⭐0stars🔀0forks📁View on GitHub🕐Updated Jan 4, 2026⬇️3downloads

When & Why to Use This Skill

The postgres-mcp-analyst is a specialized Claude skill designed for PostgreSQL database interaction via the Model Context Protocol (MCP). It empowers users to perform comprehensive schema inspections and execute read-only analytical queries to facilitate data-driven decision-making. By following a structured workflow—from defining objectives to interpreting results—it ensures efficient data retrieval and provides actionable insights while maintaining database performance through optimized query practices.

Use Cases

  • Schema Exploration: Quickly identify table structures, column types, and database relationships to understand the data landscape.
  • Business Intelligence & Reporting: Generate aggregated metrics and summary statistics required for management reports and strategic planning.
  • Read-Only Data Analysis: Perform complex SQL queries to extract specific datasets for analysis without the risk of altering production data.
  • Actionable Insight Generation: Transform raw query results into structured summaries featuring numerical data, expert interpretation, and recommended next steps.
namepostgres-mcp-analyst
descriptionPostgreSQL MCPでスキーマ確認とread-only分析を行う。集計・意思決定資料が必要な時に使う。

PostgreSQL MCP Analyst

Instructions

  • 目的→必要指標→必要テーブル→クエリ案→検証(read-only)
  • 大量取得を避け、集計/絞り込み/LIMITを優先
  • 結果は「数値」「解釈」「次アクション」に落とす