PostgreSQL Products MCP Server

@michael7736

About PostgreSQL Products MCP Server

MCP server for interacting with a PostgreSQL products database.

#postgresql #mcp-server #database-interaction

Config

Add this server to your MCP-compatible client using the configuration below.

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

Tools

No tools detected

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

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.

FAQ from PostgreSQL Products MCP Server

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.

Can the server modify or insert data?

No. The run_sql_query tool only accepts SQL SELECT statements, making it read-only by design.

What are the runtime dependencies?

Node.js v18 or later, npm or yarn, and access to a PostgreSQL database with the appropriate credentials.

Is the server limited to a specific MCP client?

No. It works with any MCP-compatible client that supports the configuration format (e.g., Claude Desktop, Cline).

Frequently asked questions

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?

Can the server modify or insert data?

No. The `run_sql_query` tool only accepts SQL SELECT statements, making it read-only by design.

What are the runtime dependencies?

Node.js v18 or later, npm or yarn, and access to a PostgreSQL database with the appropriate credentials.

Is the server limited to a specific MCP client?

No. It works with any MCP-compatible client that supports the configuration format (e.g., Claude Desktop, Cline).

Comments

Basic information

More Databases MCP servers

Neon MCP Server

neondatabase

MCP server for interacting with Neon Management API and databases

617

Redis MCP Server

redis

The official Redis MCP Server is a natural language interface designed for agentic applications to manage and search data in Redis efficiently

539

ClickHouse MCP Server

ClickHouse

Connect ClickHouse to your AI assistants.

818

Postgres Mcp

crystaldba

Postgres MCP Pro provides configurable read/write access and performance analysis for you and your AI agents.

3.0K

Database Gateway

centralmind

Universal MCP-Server for your Databases optimized for LLMs and AI-Agents.

531