mcpField
P
PostgreSQL MCP Server

PostgreSQL MCP Server

Local
github.com/1Levick3Databases1Updated 78w ago
Repository

About PostgreSQL MCP Server

PostgreSQL MCP Server enables direct SQL queries against PostgreSQL databases and is designed for Cursor IDE users. It supports parameterized queries, configurable timeouts, and connection safeguards such as pooling.

Key features

  1. 01Execute custom SQL queries
  2. 02Parameterized query support
  3. 03Configurable query timeouts
  4. 04Connection pooling and timeouts
  5. 05SSL/TLS connection support

Use cases

  1. 01Query PostgreSQL data from Cursor
  2. 02Run database operations with parameterized SQL
  3. 03Connect to a database using SSL/TLS

MCP support

The MCP server provides clients with PostgreSQL query execution capabilities.

Configuration

Local server config is the same for every client. Copy it into your client’s MCP config file.

mcp.json · Universal config
{
  "mcpServers": {
    "postgresql-mcp-server-1levick3": {
      "command": "npx",
      "args": [
        "-y",
        "@smithery/cli"
      ]
    }
  }
}
Run commandnpx -y @smithery/cli

Local servers need a runtime on your machine (e.g. Node.js 18+). Config file locations differ by client; see your client’s docs.

Packages
npm@smithery/cli

Tools

No tool list yet

Local servers expose tools only once running on your machine, and the maintainer has not provided a tool list.

Details

From the project README

PostgreSQL MCP Server

smithery badge

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

Comments

Markdown supported

New to MCP?

From what the protocol is to installing your first server, these answers cover most first questions.

An open protocol that defines how AI applications connect to external tools and data in a uniform way. Clients talk to the model; MCP servers provide tools, resources and prompt templates. They exchange standard messages, so one server can be reused by many clients.