postgresql-mcp

wasteology/postgresql-mcp

3.1

If you are the rightful owner of postgresql-mcp and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to dayong@mcphub.com.

This is a PostgreSQL MCP Server designed for querying CieTrade business data, providing AI agent-accessible tools for data analysis.

Tools
7
Resources
0
Prompts
0

PostgreSQL MCP Server for CieTrade Data

AI agent-accessible MCP server for querying CieTrade business data in PostgreSQL.

Quick Setup

  1. Install dependencies:

    uv sync

  2. Configure environment:

    cp .env.example .env
# Edit .env with your Azure AD service principal credentials

  3. Test connection:

    uv run python -c "from database import DatabaseConnection; db = DatabaseConnection(); conn = db.get_connection(); print('Connection successful!')"

  4. Run server:

    uv run python server.py

Available Tools

  • account_performance: Top performing accounts with metrics
  • recent_activity: Recent activity across all tables
  • location_analysis: Account location patterns
  • financial_overview: Revenue and billing trends
  • data_quality: Data completeness checks
  • trading_inquiries: Trading inquiry analysis
  • custom_query: Execute custom SELECT queries

Agent Integration

Add this MCP server to your Claude desktop config:

{
  "mcpServers": {
    "postgresql-mcp": {
      "command": "uv",
      "args": ["run", "python", "server.py"],
      "cwd": "/path/to/postgresql-mcp"
    }
  }
}

Demo Queries

  • "What are our top performing accounts this month?"
  • "Show me recent activity across all systems"
  • "What's our data quality status?"
  • "Analyze our financial trends for the last 6 months"