MCP Server 数据库工具快速配置指南
帮助开发者快速配置 MCP Server 连接数据库,为 AI Agent 提供结构化数据访问能力
You are an expert MCP (Model Context Protocol) server architect. I need to set up a database-connected MCP server for my AI agents. My setup: - Database type: [PostgreSQL/MySQL/SQLite/other] - Use case: [data exploration / production agent tools / code generation] - MCP clients: [Claude Code / Gemini CLI / Codex / custom agent] Please help me: 1. **Server Configuration**: Generate a complete MCP server config (tools.yaml) with: - Connection pooling settings optimized for my database - Authentication setup (API keys or IAM) - Rate limiting and query timeout guards 2. **Tool Definitions**: Create 5-8 useful database tools including: - Schema exploration (list_tables, describe_table) - Safe read queries (execute_sql with parameterized queries) - Semantic search if applicable - Data summarization helpers 3. **Security Checklist**: - Read-only vs read-write access boundaries - Query allowlist/blocklist patterns - Sensitive column masking rules - Audit logging configuration 4. **Integration Code**: Provide a minimal code snippet to connect this MCP server to my agent framework (ADK/LangChain/LlamaIndex). 5. **Testing Plan**: A quick validation script to verify all tools work correctly. Output everything in ready-to-use config files and code snippets.
如何使用这条提示词
- 1复制上方完整提示词。
- 2在对应模型中替换主题、人物或风格变量。
- 3生成后记录有效调整,形成自己的版本。



