広告掲載
MCP.so
ログイン

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.

よくある質問

1

What Python version is required?

Python 3.10 or higher is required.

2

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`.

3

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.

4

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.

5

Are DDL and DML operations transactional?

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

コメント

「その他」の他のコンテンツ

Figs, Relationship Expert

Figs O'Sullivan, LMFT

Couples therapist Figs O'Sullivan (LMFT, 17 years, endorsed by Sue Johnson, creator of EFT) inside your AI. Ask relationship questions answered from his clinical writing, name the pattern in a fight, get a three-step rep

Klarix Intelligence Engine

Klarix

B2B competitive intelligence, live sales battlecards, 5-axis ICP prospect fit scoring, and tech stack teardowns over MCP and REST with cited public-web evidence.

Hindsight

vectorize-io

Hindsight: Agent Memory That Learns

50.4K
P

PickFu MCP

PickFu MCP is a Model Context Protocol (MCP) server that connects AI assistants, developers, marketers, product managers, and AI agents to PickFu's consumer research platform. It enables users to create surveys, conduct

🚀 Model Context Protocol (MCP) Curriculum for Beginners

microsoft

This open-source curriculum introduces the fundamentals of Model Context Protocol (MCP) through real-world, cross-language examples in .NET, Java, TypeScript, JavaScript, Rust and Python. Designed for developers, it focuses on practical techniques for building modular, scalable,

16.7K
広告掲載