garethcott_enhanced-postgres-mcp-server
npxBasicThis MCP server provides read and write access to PostgreSQL databases. It exposes SQL query execution, transaction management, and schema inspection. It connects directly to PostgreSQL instances. Developers use it to build AI agents that interact with relational data, perform complex queries, and manage database operations.
000
Overview
This MCP server provides read and write access to PostgreSQL databases. It exposes SQL query execution, transaction management, and schema inspection. It connects directly to PostgreSQL instances. Developers use it to build AI agents that interact with relational data, perform complex queries, and manage database operations.
Installation
1Install the package
npx
npx -y @iflow-mcp/garethcott_enhanced-postgres-mcp-server2Add to Claude
Add this configuration to your claude_desktop_config.json:
claude_desktop_config.json
{
"mcpServers": {
"iflow-mcp-garethcottenhanced-postgres-mcp-server-npm": {
"command": "npx",
"args": [
"-y",
"npx -y @iflow-mcp/garethcott_enhanced-postgres-mcp-server"
]
}
}
}3Verify installation
Restart Claude Desktop, then ask:
"What tools do you have available from garethcott_enhanced-postgres-mcp-server?"
Prerequisites
- Node.js 18 or higher
- npm or npx available
- Claude Desktop or Claude API access
- API key for garethcott_enhanced-postgres-mcp-server
Configuration
API Key Required
This server requires an API key from garethcott_enhanced-postgres-mcp-server. Add it to your environment or config.
| Variable | Required | Description |
|---|---|---|
| GARETHCOTT_ENHANCED-POSTGRES-MCP-SERVER_API_KEY | Yes | Your garethcott_enhanced-postgres-mcp-server API key |
Usage Examples
List Resources
"What resources are available in garethcott_enhanced-postgres-mcp-server?"
Claude will query available resources and return a list of what you can access.
Get Details
"Show me details about [specific item] in garethcott_enhanced-postgres-mcp-server"
Claude will fetch and display detailed information about the requested item.
Create New
"Create a new [item] in garethcott_enhanced-postgres-mcp-server with [details]"
Claude will use the appropriate tool to create the resource and confirm success.
Works with garethcott_enhanced-postgres-mcp-server
Related skills
Browse all skillsNeed help with MCP integration?
We build custom MCP integrations for B2B companies. From simple connections to complex multi-tool setups.