postgres-mcp-analyst
PostgreSQL MCPでスキーマ確認とread-only分析を行う。集計・意思決定資料が必要な時に使う。
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.
| name | postgres-mcp-analyst |
|---|---|
| description | PostgreSQL MCPでスキーマ確認とread-only分析を行う。集計・意思決定資料が必要な時に使う。 |
PostgreSQL MCP Analyst
Instructions
- 目的→必要指標→必要テーブル→クエリ案→検証(read-only)
- 大量取得を避け、集計/絞り込み/LIMITを優先
- 結果は「数値」「解釈」「次アクション」に落とす