Postgres MCP Pro
Postgres MCP server with index tuning, explain plans, health checks and a restricted read-only mode.
- Autor
- Crystal DBA
- Funciona com
- Any MCP client
- Documentado
- Oct 2, 2026
O que é Postgres MCP Pro
Open source MCP server for the whole development process. It offers health analysis, index tuning, query plans, schema intelligence and safe SQL execution. The reference postgres server is archived in modelcontextprotocol/servers-archived.
O que ela faz
- Database health checks
- Index tuning
- EXPLAIN plans with hypothetical indexes
- Schema-aware SQL generation
- Restricted (read-only) vs unrestricted access mode
Quando usar
Boa adequação
- Performance tuning with an agent
- Dev use in unrestricted mode, production in restricted mode
Não indicado para
- Unreviewed writes to production: use restricted mode
- Python-less or Docker-less setups
Como instalar o Postgres MCP Pro
Você precisa de: Docker or Python 3.12+; Postgres credentials
- Have DB credentials and Docker or Python 3.12+
- docker pull crystaldba/postgres-mcp, or pipx install postgres-mcp
- Add the config to your MCP client with DATABASE_URI
- Set --access-mode=restricted for production
Permissões e segurança
A que ela tem acesso
- Runs SQL on the configured database; restricted mode limits to read-only transactions
Notas de segurança dos mantenedores
- DATABASE_URI contains credentials
Revise a fonte antes de conceder ao agente acesso a credenciais ou sistemas de produção. Documentamos o que os mantenedores informam; não auditamos o código.
Limitações
- Restricted mode constrains only execution time among resources
Perguntas frequentes
How do I make Postgres MCP Pro read-only?
Use --access-mode=restricted. fonte
Is Postgres MCP Pro official?
It is by Crystal DBA, not the MCP project; the reference postgres server is archived. fonte
How do I install Postgres MCP Pro?
docker pull crystaldba/postgres-mcp or pipx install postgres-mcp. fonte
Guias relacionados
Fontes e lacunas
- https://raw.githubusercontent.com/crystaldba/postgres-mcp/main/README.md readme, verificado Oct 2, 2026
- https://raw.githubusercontent.com/modelcontextprotocol/servers/main/README.md readme, verificado Oct 2, 2026
Não informado pelos mantenedores: License not seen in the README; last_release date not visible in the checked README.