PgSQL MCP Server

@twn39

代码仓库

基本信息

分类

其他

传输方式

stdio

作者

twn39

关于 PgSQL MCP Server

🔧 A powerful tool server based on the Model Context Protocol (MCP), enabling interaction with PostgreSQL databases via MCP calls.

#python #ai #mcp #postgresql#pgsql#mcp-server

PgSQL MCP Server 配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "mcpServers": {
    "pgsql-mcp-server-twn39": {
      "command": "uv",
      "args": [
        "tool",
        "install",
        "pgsql-mcp-server"
      ]
    }
  }
}

PgSQL MCP Server 工具

工具列表暂未提供

当前收录暂时没有可展示的工具列表，不代表服务没有工具。请查阅项目文档了解支持的能力。

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

What is PgSQL MCP Server?

PgSQL MCP Server is a tool built on the Model Context Protocol (MCP) that enables interaction with PostgreSQL databases via MCP calls. It is designed for developers who need to query, manage, and explore PostgreSQL schemas and data through MCP-enabled clients.

How to use PgSQL MCP Server?

Install with uv tool install pgsql-mcp-server or pip install pgsql-mcp-server. Run using pgsql-mcp-server --dsn "postgresql://user:password@localhost:5432/db", or execute directly without installation via uvx pgsql-mcp-server --dsn "...".

Key features of PgSQL MCP Server

Asynchronous and efficient using asyncio and asyncpg.
Transactional safety with error handling and rollback.
Easy deployment via a simple command-line interface.
Provides DQL, DML, DDL, and DCL query execution tools.
Supports schema, table, column, index, and foreign key introspection.

Use cases of PgSQL MCP Server

Run SQL queries (SELECT, INSERT, UPDATE, DELETE) through MCP.
Execute transactional DDL and DCL operations via MCP calls.
Explore database metadata (schemas, tables, columns, indexes, foreign keys).
Debug and test MCP database interactions using the MCP Inspector.

常见问题

What Python version is required?

Python 3.10 or higher is required.

How do I install the server?

Install using `uv tool install pgsql-mcp-server` or `pip install pgsql-mcp-server`. You can also run directly with `uvx pgsql-mcp-server`.

What tools does the server provide?

It offers nine tools: get_schema_names, get_tables, get_columns, get_indexes, get_foreign_keys, run_dql_query, run_dml_query, run_ddl_query, and run_dcl_query.

How can I test or debug the server?

Use the MCP Inspector: run `npx @modelcontextprotocol/inspector uvx pgsql-mcp-server --dsn "..."` to visually inspect and test tools.

Are DDL and DML operations transactional?

Yes, DDL, DML, and DCL operations are executed within transactions with error handling and rollback mechanisms.

其他分类下的更多 MCP 服务器

Activepieces

activepieces

AI Agents & MCPs & AI Workflow Automation • (~400 MCP servers for AI agents) • AI Automation / AI Agent with MCPs • AI Workflows & AI Agents • MCPs for AI Agents

23.2K

Glasswarp

See and control a real Windows PC you own — from any MCP client, locally or remotely. Observe (UIA + screenshots), click/type/drag/scroll, launch apps, owner Live View. BYOH: your machine, your key.