MCP (Model Context Protocol) Server
@VajraM-dev
关于 MCP (Model Context Protocol) Server
暂无概览
基本信息
配置
使用下面的配置,将此服务器添加到你的 MCP 客户端。
{
"mcpServers": {
"Postgres-MCP-Server-With-SSE-Transport": {
"command": "python",
"args": [
"-m",
"venv",
"venv"
]
}
}
}工具
未检测到工具
工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。
概览
What is MCP (Model Context Protocol) Server?
A Python-based server that integrates PostgreSQL databases with AI providers (Anthropic, Google) using the Model Context Protocol, supporting flexible communication transports (SSE or stdio).
How to use MCP (Model Context Protocol) Server?
Clone the repository, create a Python virtual environment, install dependencies, configure environment by copying .env.example to .env.dev and filling in database and API credentials, then run python server.py for the server and python client.py for client interaction.
Key features of MCP (Model Context Protocol) Server
- Secure configuration management
- PostgreSQL database integration
- Multi-provider AI model support
- Flexible communication transport
- Extensible tool registration
Use cases of MCP (Model Context Protocol) Server
- Retrieve database table listings via AI prompts
- Extend server with custom tool functions using decorators
- Interact with PostgreSQL through a client script
FAQ from MCP (Model Context Protocol) Server
What are the prerequisites?
Python 3.10+, a PostgreSQL instance, and API access to Anthropic and/or Google AI providers.
How do I install and configure the server?
Clone the repo, create a virtual environment, run pip install -r requirements.txt, copy .env.example to .env.dev, and fill in database credentials, API keys, and transport settings.
Which AI providers are supported?
Anthropic (Claude models) and Google (Gemini models). The default provider is set via the USE_PROVIDER config.
What transport options are available?
The server supports both SSE (/sse endpoint) and stdio transports, configured via the TRANSPORT environment variable.
How can I add a new tool?
Use the @app.tool() decorator above a function definition; the function will be registered as a custom tool.
数据库 分类下的更多 MCP 服务器
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.
mcp-server-duckdb
ktanaka101A Model Context Protocol (MCP) server implementation for DuckDB, providing database interaction capabilities
MongoDB MCP Server
mongodb-jsA Model Context Protocol server to connect to MongoDB databases and MongoDB Atlas Clusters.
Chroma MCP Server
chroma-coreA Model Context Protocol (MCP) server implementation that provides database capabilities for Chroma
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.
评论