AcademyMCP serversData and reporting

Postgres MCP Pro

Data and engineering teams who want an AI agent to analyse and tune a Postgres database.

Use it nowWant it running at your company?
  • Listedour rating
  • 3,387gitHub stars
  • MITlicence
  • 55 days agolast update

Use it now

Open inClaudeChatGPTGeminiPerplexity
claude mcp add postgres -e DATABASE_URI=postgresql://username:password@localhost:5432/dbname -- docker run -i --rm -e DATABASE_URI crystaldba/postgres-mcp --access-mode=unrestricted
Install in CursorInstall in VS CodeOpen the original ↗

Third party software. By copying, downloading or installing it you accept the Academy legal notice: you are responsible for reviewing its code and permissions before use.

README.md

Loading the file...

What it does

An open source MCP server for Postgres. It gives an AI agent database health checks, explain plans, index tuning and safe SQL execution, so it can help with performance analysis and tuning from development through to production.

Use cases

  1. 01Run a health check on a Postgres database
  2. 02Review an explain plan for a slow query
  3. 03Get index suggestions for a busy table

Questions about
Postgres MCP Pro.

What is Postgres MCP Pro used for?

Data and engineering teams who want an AI agent to analyse and tune a Postgres database. An open source MCP server for Postgres. It gives an AI agent database health checks, explain plans, index tuning and safe SQL execution, so it can help with performance analysis and tuning from development through to production.

How do I install Postgres MCP Pro?

Run this in your terminal: claude mcp add postgres -e DATABASE_URI=postgresql://username:password@localhost:5432/dbname -- docker run -i --rm -e DATABASE_URI crystaldba/postgres-mcp --access-mode=unrestricted

Is Postgres MCP Pro open source?

Yes. The code is on GitHub (crystaldba/postgres-mcp) under the MIT licence.

Is Postgres MCP Pro safe to use?

Our automatic scan flagged points to review, so read the code before installing it. Third party open source software. Sabemos AI does not maintain it. Check the code and permissions before you connect it to company data.

Related resources

Read the guide: AI data analysts: ask your data ↗

  1. 001XLSXFinance and data teams that build or update Excel models and reports and want them to recalculate correctly.OfficialSkill
  2. 002SkillOptAI and data teams that maintain agent skills and want to improve them with a measured, validated process instead of manual tweaks.OfficialSkill · ★ 18k
  3. 003Firecrawl Plugin for Claude CodeResearch, marketing and data teams that need web content pulled into a clean format for analysis with an AI agent.OfficialSkill · ★ 237
  4. 004markitdownOperations and analyst teams that need to give reports, contracts and spreadsheets to an AI assistant as plain text.OfficialMCP server · ★ 189k
  5. 005server-fetchMarketing and research teams that want an AI assistant to read and summarise public web pages.OfficialMCP server
  6. 006MCP Toolbox for DatabasesData teams and developers who want AI agents to query company databases through controlled tools.OfficialMCP server · ★ 17k