MCP 数据库工具 (MCP Database Utilities)
A secure bridge enabling AI systems safe, read-only access to multiple databases via unified configuration.
Key Features
Use Cases
README
MCP 数据库工具
English | Français | Español | العربية | Русский | 文档导航
简介
MCP Database Utilities 是一个多功能的 MCP 服务,它使您的 AI 能够通过统一的连接配置安全地访问各种类型的数据库(SQLite、MySQL、PostgreSQL 等)进行数据分析。
您可以将其视为 AI 系统和数据库之间的安全桥梁,允许 AI 在不直接访问数据库或冒数据修改风险的情况下读取和分析您的数据。
核心特性
- 安全优先:严格只读操作,无直接数据库访问,隔离连接,按需连接,自动超时
- 隐私保障:本地处理,最小数据暴露,凭证保护,敏感数据屏蔽
- 多数据库支持:使用相同的接口连接 SQLite、MySQL、PostgreSQL
- 简单配置:所有数据库连接使用单个 YAML 文件
- 高级功能:表格浏览、架构分析和查询执行
🔒 安全说明:MCP 数据库工具采用安全优先的架构设计,非常适合注重数据保护的企业、初创公司和个人用户。详细了解我们的安全架构。
快速入门
我们提供了多种安装方式,包括 uvx、Docker 和 Smithery。详细的安装和配置步骤请参阅安装指南。
基本步骤
示例交互
您:"能否列出我的数据库中的所有表?"
AI:"以下是您的数据库中的表:
- customers(客户)
- products(产品)
- orders(订单)
- inventory(库存)"
您:"customers 表的结构是什么样的?"
AI:"customers 表有以下结构:
- id(整数,主键)
- name(文本)
- email(文本)
- registration_date(日期)"
文档导航
入门指南
技术文档
- 架构设计 - 系统架构和组件说明
- 安全架构 - 安全特性和保护机制
- 开发指南 - 代码质量和开发流程
- 测试指南 - 测试框架和最佳实践
- SonarCloud 集成 - SonarCloud 与 AI 集成指南
示例文档
- SQLite 示例 - SQLite 数据库操作示例
- PostgreSQL 示例 - PostgreSQL 数据库操作示例
- MySQL 示例 - MySQL 数据库操作示例
- 高级 LLM 交互示例 - 与各类 LLM 的高级交互示例
多语言文档
- 英语 - English Documentation
- 法语 - Documentation Française
- 西班牙语 - Documentación en Español
- 阿拉伯语 - التوثيق باللغة العربية
- 俄语 - Документация на русском
支持与反馈
- GitHub Issues - 报告问题或请求功能
- Smithery - 简化安装和更新
可用工具
MCP 数据库工具提供了多种工具,使 AI 能够与您的数据库交互:
- dbutils-list-connections:列出配置中的所有可用数据库连接,包括数据库类型、主机、端口和数据库名称等详细信息,同时隐藏密码等敏感信息。
- dbutils-list-tables:列出指定数据库连接中的所有表,包括表名、URI和可用的表描述,按数据库类型分组以便于识别。
- dbutils-run-query:执行只读SQL查询(仅SELECT),支持包括JOIN、GROUP BY和聚合函数在内的复杂查询,返回包含列名和数据行的结构化结果。
- dbutils-describe-table:提供表结构的详细信息,包括列名、数据类型、是否可为空、默认值和注释,以易于阅读的格式呈现。
- dbutils-get-ddl:获取创建指定表的完整DDL(数据定义语言)语句,包括所有列定义、约束和索引。
- dbutils-list-indexes:列出指定表上的所有索引,包括索引名称、类型(唯一/非唯一)、索引方法和包含的列,按索引名称分组。
- dbutils-get-stats:获取表的统计信息,包括估计行数、平均行长度、数据大小和索引大小。
- dbutils-list-constraints:列出表上的所有约束,包括主键、外键、唯一约束和检查约束,对于外键约束还显示引用的表和列。
- dbutils-explain-query:获取SQL查询的执行计划,显示数据库引擎将如何处理查询,包括访问方法、连接类型和估计成本。
- dbutils-get-performance:获取数据库连接的性能指标,包括查询计数、平均执行时间、内存使用情况和错误统计。
- dbutils-analyze-query:分析SQL查询的性能特性,提供执行计划、实际执行时间和具体的优化建议。
有关这些工具的详细说明和使用示例,请参阅使用指南。
星标历史
许可证
本项目采用 MIT 许可证 - 有关详细信息,请参阅 LICENSE 文件。
Star History
Repository Owner
User
Repository Details
Programming Languages
Tags
Topics
Join Our Newsletter
Stay updated with the latest AI tools, news, and offers by subscribing to our weekly newsletter.
Related MCPs
Discover similar Model Context Protocol servers
Signoz MCP Server
Connect SigNoz observability data to AI assistants via the Model Context Protocol.
Signoz MCP Server acts as a bridge between SigNoz observability platforms and AI assistants by implementing the Model Context Protocol (MCP). It exposes a suite of tools for querying dashboard information, fetching panel and metrics data, executing custom queries, and retrieving traces or logs from SigNoz. The tool supports integration with popular AI assistants, flexible deployment options (Docker, local virtual environments), and secure configuration via environment variables or YAML files. The server is designed to enable standardized programmatic context retrieval for enhancing AI/LLM workflows.
- ⭐ 11
- MCP
- DrDroidLab/signoz-mcp-server
AIM Guard MCP
AI-powered security and safety server for Model Context Protocol environments.
AIM Guard MCP is a server implementing the Model Context Protocol (MCP), providing AI-powered security analysis and safety instruction tools tailored for AI agents. It offers features such as contextual security instructions, harmful content detection, API key scanning, and prompt injection detection, all designed to guard and protect interactions with various MCPs and external services. Built for fast integration, it connects with the AIM Intelligence API and is compatible with any MCP-compliant AI assistant.
- ⭐ 13
- MCP
- AIM-Intelligence/AIM-MCP
QuantConnect MCP Server
Official bridge for secure AI access to QuantConnect's algorithmic trading cloud platform
QuantConnect MCP Server enables artificial intelligence systems such as Claude and OpenAI to interface with QuantConnect's cloud platform through an official, secure, and dockerized implementation of the Model Context Protocol (MCP). It facilitates automated project management, strategy writing, backtesting, and live deployment by exposing a comprehensive suite of API tools for users with valid access credentials. As the maintained official version, it ensures security, easy deployment, and cross-platform compatibility for advanced algorithmic trading automation.
- ⭐ 50
- MCP
- QuantConnect/mcp-server
MXCP
Enterprise-Grade Model Context Protocol Framework for AI Applications
MXCP is an enterprise-ready framework that implements the Model Context Protocol (MCP) for building secure, production-grade AI application servers. It introduces a structured methodology focused on data modeling, robust service design, policy enforcement, and comprehensive testing, integrated with strong security and audit capabilities. The framework enables rapid development and deployment of AI tools, supporting both SQL and Python environments, with built-in telemetry and drift detection for reliability and compliance.
- ⭐ 49
- MCP
- raw-labs/mxcp
Bear MCP Server
Read-only Model Context Protocol server for Bear note integration
Bear MCP Server provides a Model Context Protocol (MCP) interface to access notes and tags stored in the Bear note-taking app. It enables AI assistants, including Claude, to securely interact with Bear notes through read-only operations, connecting directly to the Bear SQLite database without the risk of modifying user data. The server exposes tools for searching, opening, and listing notes and tags, ensuring all access is non-destructive.
- ⭐ 14
- MCP
- bart6114/my-bear-mcp-server
Thales CipherTrust Data Security Platform CAKM MCP Server
MCP server for unified database TDE/Encryption management via CipherTrust.
Thales CipherTrust Data Security Platform CAKM MCP Server implements the Model Context Protocol (MCP) for managing database encryption (TDE/EKM) with CipherTrust Application Key Management. It supports both Oracle and SQL Server, providing tools for resource-based management, comprehensive auditing, and key lifecycle operations. The server enables integration with CipherTrust Manager, automates key rotation, and offers advanced detection of TDE configurations.
- ⭐ 2
- MCP
- sanyambassi/thales-cdsp-cakm-mcp-server
Didn't find tool you were looking for?