Postgres MCP Pro
Query, analyze, and tune PostgreSQL databases through your AI agent with safe access controls. Beyond basic SQL execution, it provides index tuning recommendations, query plan analysis, database health monitoring, and schema intelligence.
Works with
--- name: Postgres MCP Pro description: Query, analyze, and tune PostgreSQL databases through your AI agent with safe access controls. Beyond basic SQL execution, it provides index tuning recommendations, query plan analysis, database health monitoring, and schema intelligence. license: MIT --- # Postgres MCP Pro Query, analyze, and tune PostgreSQL databases through your AI agent with safe access controls. Beyond basic SQL execution, it provides index tuning recommendations, query plan analysis, database health monitoring, and schema intelligence. ## Prerequisites MCP-compatible client, PostgreSQL database (local or remote), Docker or Python 3.12+ ## Installation Use the upstream install or setup path that matches your environment: - The choice to use Docker or Python is yours. - docker pull crystaldba/postgres-mcp - pipx install postgres-mcp - uv pip install postgres-mcp Requirements and caveats from upstream: - Docker *or* Python 3.12 or higher. - #### Docker or Python - We generally recommend Docker because Python users can encounter more environment-specific issues. Basic usage or getting-started notes: - <a href="#quick-start">Quick Start</a> • - Before getting started, ensure you have: - Access credentials for your database. - Source: https://github.com/crystaldba/postgres-mcp - Extracted from upstream docs: https://raw.githubusercontent.com/crystaldba/postgres-mcp/HEAD/README.md ## Documentation - https://github.com/crystaldba/postgres-mcp#readme ## Source - [Agent Skill Exchange](https://agentskillexchange.com/skills/postgres-mcp-pro/)
More Database skills
prisma-mongodb-upgrade
prisma/skills
Decision and migration guide for Prisma ORM MongoDB projects on v6, which have no upgrade path to v7. Use when a MongoDB project asks about upgrading Prisma, when "upgrade to prisma 7" comes up in a project with provider = "mongodb", or when evaluating a move to Prisma Next. Triggers on "upgrade prisma mongodb", "prisma 7 mongodb", "mongodb prisma migration", "prisma next mongodb".
azure-upgrade
microsoft/azure-skills
Assess and upgrade Azure workloads between plans, tiers, or SKUs, or modernize Azure SDK dependencies in source code. WHEN: upgrade Consumption to Flex Consumption, upgrade Azure Functions plan, change hosting plan, function app SKU, migrate App Service to Container Apps, modernize legacy Azure Java SDKs (com.microsoft.azure to com.azure), migrate Azure Cache for Redis (ACR/ACRE) to Azure Managed Redis (AMR).
azure-cost-optimization
microsoft/azure-skills
Identify Azure cost savings from usage and spending data. USE FOR: optimize Azure costs, reduce Azure spending/expenses, analyze Azure costs, find cost savings, generate cost optimization report, identify orphaned resources to delete, rightsize VMs, reduce waste, optimize Redis costs, optimize storage costs, AKS cost analysis add-on, namespace cost, cost spike, anomaly, budget alert, AKS cost visibility. DO NOT USE FOR: deploying resources (use azure-deploy), general Azure diagnostics (use azure-diagnostics), security issues (use azure-security)
