Back to Directory
claude-codedata
PostgreSQL MCP Server
Safe, read-only database exploration and query execution for PostgreSQL databases.
Author
Added
2025-12-06
Installationmanual
1. Edit claude_desktop_config.json (see GitHub MCP for location)
2. Add PostgreSQL configuration:
{
"mcpServers": {
"postgres": {
"command": "npx",
"args": ["-y", "@modelcontextprotocol/server-postgres"],
"env": {
"DATABASE_URL": "postgresql://user:password@localhost:5432/dbname"
}
}
}
}
3. Replace DATABASE_URL with your actual connection string
4. Restart Claude Desktop
GitHub: https://github.com/modelcontextprotocol/servers
About this Agent
Safe, read-only database exploration and query execution for PostgreSQL databases.
Model Context Protocol server for PostgreSQL interactions.
Allows Claude to:
- Inspect database schemas and table structures
- Run read-only SQL queries safely
- Analyze data distributions
- Help write and debug complex SQL
Perfect for data analysis workflows and debugging applications with database dependencies.
Tags
#PostgreSQL#Database#SQL#MCP