PostgreSQL Products MCP

MCPOpen Source18.0

by michael7736 • Data & Databases

A Node.js MCP server that allows agents to run read-only SQL SELECT queries against a PostgreSQL products database.

Example Use Cases

1
Retrieve product details (name, category, stock, price) from a PostgreSQL products database via SQL queries.
2
Filter or search product inventories (e.g., find all electronics with low stock) by executing SELECT statements remotely.
3
A simple, local MCP-accessible bridge to a database so they can incorporate live product data into responses or workflows.

Description

This MCP server exposes a single tool to execute read-only (SELECT) SQL queries against a configured PostgreSQL database containing product information. It's implemented in TypeScript/Node.js and is configured via environment variables (PGHOST, PGPORT, PGUSER, PGPASSWORD, PGDATABASE). The server is intended to let AI assistants or other agents query product data safely from within an MCP-enabled client.

Quick Actions

View on GitHub

Security

Scanned 2 month(s) ago

Risk Level

MINIMAL

Read-only data retrieval, no side effects

Trust Score

D44/100

7/17 checks passed

Scores are informational only and provided “as is” without warranty. AgentHotspot assumes no liability for actions taken based on these ratings.

Quick Stats

Service TypeMCP

Pricing ModelFree

Capabilities0 Tools / 0 Prompts / 0 Resources

Ownermichael7736

CategoryData & Databases

DependenciesStandalone