MCP·266DB7
V

PostgreSQL MCP Server

By vignesh-codes·Visit Source
用于LLM与数据库交互的PostgreSQL MCP服务器
2025年1月28日
2 months ago
237 Clicks
About PostgreSQL MCP Server

用于LLM与数据库交互的PostgreSQL MCP服务器. 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.

什么是MCP

这是一个模型上下文协议服务器,使大型语言模型(LLM)能够与PostgreSQL数据库交互。它为LLM提供了执行数据库操作的标准接口,包括模式检查、查询执行和CRUD操作。

如何使用MCP

通过Docker安装,配置PostgreSQL连接,并通过更新claude_desktop_config.json文件与Claude Desktop集成。该服务器接受JSON格式的数据库操作命令,可通过Claude Desktop界面发送。

MCP的用途

该MCP使LLM能够直接操作PostgreSQL数据库,用于数据分析、应用程序开发和自动化数据库管理等任务。对于需要持久数据存储或需要分析结构化数据的AI代理创建特别有用。

Repository Info
Stars:
27
Forks:
11
Watchers:
27
Last Updated: 6 months ago

AIMCP authority

DR and traffic signal for the AIMCP public domain.

FAQ

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.

Sponsored

Vernclaw Plugins for OpenClaw

Ready-to-use connectors for SEO data, social reading & content generation. Pay-as-you-go credits with audit logs.