多数据库 MCP Server
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| DB_HOST | No | 数据库主机地址 | |
| DB_MODE | No | 数据库模式：readonly（默认）或 readwrite | readonly |
| DB_NAME | No | 数据库名或 SQLite 文件路径 | |
| DB_PORT | No | 数据库端口 | |
| DB_TYPE | No | 数据库类型：oracle / sqlserver / mysql / postgres / sqlite | |
| DB_USER | No | 数据库用户名 | |
| DB_PASSWORD | No | 数据库密码 | |
| ORACLE_HOST | No | Oracle 主机地址（兼容旧配置） | |
| ORACLE_MODE | No | Oracle 模式（兼容旧配置），默认 readonly | readonly |
| ORACLE_PORT | No | Oracle 端口（兼容旧配置） | |
| ORACLE_USER | No | Oracle 用户名（兼容旧配置） | |
| DATABASE_URL | No | 完整 SQLAlchemy URL，例如 mysql+pymysql://user:pw@localhost:3306/mydb | |
| ORACLE_PASSWORD | No | Oracle 密码（兼容旧配置） | |
| ORACLE_SERVICE_NAME | No | Oracle 服务名（兼容旧配置） | |
| ORACLE_CLIENT_LIB_DIR | No | Oracle Instant Client 目录（thick 模式） |
Instructions
Guidance the server publishes about itself, which clients place ahead of the tool catalog so the model reads it before choosing anything.
This server publishes no instructions, or was last inspected before Glama recorded them.
Capabilities
Features and capabilities supported by this server
Protocol revision2025-11-25
| Capability | Details |
|---|---|
| tools | {
"listChanged": false
} |
| prompts | {
"listChanged": false
} |
| resources | {
"subscribe": false,
"listChanged": false
} |
| experimental | {} |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| execute_queryA | 执行只读 SQL 查询（仅允许 SELECT/WITH），结果以 JSON 数组返回。 Args: sql: SELECT 语句，绑定变量使用 :name 占位（不要字符串拼接值）。 schemaName: 指定默认 schema，未限定表名将解析到该 schema（如 "SCOTT"）。 |
| list_tablesA | 列出数据库中的表；指定 schema 时仅列出该命名空间下的表。 Args: schema: 目标 schema/数据库名（不区分大小写）；不传则列出当前默认命名空间下的表。 |
| describe_tableA | 查看表结构：列名、数据类型、是否可为空。 Args: table_name: 表名。 schemaName: 限定所属 schema（Oracle 为 owner，PostgreSQL 为 schema， MySQL/SQL Server 为数据库名）；不传则匹配默认命名空间中的表。 |
| test_connectionA | 测试数据库连接是否正常，返回连接状态。 |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |
TDQS
Scored across 4 tools
Each tool has a clearly distinct purpose: listing tables, running read-only queries, describing table schemas, and testing connectivity. There is no meaningful overlap or ambiguity between them.
All tool names follow the same verb_noun snake_case pattern: list_tables, execute_query, describe_table, test_connection. The naming is uniform and predictable.
With 4 tools, the set is concise and well-scoped for a read-only database MCP server. Every tool serves a necessary core function without unnecessary bloat.
The tool set covers the essential read-only database workflow: discovery (list_tables), schema inspection (describe_table), querying (execute_query), and connection validation (test_connection). No obvious gaps exist for the stated purpose.