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 reload
npm run lint - Run ESLint
npm 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

PostgreSQL MCP

文档