CodeNexus-ai/MCP-Server-postgres

3.1

If you are the rightful owner of MCP-Server-postgres 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.

The MCP PostgreSQL server provides a structured way to manage and interact with PostgreSQL databases using a model context protocol.

Tools

Functions exposed to the LLM to take actions

list_tables_tool

API entry point for listing available tables in the database.

get_table_info_tool

API entry point for retrieving detailed information about a specific table.

query_table_tool

API entry point for querying data from a specified table with an optional limit on the number of rows returned.

execute_query_tool

API entry point for executing custom SQL queries with optional parameters.

Prompts

Interactive templates invoked by user choice

No prompts

Resources

Contextual data attached and managed by the client

No resources

Related MCP Servers

View all databases servers →

dbhub

4.5

by bytebase

DBHub is a universal database gateway implementing the Model Context Protocol (MCP) server interface.

databases

mcp-pinecone

4.4

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

pg-mcp-server

4.4

by stuzero

unknown

databases

mcp-alchemy

4.4

by runekaagaard

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

databases

mcp-server-duckdb

4.2

by ktanaka101

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

databases

supabase-mcp

4.2

by supabase-community

Connect your Supabase projects to AI assistants using the Model Context Protocol (MCP) server.

databases

python-mcp-server-client

4.2

by GobinFan

MCP Server is a server implementing the Model Context Protocol (MCP) to provide a standardized interface for AI models, connecting external data sources and tools like file systems, databases, or APIs.

ai_chatbot

prisma

4.1

by prisma

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

databases

mcp-graphql

4.0

by blurrah

A Model Context Protocol server that enables LLMs to interact with GraphQL APIs, providing schema introspection and query execution capabilities.

databases

db-mcp-server

3.9

by FreePeak

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

databases

supabase-mcp

3.9

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

doris-mcp-server

3.9

by apache

Doris MCP Server is a backend service built with Python and FastAPI, designed to connect to Apache Doris databases and potentially leverage LLMs for tasks like NL2SQL.

databases

mcp-server-neon

3.9

by neondatabase

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

databases

postgresql-mcp-server

3.9

by HenkDz

A Model Context Protocol (MCP) server that provides comprehensive PostgreSQL database management capabilities for AI assistants.

databases

airtable-mcp

3.8

by felores

A Model Context Protocol server for interacting with Airtable's API, enabling programmatic management of Airtable bases, tables, fields, and records.

databases

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

mcp-databricks-server

3.7

by RafaelCartenet

This is a Model Context Protocol (MCP) server for executing SQL queries against Databricks using the Statement Execution API.

databases

openehr-mcp-server

3.7

by deak-ai

An MCP server designed to interface with openEHR REST APIs, specifically the EHRbase implementation.

databases

airtable-mcp-server

3.7

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

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

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

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

xiyan_mcp_server

3.6

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.

databases

prometheus-mcp-server

3.6

by pab1it0

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

databases

mcp-database-server

3.6

by executeautomation

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

databases

mongodb-lens

3.6

by furey

MongoDB Lens is a local Model Context Protocol (MCP) server that provides full-featured access to MongoDB databases using natural language via LLMs.

databases

mssql_mcp_server

3.6

by RichardHan

A Model Context Protocol (MCP) server that enables secure interaction with Microsoft SQL Server databases.

databases