広告掲載
MCP.so
ログイン

PostgreSQL MCP Server

@tobecrazy

リポジトリ

基本情報

カテゴリ

データベース

トランスポート

stdio

作者

tobecrazy

PostgreSQL MCP Server について

A postgresql-mcp server

PostgreSQL MCP Server の設定

標準の設定はありません

このサーバーの README には解析可能な MCP 設定ブロックが含まれていません。インストール手順はリポジトリをご確認ください。

リポジトリ

PostgreSQL MCP Server のツール

ツール一覧はまだありません

この掲載には表示できるツール一覧がまだありません。サーバーにツールがないという意味ではありません。対応機能はプロジェクトのドキュメントをご確認ください。

ツールは README から自動的に抽出されます。メンテナーは ## Tools という見出しの下に記載することで、このタブに反映できます。

概要

What is PostgreSQL MCP Server?

PostgreSQL MCP Server is a Model Context Protocol server that provides CRUD operations for PostgreSQL database tables through a set of MCP tools. It uses the FastMCP library, runs in stdio mode, and is compatible with various MCP clients.

How to use PostgreSQL MCP Server?

Clone the repository, install dependencies with pip install -r requirements.txt, edit the config.yaml file with database credentials and table permissions, then run python postgresql_mcp_server.py to start the server in stdio mode.

Key features of PostgreSQL MCP Server

  • Connect to PostgreSQL databases
  • Perform CRUD operations on specified tables
  • Table and column-level access control
  • Schema inspection
  • Custom SQL query execution
  • Configuration via YAML file

Use cases of PostgreSQL MCP Server

  • Query and modify PostgreSQL tables from an MCP-compatible language model
  • Inspect table schemas to understand database structure
  • Execute parameterized custom SQL queries
  • Manage data with configurable per-table and per-column permissions

よくある質問

1

What dependencies are required?

Python 3 with the FastMCP package and other dependencies listed in `requirements.txt` (install via `pip install -r requirements.txt`).

2

How is access to tables and columns controlled?

Access is configured in the `config.yaml` file, where you specify which tables are accessible, which columns are allowed for operations, and which operations (create, read, update, delete) are permitted per table.

3

What transport mode does the server use?

The server runs in stdio mode, making it compatible with MCP clients that communicate over standard input and output.

4

Is there a security risk with the execute_query tool?

Yes. The `execute_query` tool allows arbitrary SQL execution. The README advises considering restricting its use or implementing additional validation, as this could be a security risk if not carefully managed.

5

How are database credentials stored?

Database credentials are stored in plain text in the `config.yaml` file. The README recommends using environment variables or a secure secret management solution in production.

コメント

「データベース」の他のコンテンツ

MCP Server for MySQL based on NodeJS

benborla

A Model Context Protocol server that provides read-only access to MySQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.

1.9K

Postgres Mcp

crystaldba

Postgres MCP Pro provides configurable read/write access and performance analysis for you and your AI agents.

3.0K

Redis

modelcontextprotocol

Model Context Protocol Servers

88.2K

golfdata.online - Verified Golf Clubs

golfdata.online

Verified golf club data for AI agents: holes, par, address, phone, booking links, facilities, visitor rules and green fees for golf clubs in Spain (Canary Islands and mainland), expanding across Europe. Every fact comes

mcp-server-qdrant: A Qdrant MCP server

qdrant

An official Qdrant Model Context Protocol (MCP) server implementation

637
広告掲載