MCP Server: PostgreSQL Docker Initializer

@Flow-Research

代码仓库

基本信息

分类

数据库

传输方式

stdio

作者

Flow-Research

关于 MCP Server: PostgreSQL Docker Initializer

暂无概览

#mcp-server #postgresql#docker-initializer

MCP Server: PostgreSQL Docker Initializer 配置

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

{
  "mcpServers": {
    "mcp-server-postgres-init": {
      "command": "npx",
      "args": [
        "@modelcontextprotocol/inspector",
        "node",
        "build/index.js"
      ]
    }
  }
}

MCP Server: PostgreSQL Docker Initializer 工具

工具列表暂未提供

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

点击上方按钮,在临时沙箱中运行此服务器并实时获取工具列表。

概览

What is MCP Server: PostgreSQL Docker Initializer?

This MCP server provides a single tool (init-postgres-docker) that initializes a PostgreSQL database inside a new Docker container. It is designed for developers who need a quick, disposable PostgreSQL instance for development or testing.

How to use MCP Server: PostgreSQL Docker Initializer?

Install dependencies with make install or npm install, build with make build or npm run build, then run the server. Use make inspect to interact via the MCP inspector, or run node build/index.js directly to connect with an MCP client. The tool is invoked by sending a request with a database name.

Key features of MCP Server: PostgreSQL Docker Initializer

Exposes a single tool, init-postgres-docker
Pulls postgres:latest Docker image automatically
Creates a PostgreSQL container with a specified database name
Maps container port 5432 to a random available host port
Sets container to auto-remove when stopped
Returns a PostgreSQL connection URL (e.g., postgresql://pguser:mysecretpassword@localhost:<hostPort>/<dbName>)

Use cases of MCP Server: PostgreSQL Docker Initializer

Quickly spin up a throwaway PostgreSQL database for local development
Automate database provisioning in CI/CD pipelines or testing environments
Provide a temporary database for demonstrations or tutorials

常见问题

What does the `init-postgres-docker` tool do?

It creates a new Docker container running PostgreSQL with a specified database name, a default user (`pguser`), and a default password (`mysecretpassword`), then returns the connection URL.

What are the prerequisites to run this server?

Node.js and npm (or a compatible package manager), Docker (must be running), and Make.

Is the default password secure?

No, the password `mysecretpassword` is hardcoded and insecure. This server is intended for demonstration purposes only; real-world use should implement a more secure password method.

Does the PostgreSQL container persist after stopping?

No, the container is set to auto-remove (`AutoRemove: true`). Consider the lifecycle needed for your use case.

How can I run the server without the Makefile?

Install dependencies with `npm install`, build with `npm run build`, then run `node build/index.js` directly or use the MCP inspector with `npx @modelcontextprotocol/inspector node build/index.js`.

数据库分类下的更多 MCP 服务器

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 Alchemy

runekaagaard

A MCP (model context protocol) server that gives the LLM access to and knowledge about relational databases like SQLite, Postgresql, MySQL & MariaDB, Oracle, and MS-SQL.

412