PostgreSQL MCP Server

Name: PostgreSQL MCP Server
Author: 1Levick3

@1Levick3

代码仓库

关于 PostgreSQL MCP Server

Mcp server for postgres

基本信息

分类

数据库

许可证

MIT license

运行时

node

传输方式

stdio

发布者

1Levick3

配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "mcpServers": {
    "postgresql-mcp-server-1levick3": {
      "command": "npx",
      "args": [
        "-y",
        "@smithery/cli",
        "install",
        "@1Levick3/postgresql-mcp-server",
        "--client",
        "claude"
      ]
    }
  }
}

工具

未检测到工具

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

What is PostgreSQL MCP Server?

A Model Context Protocol server that enables direct PostgreSQL database query execution with support for parameterized queries and configurable timeouts. It is designed specifically for use with the Cursor IDE.

How to use PostgreSQL MCP Server?

Install via Smithery with npx -y @smithery/cli install @1Levick3/postgresql-mcp-server --client claude or manually by cloning the repository, installing dependencies, building, and adding to your MCP settings file with a POSTGRES_CONNECTION_STRING environment variable and optional SSL certificate path.

Key features of PostgreSQL MCP Server

Execute custom SQL queries against PostgreSQL databases
Supports parameterized queries for safe variable interpolation
Configurable connection timeouts
Uses connection pooling for efficient resource management
Validates connection strings and supports SSL/TLS
Designed for integration with Cursor IDE

Use cases of PostgreSQL MCP Server

Running ad‑hoc database queries from an AI assistant in Cursor IDE
Performing database exploration and data retrieval via natural language prompts
Building AI‑powered tools that need to query PostgreSQL directly
Automating SQL‑based tasks within development workflows

FAQ from PostgreSQL MCP Server

What is the purpose of this server?

It provides an MCP interface for executing PostgreSQL queries, enabling AI assistants (specifically within Cursor IDE) to interact with a PostgreSQL database.

What are the dependencies?

Node.js version 18.0.0 or higher, a running PostgreSQL server for target operations, and network access to that PostgreSQL instance.

How do I configure the connection?

Set the POSTGRES_CONNECTION_STRING environment variable in your MCP settings. Optionally, set POSTGRES_SSL_CERT_PATH to the path of an SSL root certificate.