MEC Postgres MCP Server

@Pratye

リポジトリ

基本情報

カテゴリ

データベース

トランスポート

stdio

作者

Pratye

投稿者

Pratye Aggarwal

MEC Postgres MCP Server について

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

#postgresql #postgres #database

MEC Postgres MCP Server の設定

以下の設定を使って、このサーバーを MCP 対応クライアントに追加してください。

{
  "mcpServers": {
    "postgres": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "mcp/postgres",
        "postgresql://host.docker.internal:5432/mydb"
      ]
    }
  }
}

MEC Postgres MCP Server のツール

Execute read-only SQL queries against the connected database

Upload and process a CSV file into database tables

概要

What is MEC Postgres?

MEC Postgres is a Model Context Protocol (MCP) server that provides read and write access to PostgreSQL databases. It enables LLMs to inspect database schemas and execute SQL queries.

How to use MEC Postgres?

Use with Claude Desktop by adding the server configuration to the mcpServers section of claude_desktop_config.json. The server runs via Docker and connects to a PostgreSQL database using a connection URL (e.g., postgresql://user:password@host:port/db-name). Replace the database name and credentials as needed.

Key features of MEC Postgres

Execute read-only SQL queries against PostgreSQL
Upload and process CSV files into database tables
Automatically discover table schemas as JSON resources
Deploy via Docker for easy setup with Claude Desktop
All queries use transactions (read-only or read-write)

Use cases of MEC Postgres

Allow an LLM to explore database schema before generating queries
Enable an LLM to execute analytical read queries on business data
Let an LLM ingest CSV data into a PostgreSQL table for further analysis
Provide database schema information to an LLM for context‑aware responses

よくある質問

What is the difference between the query and uploadCsv tools?

`query` executes read-only SQL queries within a READ ONLY transaction; `uploadCsv` executes read and write queries within a READ AND WRITE transaction.

How do I connect to a PostgreSQL database?

Use a PostgreSQL connection URL (e.g., `postgresql://user:password@host:port/db-name`) when running the Docker container.

Does the server support authentication?

Yes, username and password can be included in the PostgreSQL connection URL.

What runtime is required to run MEC Postgres?

The server is distributed as a Docker image; Docker is required to run it.

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

Redis MCP Server

redis

The official Redis MCP Server is a natural language interface designed for agentic applications to manage and search data in Redis efficiently

539

MySQL MCP Server

designcomputer

A Model Context Protocol (MCP) server that enables secure interaction with MySQL databases

1.3K

MCP DB Wizard

srmadscience

Oracle MCP server with no run-sql tool: It generates tools for each of the PL/SQL procedures, tables and approved SQL you choose. The server doesn't expose a SQL prompt, and can't reveal how it's connected to Oracle.