PostgreSQL MCP Server

@1Levick3

代码仓库

基本信息

分类

数据库

许可证

MIT license

传输方式

stdio

作者

1Levick3

关于 PostgreSQL MCP Server

Mcp server for postgres

PostgreSQL MCP Server 配置

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

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

PostgreSQL MCP Server 工具

工具列表暂未提供

当前收录暂时没有可展示的工具列表，不代表服务没有工具。请查阅项目文档了解支持的能力。

点击上方按钮,在临时沙箱中运行此服务器并实时获取工具列表。

概览

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

常见问题

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.