PostgreSQL Database Query Server
Enable direct execution of custom SQL queries against PostgreSQL databases with support for parameterized queries and configurable timeouts. Securely manage database connections with SSL/TLS and connection pooling. Simplify database management and monitoring through an MCP-compliant interface.
Ask AI about PostgreSQL Database Query Server
Powered by Claude · Grounded in docs
I know everything about PostgreSQL Database Query Server. Ask me about installation, configuration, usage, or troubleshooting.
0/500
Reviews
Documentation
PostgreSQL MCP Server
A Model Context Protocol (MCP) server that provides direct PostgreSQL database query execution capabilities. This server enables custom SQL query execution against PostgreSQL databases with support for parameterized queries and configurable timeouts. This project is designed specifically for use with the Cursor IDE.
Prerequisites
- Node.js >= 18.0.0
- PostgreSQL server (for target database operations)
- Network access to target PostgreSQL instances
Installation
Installing via Smithery
To install PostgreSQL Database Query Server for Claude Desktop automatically via Smithery:
npx -y @smithery/cli install @1Levick3/postgresql-mcp-server --client claude
Manual Installation
- Clone the repository
- Install dependencies:
npm install - Build the server:
npm run build - Add to MCP settings file:
{ "mcpServers": { "postgresql-mcp": { "command": "node", "args": ["/Users/1Levick3/Desktop/postgresql-mcp-server/build/index.js"], "disabled": false, "alwaysAllow": [], "env": { "POSTGRES_CONNECTION_STRING": "postgresUrl", "POSTGRES_SSL_CERT_PATH": "/Users/1levick3/Desktop/root.crt" } } } }
Development
npm run dev- Start development server with hot reloadnpm run lint- Run ESLintnpm test- Run tests
Security Considerations
- Connection Security
- Uses connection pooling
- Implements connection timeouts
- Validates connection strings
- Supports SSL/TLS connections
Contributing
- Fork the repository
- Create a feature branch
- Commit your changes
- Push to the branch
- Create a Pull Request
