schemacrawler-ai

Name: schemacrawler-ai
Author: schemacrawler

本地服务

schemacrawler.github.io数据库132 天前更新

代码仓库访问官网

关于 schemacrawler-ai

SchemaCrawler AI 是供 AI Agent 交互探索数据库架构元数据的 MCP 服务，基于用于发现和理解数据库架构的 SchemaCrawler。

主要功能

01探索数据库架构元数据
02交互式查询架构信息

适用场景

01检查数据库架构元数据
02通过 AI Agent 探索架构详情

MCP 相关

它通过 MCP 服务向 AI Agent 提供交互式数据库架构元数据访问。

配置

本地服务的配置在各客户端中通用，复制后粘贴到客户端的 MCP 配置文件即可。

mcp.json · 通用配置

{
  "mcpServers": {
    "schemacrawler-schemacrawler-ai": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "-e",
        "SCHCRWLR_MCP_SERVER_TRANSPORT",
        "-e",
        "SCHCRWLR_DATABASE_USER",
        "-e",
        "SCHCRWLR_DATABASE_PASSWORD",
        "-e",
        "SCHCRWLR_JDBC_URL",
        "-e",
        "SCHCRWLR_SERVER",
        "-e",
        "SCHCRWLR_HOST",
        "-e",
        "SCHCRWLR_PORT",
        "-e",
        "SCHCRWLR_DATABASE",
        "-e",
        "SCHCRWLR_DATABASE_ALIAS",
        "-e",
        "SCHCRWLR_DATABASE_DESCRIPTION",
        "-e",
        "SCHCRWLR_INFO_LEVEL",
        "-e",
        "SCHCRWLR_LOG_LEVEL",
        "-e",
        "SCHCRWLR_EXCLUDE_TOOLS",
        "schemacrawler/schemacrawler-ai:17.16.0-1"
      ],
      "env": {
        "SCHCRWLR_MCP_SERVER_TRANSPORT": "<SCHCRWLR_MCP_SERVER_TRANSPORT>",
        "SCHCRWLR_DATABASE_USER": "<SCHCRWLR_DATABASE_USER>",
        "SCHCRWLR_DATABASE_PASSWORD": "<SCHCRWLR_DATABASE_PASSWORD>",
        "SCHCRWLR_JDBC_URL": "<SCHCRWLR_JDBC_URL>",
        "SCHCRWLR_SERVER": "<SCHCRWLR_SERVER>",
        "SCHCRWLR_HOST": "<SCHCRWLR_HOST>",
        "SCHCRWLR_PORT": "<SCHCRWLR_PORT>",
        "SCHCRWLR_DATABASE": "<SCHCRWLR_DATABASE>",
        "SCHCRWLR_DATABASE_ALIAS": "<SCHCRWLR_DATABASE_ALIAS>",
        "SCHCRWLR_DATABASE_DESCRIPTION": "<SCHCRWLR_DATABASE_DESCRIPTION>",
        "SCHCRWLR_INFO_LEVEL": "<SCHCRWLR_INFO_LEVEL>",
        "SCHCRWLR_LOG_LEVEL": "<SCHCRWLR_LOG_LEVEL>",
        "SCHCRWLR_EXCLUDE_TOOLS": "<SCHCRWLR_EXCLUDE_TOOLS>"
      }
    }
  }
}

启动命令

docker run -i --rm -e SCHCRWLR_MCP_SERVER_TRANSPORT -e SCHCRWLR_DATABASE_USER -e SCHCRWLR_DATABASE_PASSWORD -e SCHCRWLR_JDBC_URL -e SCHCRWLR_SERVER -e SCHCRWLR_HOST -e SCHCRWLR_PORT -e SCHCRWLR_DATABASE -e SCHCRWLR_DATABASE_ALIAS -e SCHCRWLR_DATABASE_DESCRIPTION -e SCHCRWLR_INFO_LEVEL -e SCHCRWLR_LOG_LEVEL -e SCHCRWLR_EXCLUDE_TOOLS schemacrawler/schemacrawler-ai:17.16.0-1

需要配置的环境变量

SCHCRWLR_MCP_SERVER_TRANSPORTMCP Server transport type - valid values are 'http' or 'stdio', defaulting to 'stdio'.

SCHCRWLR_DATABASE_USER密钥Database user name. Can be optional depending on the database connection type.

SCHCRWLR_DATABASE_PASSWORD密钥Database user password. Can be optional depending on the database connection type.

SCHCRWLR_JDBC_URLJDBC URL for database connection. If this is provided, the server, host, port and database are not used.

SCHCRWLR_SERVERSchemaCrawler database plugin, for example, 'sqlserver' or 'sqlite'. Used only if the JDBC URL is not provided.

SCHCRWLR_HOSTDatabase host. Defaults to localhost. Used only if the JDBC URL is not provided.

SCHCRWLR_PORTDatabase port. Defaults to the default port for the server type. Used only if the JDBC URL is not provided.

SCHCRWLR_DATABASEDatabase to connect to (optional). Used only if the JDBC URL is not provided.

SCHCRWLR_DATABASE_ALIASOptional stable alias used to identify this database server in MCP instructions and tool results.

SCHCRWLR_DATABASE_DESCRIPTIONOptional description of this database server, included in MCP instructions and the about_database response.

SCHCRWLR_INFO_LEVELHow much database metadata to retrieve. Values are 'minimum', 'standard', 'detailed' or 'maximum'.

SCHCRWLR_LOG_LEVELLogging verbosity level. Values are 'SEVERE', 'WARNING', 'INFO', 'CONFIG', or 'FINE'.

SCHCRWLR_EXCLUDE_TOOLSMCP Server tools to exclude, as a comma-separated list.

本地服务需要在你的电脑上安装运行环境（如 Node.js 18+）。各客户端的配置文件位置不同，请参考客户端文档。

安装包

ocischemacrawler/schemacrawler-ai:17.16.0-1stdio

工具

还没有获取到工具列表

本地服务需要在你的电脑上运行后才能读取工具，维护者暂未提供工具列表。

详细介绍

:star: 如果你喜欢它，请给它点个星 :arrow_heading_up:！

SchemaCrawler AI

说明

如需了解更多详情，请参阅 SchemaCrawler 网站。

有关如何使用 MCP 服务的信息，请参阅 SchemaCrawler AI MCP Server Usage

关于

SchemaCrawler AI 提供 MCP 服务，让 AI Agent 能够以交互方式查询数据库架构元数据。它基于 SchemaCrawler，这是一个免费的数据库架构发现与理解工具。

许可

SchemaCrawler AI 根据 Business Source License 1.1（BUSL-1.1）许可。

本项目可能与 JDBC 驱动程序和其他库等第三方组件一同分发。除非另有明确说明，Business Source License 1.1 仅适用于为本仓库编写的 SchemaCrawler AI MCP 服务源代码。源代码或二进制分发包中包含的所有第三方组件均由各自的版权持有人单独许可。有关第三方许可信息，请参阅文档或分发包。

根据 Business Source License 1.1，您可以阅读、修改和重新分发源代码，但须遵守许可条款。不过，除非另有单独的商业协议许可，否则 SchemaCrawler AI MCP 服务不得用于生产或商业用途。如需用于生产或商业用途，请参阅 SchemaCrawler 网站。