{"id":"148519bf-2343-413e-87a5-9f47ed71cd93","shortId":"JXREjn","kind":"skill","title":"Postgres MCP Pro Server for Database Analysis and Tuning","tagline":"Postgres MCP Pro is an open-source MCP server that provides AI agents with PostgreSQL database health analysis, index tuning recommendations, query plan optimization, schema intelligence, and safe SQL execution with configurable access controls.","description":"# Postgres MCP Pro Server for Database Analysis and Tuning\n\nPostgres MCP Pro is an open-source MCP server that provides AI agents with PostgreSQL database health analysis, index tuning recommendations, query plan optimization, schema intelligence, and safe SQL execution with configurable access controls.\n\n## Installation\n\nUse the upstream install or setup path that matches your environment:\n- The choice to use Docker or Python is yours.\n- docker pull crystaldba/postgres-mcp\n- pipx install postgres-mcp\n- uv pip install postgres-mcp\n\nRequirements and caveats from upstream:\n- Docker *or* Python 3.12 or higher.\n- #### Docker or Python\n- We generally recommend Docker because Python users can encounter more environment-specific issues.\n\nBasic usage or getting-started notes:\n- <a href=\"#quick-start\">Quick Start</a> •\n- Before getting started, ensure you have:\n- Access credentials for your database.\n\n- Source: https://github.com/crystaldba/postgres-mcp\n- Extracted from upstream docs: https://raw.githubusercontent.com/crystaldba/postgres-mcp/HEAD/README.md\n\n## Source\n\n- [Agent Skill Exchange](https://agentskillexchange.com/skills/postgres-mcp-pro-database-analysis-tuning/)","tags":["postgres","mcp","pro","database","analysis","tuning","skills","agentskillexchange","agent-skills","ai-agents","ai-tools","awesome-list"],"capabilities":["skill","source-agentskillexchange","skill-postgres-mcp-pro-database-analysis-tuning","topic-agent-skills","topic-ai-agents","topic-ai-tools","topic-awesome-list","topic-claude-code","topic-codex","topic-cursor","topic-llm","topic-mcp","topic-npx-skills","topic-openclaw","topic-skills-catalog"],"categories":["skills"],"synonyms":[],"warnings":[],"endpointUrl":"https://skills.sh/agentskillexchange/skills/postgres-mcp-pro-database-analysis-tuning","protocol":"skill","transport":"skills-sh","auth":{"type":"none","details":{"cli":"npx skills add agentskillexchange/skills","source_repo":"https://github.com/agentskillexchange/skills","install_from":"skills.sh"}},"qualityScore":"0.454","qualityRationale":"deterministic score 0.45 from registry signals: · indexed on github topic:agent-skills · 8 github stars · SKILL.md body (1,182 chars)","verified":false,"liveness":"unknown","lastLivenessCheck":null,"agentReviews":{"count":0,"score_avg":null,"cost_usd_avg":null,"success_rate":null,"latency_p50_ms":null,"narrative_summary":null,"summary_updated_at":null},"enrichmentModel":"deterministic:skill-github:v1","enrichmentVersion":1,"enrichedAt":"2026-05-18T19:11:48.967Z","embedding":null,"createdAt":"2026-05-18T13:18:27.589Z","updatedAt":"2026-05-18T19:11:48.967Z","lastSeenAt":"2026-05-18T19:11:48.967Z","tsv":"'/crystaldba/postgres-mcp':175 '/crystaldba/postgres-mcp/head/readme.md':182 '/skills/postgres-mcp-pro-database-analysis-tuning/)':189 '3.12':132 'access':43,87,167 'agent':23,67,184 'agentskillexchange.com':188 'agentskillexchange.com/skills/postgres-mcp-pro-database-analysis-tuning/)':187 'ai':22,66 'analysi':7,28,51,72 'basic':152 'caveat':126 'choic':102 'configur':42,86 'control':44,88 'credenti':168 'crystaldba/postgres-mcp':112 'databas':6,26,50,70,171 'doc':179 'docker':105,110,129,135,141 'encount':146 'ensur':164 'environ':100,149 'environment-specif':148 'exchang':186 'execut':40,84 'extract':176 'general':139 'get':156,162 'getting-start':155 'github.com':174 'github.com/crystaldba/postgres-mcp':173 'health':27,71 'higher':134 'index':29,73 'instal':89,93,114,120 'intellig':36,80 'issu':151 'match':98 'mcp':2,11,18,46,55,62,117,123 'note':158 'open':16,60 'open-sourc':15,59 'optim':34,78 'path':96 'pip':119 'pipx':113 'plan':33,77 'postgr':1,10,45,54,116,122 'postgres-mcp':115,121 'postgresql':25,69 'pro':3,12,47,56 'provid':21,65 'pull':111 'python':107,131,137,143 'queri':32,76 'quick':159 'raw.githubusercontent.com':181 'raw.githubusercontent.com/crystaldba/postgres-mcp/head/readme.md':180 'recommend':31,75,140 'requir':124 'safe':38,82 'schema':35,79 'server':4,19,48,63 'setup':95 'skill':185 'skill-postgres-mcp-pro-database-analysis-tuning' 'sourc':17,61,172,183 'source-agentskillexchange' 'specif':150 'sql':39,83 'start':157,160,163 'topic-agent-skills' 'topic-ai-agents' 'topic-ai-tools' 'topic-awesome-list' 'topic-claude-code' 'topic-codex' 'topic-cursor' 'topic-llm' 'topic-mcp' 'topic-npx-skills' 'topic-openclaw' 'topic-skills-catalog' 'tune':9,30,53,74 'upstream':92,128,178 'usag':153 'use':90,104 'user':144 'uv':118","prices":[{"id":"cc9e6847-16dc-4ae8-a22b-4dde682abb8b","listingId":"148519bf-2343-413e-87a5-9f47ed71cd93","amountUsd":"0","unit":"free","nativeCurrency":null,"nativeAmount":null,"chain":null,"payTo":null,"paymentMethod":"skill-free","isPrimary":true,"details":{"org":"agentskillexchange","category":"skills","install_from":"skills.sh"},"createdAt":"2026-05-18T13:18:27.589Z"}],"sources":[{"listingId":"148519bf-2343-413e-87a5-9f47ed71cd93","source":"github","sourceId":"agentskillexchange/skills/postgres-mcp-pro-database-analysis-tuning","sourceUrl":"https://github.com/agentskillexchange/skills/tree/main/skills/postgres-mcp-pro-database-analysis-tuning","isPrimary":false,"firstSeenAt":"2026-05-18T13:18:27.589Z","lastSeenAt":"2026-05-18T19:11:48.967Z"}],"details":{"listingId":"148519bf-2343-413e-87a5-9f47ed71cd93","quickStartSnippet":null,"exampleRequest":null,"exampleResponse":null,"schema":null,"openapiUrl":null,"agentsTxtUrl":null,"citations":[],"useCases":[],"bestFor":[],"notFor":[],"kindDetails":{"org":"agentskillexchange","slug":"postgres-mcp-pro-database-analysis-tuning","github":{"repo":"agentskillexchange/skills","stars":8,"topics":["agent-skills","ai-agents","ai-tools","awesome-list","claude-code","codex","cursor","llm","mcp","npx-skills","openclaw","skills-catalog"],"license":"mit","html_url":"https://github.com/agentskillexchange/skills","pushed_at":"2026-05-18T19:02:17Z","description":"The open catalog of AI agent skills — 2,000+ security-scanned skills for Claude Code, Cursor, Codex, and more.","skill_md_sha":"8baa8619ef892b3b2f7a27c77a679cca7dce20b7","skill_md_path":"skills/postgres-mcp-pro-database-analysis-tuning/SKILL.md","default_branch":"main","skill_tree_url":"https://github.com/agentskillexchange/skills/tree/main/skills/postgres-mcp-pro-database-analysis-tuning"},"layout":"multi","source":"github","category":"skills","frontmatter":{"name":"Postgres MCP Pro Server for Database Analysis and Tuning","description":"Postgres MCP Pro is an open-source MCP server that provides AI agents with PostgreSQL database health analysis, index tuning recommendations, query plan optimization, schema intelligence, and safe SQL execution with configurable access controls."},"skills_sh_url":"https://skills.sh/agentskillexchange/skills/postgres-mcp-pro-database-analysis-tuning"},"updatedAt":"2026-05-18T19:11:48.967Z"}}