Is this server read-only?
Yes. All queries are executed inside a READ ONLY transaction, preventing any data modification.
PostgreSQL MCP Server
@vinsidious
基本信息
关于 PostgreSQL MCP Server
MCP server for getting schema information from a PostgreSQL database
PostgreSQL MCP Server 配置
使用下面的配置,将此服务器添加到你的 MCP 客户端。
{
"mcpServers": {
"mcp-pg-schema": {
"command": "docker",
"args": [
"build",
"-t",
"mcp/postgres",
"-f",
"src/postgres/Dockerfile",
"."
]
}
}
}PostgreSQL MCP Server 工具
1Execute read-only SQL queries against the connected database
概览
What is PostgreSQL?
A Model Context Protocol server that provides read-only access to PostgreSQL databases, enabling LLMs to inspect database schemas and execute read-only SQL queries.
How to use PostgreSQL?
Configure the server in the claude_desktop_config.json under mcpServers using either Docker (run mcp/postgres image) or NPX (@modelcontextprotocol/server-postgres). Provide a PostgreSQL connection URL (e.g., postgresql://host.docker.internal:5432/mydb) as an argument.
Key features of PostgreSQL
- Execute read-only SQL queries via the
querytool. - Automatically discover and serve table schemas as JSON resources.
- All queries run within a READ ONLY transaction.
- Supports Docker and NPX deployment methods.
- MIT licensed.
Use cases of PostgreSQL
- Let an LLM explore table structures and column types before generating queries.
- Allow an LLM to run safe, read-only SELECT statements against a live database.
- Provide database schema context to an AI assistant for answering questions about data.
常见问题
What are the runtime requirements?
You need a running PostgreSQL database and either Docker or Node.js (for NPX). The server connects to the database via the provided URL.
How do I specify authentication credentials?
Include username and password in the PostgreSQL connection URL, e.g., `postgresql://user:password@host:port/db-name`.
Where does schema data come from?
Schema information is automatically discovered from the connected database's metadata. Each table's JSON schema includes column names and data types.
What transport does this server use?
The server follows the Model Context Protocol (stdio-based transport as typical for Claude Desktop MCP servers). The README does not detail other transport options.
数据库 分类下的更多 MCP 服务器
nuzur
nuzur is a model-first database platform for MySQL and PostgreSQL. The MCP server lets any AI assistant or agent (Claude, Cursor, Gemini, or anything else that speaks MCP) design your schema, query your data, generate mi
NPILayer
NPILayerHealthcare provider data for AI assistants, from the official CMS NPPES dataset (updated weekly). Look up any NPI (active or deactivated), search providers and organizations by name, city, state, ZIP, taxonomy code or pl
ClickHouse MCP Server
ClickHouseConnect ClickHouse to your AI assistants.
818
golfdata.online - Verified Golf Clubs
golfdata.onlineVerified 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
runekaagaardA 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
评论