Home
MCP Servers
RonHouben
postgres-mcp-server

postgres-mcp-server

3.1

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.

Postgres-MCP-Server is an experimental server that allows LLMs to interact with a local PostgreSQL database using the Model Context Protocol.

The Postgres-MCP-Server is designed to facilitate interaction between large language models (LLMs) and PostgreSQL databases. It acts as a bridge, enabling LLMs to query and manipulate data stored in a local database environment. This server is particularly useful for developers and researchers who want to experiment with database interactions in a controlled setting. However, it is important to note that this server is still in an experimental phase and should not be used with real databases, especially for write operations, due to potential risks. The server requires Node.js for installation and configuration, and it uses environment variables to connect to the desired database. The server can be easily configured within Visual Studio Code (VSCode) settings, allowing for seamless integration into development workflows.

Features

Facilitates interaction between LLMs and PostgreSQL databases.
Experimental server for safe testing and development.
Requires Node.js and environment variable configuration.
Easily integrated into VSCode for streamlined development.
Supports custom instructions for database naming conventions.

Related MCP Servers

View all databases servers →

mysql_mcp_server

by designcomputer

MySQL MCP Server is a Model Context Protocol implementation that facilitates secure interaction between AI applications and MySQL databases.

pg-mcp-server

by stuzero

unknown

mcp-clickhouse

by ClickHouse

An MCP server for ClickHouse that allows executing SQL queries and managing databases and tables.

mcp-server-neon

by neondatabase-labs

Neon MCP Server is an open-source tool that enables natural language interaction with Neon Postgres databases.

prisma

by prisma

Prisma is a next-generation ORM for Node.js and TypeScript, providing tools for data modeling, migrations, and querying databases.

gateway

by centralmind

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

mcp-server

by keboola

Keboola MCP Server connects AI agents and MCP clients to Keboola, enabling data access and transformations without glue code.

cloud_platforms

azure-mcp

by Azure

The Azure MCP Server implements the MCP specification to create a seamless connection between AI agents and Azure services.

cloud_platforms

mcp-server-qdrant

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

by makenotion

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

supabase-mcp-server

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.

osv-mcp

by StacklokLabs

An MCP server providing access to the OSV database for querying vulnerability information.

mcp-server-elasticsearch

by elastic

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

mcp-kql-server

by 4R9UN

A Model Context Protocol (MCP) server for executing Kusto Query Language (KQL) queries against Azure Data Explorer clusters.

chroma-mcp

by chroma-core

Chroma MCP Server is an open-source embedding database server that facilitates the integration of LLM applications with external data sources using the Model Context Protocol.

mongodb-mcp-server

by mongodb-js

A Model Context Protocol server for interacting with MongoDB Databases and MongoDB Atlas.

mcp-server-milvus

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.

airtable-mcp-server

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.

mcp-mongo-server

by kiliczsh

A Model Context Protocol server that enables LLMs to interact with MongoDB databases, providing capabilities for inspecting collection schemas and executing MongoDB operations through a standardized interface.

prometheus-mcp-server

by pab1it0

A Model Context Protocol (MCP) server for Prometheus, enabling access to Prometheus metrics and queries through standardized MCP interfaces.

mcp-server-weaviate

by weaviate

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

elasticsearch-mcp-server

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.

firebase-mcp

by gannonh

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

postgres-mcp-server

by aadarshjain

A Model Context Protocol (MCP) server implementation for PostgreSQL database exploration and querying.

mcp-database-server

by executeautomation

The MCP Database Server provides database access capabilities to Claude, supporting SQLite, SQL Server, and PostgreSQL databases.

mcp-mysql-server

by f4ww4z

A Model Context Protocol server that provides MySQL database operations, enabling AI models to interact with MySQL databases through a standardized interface.

notion-mcp-server

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.