postgres-mcp-server

postgres-mcp-server

3.1
databases

If you are the rightful owner of postgres-mcp-server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.

This is a Model Context Protocol (MCP) server designed to interact with a PostgreSQL database containing product information.

The PostgreSQL Products MCP Server is a specialized server that facilitates interaction with a PostgreSQL database containing product information. It is designed to allow clients, such as AI assistants, to query the database using SQL. The server is built using Node.js and requires a PostgreSQL database with a specific schema to function. It is configured through environment variables that specify the database connection details. Once set up, the server can execute read-only SQL queries, specifically SELECT statements, to retrieve data from the products database. This makes it a useful tool for applications that need to access and manipulate product data stored in a PostgreSQL database.

Features

  • Facilitates interaction with PostgreSQL databases using SQL queries.
  • Built with Node.js and TypeScript for robust performance.
  • Configurable via environment variables for flexible deployment.
  • Supports read-only SQL queries to ensure data integrity.
  • Easily integrates with AI assistants and other MCP clients.

Tools

  1. run_sql_query

    Executes a read-only SQL query (SELECT statements only) against the configured products database.

Related MCP Servers

View all databases servers →
pg-mcp-server

pg-mcp-server

4.4

by stuzero

unknown

databases
gateway

gateway

4.0

by centralmind

CentralMind Gateway is a tool designed to expose databases to AI agents via MCP or OpenAPI protocols, providing secure, LLM-optimized APIs.

databases
mcp-server-qdrant

mcp-server-qdrant

3.8

by qdrant

The mcp-server-qdrant is a Model Context Protocol server designed to integrate with the Qdrant vector search engine, providing a semantic memory layer for storing and retrieving information.

knowledge_and_memory
notion-mcp-server

notion-mcp-server

3.7

by makenotion

This project implements an MCP server for the Notion API, allowing integration with LLMs.

databases
anyquery

anyquery

3.7

by julien040

Anyquery is a versatile SQL query engine that allows users to run SQL queries on various data sources, including files, databases, and applications, with support for LLMs and MySQL server functionality.

databases
mcp-server-mysql

mcp-server-mysql

3.7

by benborla

A Model Context Protocol server for MySQL databases using NodeJS, enabling LLMs to inspect schemas and execute SQL queries.

databases
supabase-mcp-server

supabase-mcp-server

3.7

by alexander-zuev

Query MCP is an open-source MCP server that lets your IDE safely run SQL, manage schema changes, call the Supabase Management API, and use Auth Admin SDK — all with built-in safety controls.

databases
mcp-server-elasticsearch

mcp-server-elasticsearch

3.7

by elastic

This server connects agents to your Elasticsearch data using the Model Context Protocol, allowing interaction with Elasticsearch indices through natural language conversations.

databases
mcp-proxy

mcp-proxy

3.7

by TBXark

An MCP proxy server that aggregates and serves multiple MCP resource servers through a single HTTP server.

databases
mcp-server-motherduck

mcp-server-motherduck

3.6

by motherduckdb

An MCP server implementation that interacts with DuckDB and MotherDuck databases, providing SQL analytics capabilities to AI Assistants and IDEs.

databases
mcp-server-milvus

mcp-server-milvus

3.6

by zilliztech

The MCP Server for Milvus enables seamless integration between LLM applications and the Milvus vector database, providing a standardized way to connect LLMs with the context they need.

databases
atlas-mcp-server

atlas-mcp-server

3.6

by cyanheads

ATLAS (Adaptive Task & Logic Automation System) is a project, knowledge, and task management system for LLM Agents, implemented as a Model Context Protocol (MCP) server.

developer_tools
airtable-mcp-server

airtable-mcp-server

3.6

by domdomegg

A Model Context Protocol server that provides read and write access to Airtable databases, enabling LLMs to inspect database schemas and manage records.

databases
mcp-server-splunk

mcp-server-splunk

3.6

by jkosik

A Go implementation of the MCP server for Splunk, supporting STDIO and SSE (Server-Sent Events HTTP API) using the github.com/mark3labs/mcp-go SDK.

cloud_platforms
mongo-mcp

mongo-mcp

3.6

by QuantGeekDev

A Model Context Protocol (MCP) server that enables LLMs to interact directly with MongoDB databases. Query collections, inspect schemas, and manage data seamlessly through natural language.

databases
mcp-1panel

mcp-1panel

3.6

by 1Panel-dev

1Panel MCP Server is an implementation of the Model Context Protocol (MCP) server for 1Panel, providing a range of tools for system, website, certificate, application, and database management.

os_automation
mcp-server-weaviate

mcp-server-weaviate

3.6

by weaviate

Weaviate MCP Server is a protocol server designed to interact with the Weaviate vector database, providing functionalities for inserting and querying data.

databases
firebase-mcp

firebase-mcp

3.6

by gannonh

Firebase MCP enables AI assistants to work directly with Firebase services, including Firestore, Storage, and Authentication.

databases
mcp-redis

mcp-redis

3.6

by redis

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

databases
mcp-pinecone

mcp-pinecone

3.6

by sirmews

The Pinecone Model Context Protocol Server for Claude Desktop allows users to read and write to a Pinecone index, facilitating operations like semantic search and document processing.

databases
mcp-server-duckdb

mcp-server-duckdb

3.6

by ktanaka101

A Model Context Protocol (MCP) server implementation for DuckDB, providing database interaction capabilities through MCP tools.

databases
elasticsearch-mcp-server

elasticsearch-mcp-server

3.6

by cr7258

A Model Context Protocol (MCP) server implementation that provides Elasticsearch and OpenSearch interaction. This server enables searching documents, analyzing indices, and managing cluster through a set of tools.

databases
supabase-mcp

supabase-mcp

3.6

by coleam00

A Model Context Protocol (MCP) server that provides tools for interacting with a Supabase database. This server enables AI assistants to perform database operations through a standardized interface.

databases
mcp-tinybird

mcp-tinybird

3.6

by tinybirdco

An MCP server to interact with a Tinybird Workspace from any MCP client.

databases
mcp-server-bigquery

mcp-server-bigquery

3.6

by LucasHild

A Model Context Protocol server that provides access to BigQuery, enabling LLMs to inspect database schemas and execute queries.

databases
notion-mcp-server

notion-mcp-server

3.6

by awkoy

Notion MCP Server is a Model Context Protocol server implementation that enables AI assistants to interact with Notion's API, providing tools for reading, creating, and modifying Notion content through natural language interactions.

ai_chatbot
mcp-snowflake-server

mcp-snowflake-server

3.6

by isaacwasserman

A Model Context Protocol (MCP) server implementation that provides database interaction with Snowflake.

databases