About

PostgreSQL Database Query Server enables direct SQL query execution against PostgreSQL databases through an MCP-compliant interface. It provides secure database access with support for complex query operations and connection management. Key capabilities include: - Execute custom SQL queries with full PostgreSQL syntax support - Parameterized queries to prevent SQL injection and improve security - SSL/TLS encryption for secure database connections with certificate validation - Connection pooling for efficient resource management and performance - Configurable query timeouts for long-running operation control

README

PostgreSQL MCP Server

[](https://smithery.ai/server/@1Levick3/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

1. Clone the repository 2. Install dependencies:

   npm install

3. Build the server:

   npm run build

4. 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

1. Connection Security - Uses connection pooling - Implements connection timeouts - Validates connection strings - Supports SSL/TLS connections

Contributing

1. Fork the repository 2. Create a feature branch 3. Commit your changes 4. Push to the branch 5. Create a Pull Request

PostgreSQL Database Query Server

About

README

PostgreSQL MCP Server

Prerequisites

Installation

Installing via Smithery

Manual Installation

Development

Security Considerations

Contributing

Related MCP Servers

AI Research Assistant

Math-MCP

Saju Insights

Tools

Directories

Pricing

Rankings

News