Home
MCP Servers
tobecrazy
postgresql-mcp

postgresql-mcp

3.1

If you are the rightful owner of postgresql-mcp 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.

A Model Context Protocol (MCP) server that provides CRUD operations for PostgreSQL database tables.

The PostgreSQL MCP Server is designed to facilitate interaction with PostgreSQL databases by offering a suite of tools for Create, Read, Update, and Delete (CRUD) operations on specified tables. Utilizing the FastMCP library, the server operates in stdio mode, ensuring compatibility with a variety of MCP clients. This server is particularly useful for developers and database administrators who need a streamlined method to manage database operations programmatically. The server's configuration is managed through a YAML file, which specifies database connection details, accessible tables, and permissible operations, ensuring a secure and customizable environment.

Features

Connect to PostgreSQL databases
Perform CRUD operations on specified tables
Table and column-level access control
Schema inspection
Custom SQL query execution

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-server-neon

by neondatabase-labs

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

mysql_mcp_server_pro

by wenb1n-dev

mcp_mysql_server_pro is a comprehensive MySQL server tool that extends beyond basic CRUD operations to include database anomaly analysis and custom tool extensions.

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

anyquery

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.

osv-mcp

by StacklokLabs

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

mcp-kql-server

by 4R9UN

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

mcp-google-sheets

by xing5

mcp-google-sheets is a Python-based MCP server that connects MCP-compatible clients to Google Sheets API for automation and data manipulation.

cloud_platforms

mongodb-mcp-server

by mongodb-js

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

mcp-proxy

by TBXark

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

db-mcp-server

by FreePeak

A powerful multi-database server implementing the Model Context Protocol (MCP) to provide AI assistants with structured access to databases.

mcp-server-motherduck

by motherduckdb

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

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-alchemy

by runekaagaard

MCP Alchemy is a model context protocol server that connects Claude Desktop to various databases, enabling advanced database exploration and query execution.

xiyan_mcp_server

by XGenerationLab

XiYan MCP Server is a Model Context Protocol server that enables natural language queries to databases, powered by XiYan-SQL, a state-of-the-art text-to-SQL model.

mongo-mcp

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.

mcp-server-splunk

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

prometheus-mcp-server

by pab1it0

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

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.

mcp-redis

by redis

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

MCPServerForMSSQL

by shakunvohradeltek

This repository contains the SQL Server MCP (Model Context Protocol) integration for Claude, allowing direct querying and analysis of SQL Server databases using natural language.

mcp-database-server

by executeautomation

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

mcp-tinybird

by tinybirdco

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

postgres-mcp-server

by aadarshjain

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

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.