PostgreSQL MCP Server
PostgreSQL MCP server for LLM-database interaction. PostgreSQL MCP Server is a Model Context Protocol (MCP) server maintained by vignesh-codes. It connects to MCP-compatible clients such as Claude Desktop, Cursor, Cline, and other agents that speak the protocol. It exposes 6 tools, including query, create_table, insert_entry, update_entry, delete_entry and drop_table, that an agent can call directly. It is categorized under AI/LLM and Database/PostgreSQL.
What is this MCP
This is a Model Context Protocol server that enables Large Language Models (LLMs) to interact with PostgreSQL databases. It provides a standardized interface for LLMs to perform database operations including schema inspection, query execution, and CRUD operations.
How to use this MCP
Install via Docker, configure the PostgreSQL connection, and integrate with Claude Desktop by updating theclaude_desktop_config.json file. The server accepts JSON-formatted commands for database operations which can be sent through the Claude Desktop interface.
What this MCP can be used for
This MCP enables LLMs to directly work with PostgreSQL databases for tasks like data analysis, application development, and automated database management. It's particularly useful for creating AI agents that need persistent data storage or need to analyze structured data.
AIMCP authority
DR and traffic signal for the AIMCP public domain.
Frequently asked questions
What is the PostgreSQL MCP Server MCP server?
PostgreSQL MCP Server is a Model Context Protocol server from vignesh-codes. It lets MCP-compatible AI clients call its tools over a standard interface, so agents like Claude, Cursor, and Cline can use it without custom integration.
How do I connect PostgreSQL MCP Server to my AI client?
Add PostgreSQL MCP Server to your client's MCP configuration using the stdio or SSE connection shown in the usage examples on this page, then restart the client to load the server.
What tools does PostgreSQL MCP Server provide?
PostgreSQL MCP Server provides 6 tools: query, create_table, insert_entry, update_entry, delete_entry and drop_table.
Is PostgreSQL MCP Server free to use?
PostgreSQL MCP Server is listed on AIMCP for free. Any API keys or accounts required by the underlying service are set by its provider.
Vernclaw Plugins for OpenClaw
Ready-to-use connectors for SEO data, social reading & content generation. Pay-as-you-go credits with audit logs.