# 🚀 my-mcp-servers
一个包含多个Model Context Protocol (MCP)服务器实现的开源项目，为AI助手提供数据库访问、图像生成等功能集成。
## ✨ 特性
- 🗄️ **PostgreSQL集成** - 完整的数据库访问和分析能力
- 🎨 **AI图像生成** - 基于阿里云百炼平台的图像生成与编辑
- 🔒 **安全设计** - 只读数据库访问，SQL注入防护
- 🏗️ **模块化架构** - 独立的服务器模块，易于扩展
- 📦 **即装即用** - 支持uv和pip安装方式
## 🛠️ 服务器列表
### 📊 PostgreSQL MCP服务器
提供与PostgreSQL数据库交互的完整功能：
**核心功能：**
- 📋 **资源管理** - 获取表结构、索引信息
- 🔍 **查询执行** - 安全的只读SQL查询
- 📈 **数据分析** - 表统计信息和样本数据
- 💡 **智能提示** - 数据探索、性能优化、业务洞察分析
**安全特性：**
- 只读访问（仅支持SELECT和WITH查询）
- SQL注入防护
- 查询结果限制（最多100行）
- 自动连接管理
### 🎨 阿里云百炼生图API MCP服务器
基于阿里云百炼平台的图像生成和编辑服务：
**核心功能：**
- 🖼️ **图像生成** - 基于文本提示生成高质量图像
- ✏️ **图像编辑** - 智能图像修改和优化
- 📏 **多种分辨率** - 支持1:1、16:9、4:3等多种比例
- 🎯 **智能提示** - 自动提示词优化和反向提示
**技术特性：**
- 异步任务处理
- 多种输出格式
- 水印控制
- Docker部署支持
## 🚀 快速开始
### 环境要求
- Python 3.8+
- PostgreSQL (用于数据库服务器)
- 阿里云百炼API密钥 (用于图像生成服务器)
### 安装
#### 使用 uv (推荐)
```bash
# 无需特定安装，使用uvx直接运行
uvx --from my-mcp-servers postgresql-mcp-server
uvx --from my-mcp-servers bailian-mcp-server
```
#### 使用 pip
```bash
pip install -e .
```
### 配置示例
#### Claude.app 配置
```json
{
"mcpServers": {
"postgresql": {
"command": "uvx",
"args": ["--from", "my-mcp-servers", "postgresql-mcp-server"],
"env": {
"DB_HOST": "localhost",
"DB_PORT": "5432",
"DB_NAME": "your_database",
"DB_USER": "your_user",
"DB_PASSWORD": "your_password"
}
},
"bailian-image": {
"command": "uvx",
"args": ["--from", "my-mcp-servers", "bailian-mcp-server"],
"env": {
"DASHSCOPE_API_KEY": "your_api_key"
}
}
}
}
```
## 📖 使用指南
### PostgreSQL服务器
与AI助手对话示例：
- "显示数据库中的所有表"
- "分析users表的结构"
- "查询sales表的前10条记录"
- "为orders表生成数据质量报告"
### 图像生成服务器
与AI助手对话示例：
- "生成一张1328x1328像素的猫咪图片"
- "创建一个16:9比例的城市夜景"
- "编辑这张图片，将天空改为蓝色"
## 🏗️ 项目结构
```
my-mcp-servers/
├── src/
│ ├── postgresql/ # PostgreSQL MCP服务器
│ │ ├── pg_mcpserver.py
│ │ └── README.md
│ └── gen_images/ # 阿里云百炼生图MCP服务器
│ ├── bailian_mcpserver.py
│ ├── docker-compose.yml
│ ├── Dockerfile
│ └── README.md
├── tests/ # 测试文件
├── script/ # 部署脚本
└── pyproject.toml # 项目配置
```
## 🤝 贡献指南
我们欢迎各种形式的贡献：
1. **🐛 报告问题** - 发现bug请提交issue
2. **💡 功能建议** - 有好想法欢迎讨论
3. **🔧 代码贡献** - 提交Pull Request
4. **📚 文档改进** - 帮助完善文档
### 开发环境
```bash
# 克隆仓库
git clone https://github.com/yidasanqian/my-mcp-servers.git
cd my-mcp-servers
# 安装依赖
uv sync
# 运行测试
uv run pytest
```
## 📄 许可证
本项目采用 [MIT许可证](LICENSE)。
## 🔗 相关链接
- [Model Context Protocol](https://modelcontextprotocol.io/)
- [阿里云百炼平台](https://bailian.console.aliyun.com/)
- [PostgreSQL](https://www.postgresql.org/)
## 💬 联系与支持
- 📧 Issues: [GitHub Issues](https://github.com/yidasanqian/my-mcp-servers/issues)
- 💬 讨论: [GitHub Discussions](https://github.com/yidasanqian/my-mcp-servers/discussions)
---
⭐ 如果这个项目对您有帮助，请给个星标支持！
Raw data
{
"_id": null,
"home_page": null,
"name": "my-mcp-servers",
"maintainer": null,
"docs_url": null,
"requires_python": ">=3.11",
"maintainer_email": null,
"keywords": "alibaba-cloud, bailian, image-generation, mcp, model-context-protocol, postgresql",
"author": null,
"author_email": "yidasanqian <yidasanqian@gmail.com>",
"download_url": "https://files.pythonhosted.org/packages/53/78/05750d47025946d3e04b5caabb80b96e3e5f0933ec6eb6a180db9b04009e/my_mcp_servers-0.1.7.tar.gz",
"platform": null,
"description": "# \ud83d\ude80 my-mcp-servers\n\n\n\n\n\n\u4e00\u4e2a\u5305\u542b\u591a\u4e2aModel Context Protocol (MCP)\u670d\u52a1\u5668\u5b9e\u73b0\u7684\u5f00\u6e90\u9879\u76ee\uff0c\u4e3aAI\u52a9\u624b\u63d0\u4f9b\u6570\u636e\u5e93\u8bbf\u95ee\u3001\u56fe\u50cf\u751f\u6210\u7b49\u529f\u80fd\u96c6\u6210\u3002\n\n## \u2728 \u7279\u6027\n\n- \ud83d\uddc4\ufe0f **PostgreSQL\u96c6\u6210** - \u5b8c\u6574\u7684\u6570\u636e\u5e93\u8bbf\u95ee\u548c\u5206\u6790\u80fd\u529b\n- \ud83c\udfa8 **AI\u56fe\u50cf\u751f\u6210** - \u57fa\u4e8e\u963f\u91cc\u4e91\u767e\u70bc\u5e73\u53f0\u7684\u56fe\u50cf\u751f\u6210\u4e0e\u7f16\u8f91\n- \ud83d\udd12 **\u5b89\u5168\u8bbe\u8ba1** - \u53ea\u8bfb\u6570\u636e\u5e93\u8bbf\u95ee\uff0cSQL\u6ce8\u5165\u9632\u62a4\n- \ud83c\udfd7\ufe0f **\u6a21\u5757\u5316\u67b6\u6784** - \u72ec\u7acb\u7684\u670d\u52a1\u5668\u6a21\u5757\uff0c\u6613\u4e8e\u6269\u5c55\n- \ud83d\udce6 **\u5373\u88c5\u5373\u7528** - \u652f\u6301uv\u548cpip\u5b89\u88c5\u65b9\u5f0f\n\n## \ud83d\udee0\ufe0f \u670d\u52a1\u5668\u5217\u8868\n\n### \ud83d\udcca PostgreSQL MCP\u670d\u52a1\u5668\n\n\u63d0\u4f9b\u4e0ePostgreSQL\u6570\u636e\u5e93\u4ea4\u4e92\u7684\u5b8c\u6574\u529f\u80fd\uff1a\n\n**\u6838\u5fc3\u529f\u80fd\uff1a**\n- \ud83d\udccb **\u8d44\u6e90\u7ba1\u7406** - \u83b7\u53d6\u8868\u7ed3\u6784\u3001\u7d22\u5f15\u4fe1\u606f\n- \ud83d\udd0d **\u67e5\u8be2\u6267\u884c** - \u5b89\u5168\u7684\u53ea\u8bfbSQL\u67e5\u8be2\n- \ud83d\udcc8 **\u6570\u636e\u5206\u6790** - \u8868\u7edf\u8ba1\u4fe1\u606f\u548c\u6837\u672c\u6570\u636e\n- \ud83d\udca1 **\u667a\u80fd\u63d0\u793a** - \u6570\u636e\u63a2\u7d22\u3001\u6027\u80fd\u4f18\u5316\u3001\u4e1a\u52a1\u6d1e\u5bdf\u5206\u6790\n\n**\u5b89\u5168\u7279\u6027\uff1a**\n- \u53ea\u8bfb\u8bbf\u95ee\uff08\u4ec5\u652f\u6301SELECT\u548cWITH\u67e5\u8be2\uff09\n- SQL\u6ce8\u5165\u9632\u62a4\n- \u67e5\u8be2\u7ed3\u679c\u9650\u5236\uff08\u6700\u591a100\u884c\uff09\n- \u81ea\u52a8\u8fde\u63a5\u7ba1\u7406\n\n### \ud83c\udfa8 \u963f\u91cc\u4e91\u767e\u70bc\u751f\u56feAPI MCP\u670d\u52a1\u5668\n\n\u57fa\u4e8e\u963f\u91cc\u4e91\u767e\u70bc\u5e73\u53f0\u7684\u56fe\u50cf\u751f\u6210\u548c\u7f16\u8f91\u670d\u52a1\uff1a\n\n**\u6838\u5fc3\u529f\u80fd\uff1a**\n- \ud83d\uddbc\ufe0f **\u56fe\u50cf\u751f\u6210** - \u57fa\u4e8e\u6587\u672c\u63d0\u793a\u751f\u6210\u9ad8\u8d28\u91cf\u56fe\u50cf\n- \u270f\ufe0f **\u56fe\u50cf\u7f16\u8f91** - \u667a\u80fd\u56fe\u50cf\u4fee\u6539\u548c\u4f18\u5316\n- \ud83d\udccf **\u591a\u79cd\u5206\u8fa8\u7387** - \u652f\u63011:1\u300116:9\u30014:3\u7b49\u591a\u79cd\u6bd4\u4f8b\n- \ud83c\udfaf **\u667a\u80fd\u63d0\u793a** - \u81ea\u52a8\u63d0\u793a\u8bcd\u4f18\u5316\u548c\u53cd\u5411\u63d0\u793a\n\n**\u6280\u672f\u7279\u6027\uff1a**\n- \u5f02\u6b65\u4efb\u52a1\u5904\u7406\n- \u591a\u79cd\u8f93\u51fa\u683c\u5f0f\n- \u6c34\u5370\u63a7\u5236\n- Docker\u90e8\u7f72\u652f\u6301\n\n## \ud83d\ude80 \u5feb\u901f\u5f00\u59cb\n\n### \u73af\u5883\u8981\u6c42\n\n- Python 3.8+\n- PostgreSQL (\u7528\u4e8e\u6570\u636e\u5e93\u670d\u52a1\u5668)\n- \u963f\u91cc\u4e91\u767e\u70bcAPI\u5bc6\u94a5 (\u7528\u4e8e\u56fe\u50cf\u751f\u6210\u670d\u52a1\u5668)\n\n### \u5b89\u88c5\n\n#### \u4f7f\u7528 uv (\u63a8\u8350)\n\n```bash\n# \u65e0\u9700\u7279\u5b9a\u5b89\u88c5\uff0c\u4f7f\u7528uvx\u76f4\u63a5\u8fd0\u884c\nuvx --from my-mcp-servers postgresql-mcp-server\nuvx --from my-mcp-servers bailian-mcp-server\n```\n\n#### \u4f7f\u7528 pip\n\n```bash\npip install -e .\n```\n\n### \u914d\u7f6e\u793a\u4f8b\n\n#### Claude.app \u914d\u7f6e\n\n```json\n{\n \"mcpServers\": {\n \"postgresql\": {\n \"command\": \"uvx\",\n \"args\": [\"--from\", \"my-mcp-servers\", \"postgresql-mcp-server\"],\n \"env\": {\n \"DB_HOST\": \"localhost\",\n \"DB_PORT\": \"5432\",\n \"DB_NAME\": \"your_database\",\n \"DB_USER\": \"your_user\",\n \"DB_PASSWORD\": \"your_password\"\n }\n },\n \"bailian-image\": {\n \"command\": \"uvx\",\n \"args\": [\"--from\", \"my-mcp-servers\", \"bailian-mcp-server\"],\n \"env\": {\n \"DASHSCOPE_API_KEY\": \"your_api_key\"\n }\n }\n }\n}\n```\n\n## \ud83d\udcd6 \u4f7f\u7528\u6307\u5357\n\n### PostgreSQL\u670d\u52a1\u5668\n\n\u4e0eAI\u52a9\u624b\u5bf9\u8bdd\u793a\u4f8b\uff1a\n- \"\u663e\u793a\u6570\u636e\u5e93\u4e2d\u7684\u6240\u6709\u8868\"\n- \"\u5206\u6790users\u8868\u7684\u7ed3\u6784\"\n- \"\u67e5\u8be2sales\u8868\u7684\u524d10\u6761\u8bb0\u5f55\"\n- \"\u4e3aorders\u8868\u751f\u6210\u6570\u636e\u8d28\u91cf\u62a5\u544a\"\n\n### \u56fe\u50cf\u751f\u6210\u670d\u52a1\u5668\n\n\u4e0eAI\u52a9\u624b\u5bf9\u8bdd\u793a\u4f8b\uff1a\n- \"\u751f\u6210\u4e00\u5f201328x1328\u50cf\u7d20\u7684\u732b\u54aa\u56fe\u7247\"\n- \"\u521b\u5efa\u4e00\u4e2a16:9\u6bd4\u4f8b\u7684\u57ce\u5e02\u591c\u666f\"\n- \"\u7f16\u8f91\u8fd9\u5f20\u56fe\u7247\uff0c\u5c06\u5929\u7a7a\u6539\u4e3a\u84dd\u8272\"\n\n## \ud83c\udfd7\ufe0f \u9879\u76ee\u7ed3\u6784\n\n```\nmy-mcp-servers/\n\u251c\u2500\u2500 src/\n\u2502 \u251c\u2500\u2500 postgresql/ # PostgreSQL MCP\u670d\u52a1\u5668\n\u2502 \u2502 \u251c\u2500\u2500 pg_mcpserver.py\n\u2502 \u2502 \u2514\u2500\u2500 README.md\n\u2502 \u2514\u2500\u2500 gen_images/ # \u963f\u91cc\u4e91\u767e\u70bc\u751f\u56feMCP\u670d\u52a1\u5668\n\u2502 \u251c\u2500\u2500 bailian_mcpserver.py\n\u2502 \u251c\u2500\u2500 docker-compose.yml\n\u2502 \u251c\u2500\u2500 Dockerfile\n\u2502 \u2514\u2500\u2500 README.md\n\u251c\u2500\u2500 tests/ # \u6d4b\u8bd5\u6587\u4ef6\n\u251c\u2500\u2500 script/ # \u90e8\u7f72\u811a\u672c\n\u2514\u2500\u2500 pyproject.toml # \u9879\u76ee\u914d\u7f6e\n```\n\n## \ud83e\udd1d \u8d21\u732e\u6307\u5357\n\n\u6211\u4eec\u6b22\u8fce\u5404\u79cd\u5f62\u5f0f\u7684\u8d21\u732e\uff1a\n\n1. **\ud83d\udc1b \u62a5\u544a\u95ee\u9898** - \u53d1\u73b0bug\u8bf7\u63d0\u4ea4issue\n2. **\ud83d\udca1 \u529f\u80fd\u5efa\u8bae** - \u6709\u597d\u60f3\u6cd5\u6b22\u8fce\u8ba8\u8bba\n3. **\ud83d\udd27 \u4ee3\u7801\u8d21\u732e** - \u63d0\u4ea4Pull Request\n4. **\ud83d\udcda \u6587\u6863\u6539\u8fdb** - \u5e2e\u52a9\u5b8c\u5584\u6587\u6863\n\n### \u5f00\u53d1\u73af\u5883\n\n```bash\n# \u514b\u9686\u4ed3\u5e93\ngit clone https://github.com/yidasanqian/my-mcp-servers.git\ncd my-mcp-servers\n\n# \u5b89\u88c5\u4f9d\u8d56\nuv sync\n\n# \u8fd0\u884c\u6d4b\u8bd5\nuv run pytest\n```\n\n## \ud83d\udcc4 \u8bb8\u53ef\u8bc1\n\n\u672c\u9879\u76ee\u91c7\u7528 [MIT\u8bb8\u53ef\u8bc1](LICENSE)\u3002\n\n## \ud83d\udd17 \u76f8\u5173\u94fe\u63a5\n\n- [Model Context Protocol](https://modelcontextprotocol.io/)\n- [\u963f\u91cc\u4e91\u767e\u70bc\u5e73\u53f0](https://bailian.console.aliyun.com/)\n- [PostgreSQL](https://www.postgresql.org/)\n\n## \ud83d\udcac \u8054\u7cfb\u4e0e\u652f\u6301\n\n- \ud83d\udce7 Issues: [GitHub Issues](https://github.com/yidasanqian/my-mcp-servers/issues)\n- \ud83d\udcac \u8ba8\u8bba: [GitHub Discussions](https://github.com/yidasanqian/my-mcp-servers/discussions)\n\n---\n\n\u2b50 \u5982\u679c\u8fd9\u4e2a\u9879\u76ee\u5bf9\u60a8\u6709\u5e2e\u52a9\uff0c\u8bf7\u7ed9\u4e2a\u661f\u6807\u652f\u6301\uff01",
"bugtrack_url": null,
"license": "MIT",
"summary": "Model Context Protocol servers for PostgreSQL and Alibaba Cloud Bailian image generation",
"version": "0.1.7",
"project_urls": {
"Homepage": "https://github.com/yidasanqian/my-mcp-servers",
"Issues": "https://github.com/yidasanqian/my-mcp-servers/issues",
"Repository": "https://github.com/yidasanqian/my-mcp-servers"
},
"split_keywords": [
"alibaba-cloud",
" bailian",
" image-generation",
" mcp",
" model-context-protocol",
" postgresql"
],
"urls": [
{
"comment_text": null,
"digests": {
"blake2b_256": "b9b865528aa14dd019d5a3e0b6eaef08fe39e923edde66a88a9cfb3e038978f9",
"md5": "fd613e511de4fc87925e0fd38a507843",
"sha256": "b7e8d6bd67fd405d185b10bc7cbb93383fba2a60daf1b9901ffad7155e607b2c"
},
"downloads": -1,
"filename": "my_mcp_servers-0.1.7-py3-none-any.whl",
"has_sig": false,
"md5_digest": "fd613e511de4fc87925e0fd38a507843",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": ">=3.11",
"size": 19085,
"upload_time": "2025-08-20T14:54:50",
"upload_time_iso_8601": "2025-08-20T14:54:50.000693Z",
"url": "https://files.pythonhosted.org/packages/b9/b8/65528aa14dd019d5a3e0b6eaef08fe39e923edde66a88a9cfb3e038978f9/my_mcp_servers-0.1.7-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": null,
"digests": {
"blake2b_256": "537805750d47025946d3e04b5caabb80b96e3e5f0933ec6eb6a180db9b04009e",
"md5": "f07746179e0bf3ee6c0e3bb6d2ece34e",
"sha256": "5f709a4a55ec722b230e1105769254c4a0171f7e4d3138fe1e62ce8c67bcf85f"
},
"downloads": -1,
"filename": "my_mcp_servers-0.1.7.tar.gz",
"has_sig": false,
"md5_digest": "f07746179e0bf3ee6c0e3bb6d2ece34e",
"packagetype": "sdist",
"python_version": "source",
"requires_python": ">=3.11",
"size": 16755,
"upload_time": "2025-08-20T14:54:51",
"upload_time_iso_8601": "2025-08-20T14:54:51.089794Z",
"url": "https://files.pythonhosted.org/packages/53/78/05750d47025946d3e04b5caabb80b96e3e5f0933ec6eb6a180db9b04009e/my_mcp_servers-0.1.7.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2025-08-20 14:54:51",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "yidasanqian",
"github_project": "my-mcp-servers",
"travis_ci": false,
"coveralls": false,
"github_actions": false,
"lcname": "my-mcp-servers"
}
JSON
