PostgreSQL Products MCP Server

@michael7736

代码仓库

基本信息

分类

数据库

传输方式

stdio

作者

michael7736

关于 PostgreSQL Products MCP Server

MCP server for interacting with a PostgreSQL products database.

#postgresql #mcp-server #database-interaction

PostgreSQL Products MCP Server 配置

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

{
  "mcpServers": {
    "postgres-products": {
      "command": "node",
      "args": [
        "/path/to/your/postgres-mcp-server/build/index.js"
      ],
      "env": {
        "PGHOST": "",
        "PGPORT": "",
        "PGUSER": "",
        "PGPASSWORD": "",
        "PGDATABASE": ""
      }
    }
  }
}

PostgreSQL Products MCP Server 工具

工具列表暂未提供

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

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

概览

What is PostgreSQL Products MCP Server?

PostgreSQL Products MCP Server is a Model Context Protocol server that allows AI assistants to query a PostgreSQL database containing product information using read-only SQL SELECT statements. It is intended for developers who need to integrate product data into MCP-compatible clients.

How to use PostgreSQL Products MCP Server?

Configure the server in your MCP client settings (e.g., cline_mcp_settings.json) with environment variables for PostgreSQL connection details (PGHOST, PGPORT, PGUSER, PGPASSWORD, PGDATABASE). Build the TypeScript code with npm run build, then point the client to the built build/index.js file. The server exposes a single tool called run_sql_query that accepts a SQL SELECT query string.

Key features of PostgreSQL Products MCP Server

Executes read-only SQL SELECT queries against PostgreSQL.
Simple configuration via environment variables.
Built with TypeScript and compiled to Node.js.
Single focused tool for database interaction.
Designed for product-related database schemas.

Use cases of PostgreSQL Products MCP Server

Allow an AI assistant to fetch product details from a database.
Query stock quantities or pricing information for inventory.
Retrieve product listings filtered by category or other criteria.
Enable natural language questions about products via an MCP client.

常见问题

What database schema does the server require?

The server connects to any PostgreSQL database, but it is designed for a schema containing product information. No specific table structure is enforced beyond being reachable by SELECT queries.

What transport or authentication does the server use?

The server uses PostgreSQL connection credentials provided via environment variables (PGHOST, PGPORT, PGUSER, PGPASSWORD, PGDATABASE). It does not implement additional authentication or transport layers beyond standard MCP.