Loading subscription status...
💡 Description
A Model Context Protocol server that enables AI models to interact with PostgreSQL databases through a standardized interface, supporting operations like queries, table manipulation, and schema inspection.
📝 JSON Entries
{
"mcpServers": [
{
"endaoment-postgres-mcp": {
"env": {
"DB_CREDENTIALS": "{\"DB_USER\":\"your-username\",\"DB_PASSWORD\":\"your-password\",\"DB_HOST\":\"your-host\",\"DB_PORT\":\"5433\",\"DB_NAME\":\"your-database\"}"
},
"args": [],
"command": "node server.js"
}
}
]
}🛠️ Tools
query
⚡ Features
- Connects to a PostgreSQL database with connection pooling
- Implements Model Context Protocol for AI model interaction
- Provides database schema information as resources
- Allows SQL query execution with retry logic
- Handles connection errors gracefully
💬 Example Queries
- List all tables in the database
- Get schema information for a specific table
- Execute a SQL query to retrieve user data