{"id":"e7e9f632-3987-402b-aa12-3fa70841c8df","shortId":"gx2pW9","kind":"skill","title":"Postgres MCP Pro","tagline":"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.","description":"# Postgres MCP Pro\n\nQuery, 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.\n\n## Prerequisites\n\nMCP-compatible client, PostgreSQL database (local or remote), Docker or Python 3.12+\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## Documentation\n\n- https://github.com/crystaldba/postgres-mcp#readme\n\n## Source\n\n- [Agent Skill Exchange](https://agentskillexchange.com/skills/postgres-mcp-pro/)","tags":["postgres","mcp","pro","skills","agentskillexchange","agent-skills","ai-agents","ai-tools","awesome-list","claude-code","codex","cursor"],"capabilities":["skill","source-agentskillexchange","skill-postgres-mcp-pro","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","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,285 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:49.050Z","embedding":null,"createdAt":"2026-05-18T13:18:27.721Z","updatedAt":"2026-05-18T19:11:49.050Z","lastSeenAt":"2026-05-18T19:11:49.050Z","tsv":"'/crystaldba/postgres-mcp':171 '/crystaldba/postgres-mcp#readme':182 '/crystaldba/postgres-mcp/head/readme.md':178 '/skills/postgres-mcp-pro/)':189 '3.12':84,128 'access':16,51,163 'agent':13,48,184 'agentskillexchange.com':188 'agentskillexchange.com/skills/postgres-mcp-pro/)':187 'ai':12,47 'analysi':29,64 'analyz':5,40 'basic':19,54,148 'beyond':18,53 'caveat':122 'choic':98 'client':75 'compat':74 'control':17,52 'credenti':164 'crystaldba/postgres-mcp':108 'databas':9,30,44,65,77,167 'doc':175 'docker':81,101,106,125,131,137 'document':179 'encount':142 'ensur':160 'environ':96,145 'environment-specif':144 'exchang':186 'execut':21,56 'extract':172 'general':135 'get':152,158 'getting-start':151 'github.com':170,181 'github.com/crystaldba/postgres-mcp':169 'github.com/crystaldba/postgres-mcp#readme':180 'health':31,66 'higher':130 'index':24,59 'instal':85,89,110,116 'intellig':35,70 'issu':147 'local':78 'match':94 'mcp':2,37,73,113,119 'mcp-compat':72 'monitor':32,67 'note':154 'path':92 'pip':115 'pipx':109 'plan':28,63 'postgr':1,36,112,118 'postgres-mcp':111,117 'postgresql':8,43,76 'prerequisit':71 'pro':3,38 'provid':23,58 'pull':107 'python':83,103,127,133,139 'queri':4,27,39,62 'quick':155 'raw.githubusercontent.com':177 'raw.githubusercontent.com/crystaldba/postgres-mcp/head/readme.md':176 'recommend':26,61,136 'remot':80 'requir':120 'safe':15,50 'schema':34,69 'setup':91 'skill':185 'skill-postgres-mcp-pro' 'sourc':168,183 'source-agentskillexchange' 'specif':146 'sql':20,55 'start':153,156,159 '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':7,25,42,60 'upstream':88,124,174 'usag':149 'use':86,100 'user':140 'uv':114","prices":[{"id":"dd40b776-d79b-4438-bec4-1f97a9572c4e","listingId":"e7e9f632-3987-402b-aa12-3fa70841c8df","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.721Z"}],"sources":[{"listingId":"e7e9f632-3987-402b-aa12-3fa70841c8df","source":"github","sourceId":"agentskillexchange/skills/postgres-mcp-pro","sourceUrl":"https://github.com/agentskillexchange/skills/tree/main/skills/postgres-mcp-pro","isPrimary":false,"firstSeenAt":"2026-05-18T13:18:27.721Z","lastSeenAt":"2026-05-18T19:11:49.050Z"}],"details":{"listingId":"e7e9f632-3987-402b-aa12-3fa70841c8df","quickStartSnippet":null,"exampleRequest":null,"exampleResponse":null,"schema":null,"openapiUrl":null,"agentsTxtUrl":null,"citations":[],"useCases":[],"bestFor":[],"notFor":[],"kindDetails":{"org":"agentskillexchange","slug":"postgres-mcp-pro","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":"406b86c571cf5e9386f7114196db50b49b243696","skill_md_path":"skills/postgres-mcp-pro/SKILL.md","default_branch":"main","skill_tree_url":"https://github.com/agentskillexchange/skills/tree/main/skills/postgres-mcp-pro"},"layout":"multi","source":"github","category":"skills","frontmatter":{"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."},"skills_sh_url":"https://skills.sh/agentskillexchange/skills/postgres-mcp-pro"},"updatedAt":"2026-05-18T19:11:49.050Z"}}