Is postgres-mcp-server safe for production databases?
No, it is experimental; do not use it on real databases and be careful with write queries.
Postgres MCP Server
@RonHouben
基本情報
Postgres MCP Server について
MCP Server for postgres
Postgres MCP Server の設定
Postgres MCP Server のツール
ツール一覧はまだありません
この掲載には表示できるツール一覧がまだありません。サーバーにツールがないという意味ではありません。対応機能はプロジェクトのドキュメントをご確認ください。
ツールは README から自動的に抽出されます。メンテナーは ## Tools という見出しの下に記載することで、このタブに反映できます。
概要
What is postgres-mcp-server?
A PostgreSQL Model Context Protocol server that lets an LLM interact with a local database. It is experimental and not intended for real databases.
How to use postgres-mcp-server?
Install Node.js, run npm install, and set the environment variables DATABASE_NAME, DATABASE_USER, DATABASE_PASSWORD, and DATABASE_SCHEMA_NAME. A VSCode configuration snippet is provided to integrate the server via stdio.
Key features of postgres-mcp-server
- Experimental PostgreSQL MCP server for local databases
- Connects using environment variable configuration
- Supports read and write SQL queries
- Runs via npm start with stdio transport
- Integrates with VSCode chat’s MCP discovery
Use cases of postgres-mcp-server
- Letting an LLM query a local development database
- Experimenting with database interactions in a safe environment
よくある質問
What are the prerequisites to run postgres-mcp-server?
You need Node.js installed and must run `npm install` to install dependencies.
What environment variables are required?
`DATABASE_NAME`, `DATABASE_USER`, `DATABASE_PASSWORD`, and `DATABASE_SCHEMA_NAME` (typically `public`).
How do I configure postgres-mcp-server in VSCode?
Add a configuration block in your `settings.json` with the command `npm`, type `stdio`, args `["start", "--prefix", "/path/to/code/postgres-mcp-server"]`, and set the required environment variables.
What transport does postgres-mcp-server use?
It uses stdio transport, as shown in the VSCode configuration example.
「データベース」の他のコンテンツ
Chroma MCP Server
chroma-coreA Model Context Protocol (MCP) server implementation that provides database capabilities for Chroma
569
Xata MCP Server
The Xata MCP server lets AI assistants and agents interact with your Xata organizations, projects, and Postgres database branches.
ClickHouse MCP Server
ClickHouseConnect ClickHouse to your AI assistants.
818
Neon MCP Server
neondatabase-labsMCP server for interacting with Neon Management API and databases
617
MCP Server for MySQL based on NodeJS
benborlaA 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
コメント